SQL2005 database status change

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

SQL2005 database status change

Author

Topic

mcbinu
Starting Member

3 Posts

Posted - 2008-08-05 : 07:42:42

How can I change the status of a database to STANDBY Mode from RECOVERY mode

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-08-05 : 09:03:43

Do you mean Read-Only ? You can do through Database Properties.

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-08-06 : 23:31:16

Tried 'restore database db_name with standby = ...'?

mcbinu
Starting Member

3 Posts

Posted - 2008-08-08 : 00:48:46

Tried 'restore log db_name with stand by',but it says "database already in fully recoverd state"

mdubey
Posting Yak Master

133 Posts

Posted - 2008-08-08 : 16:00:55

Ok, This doesn't make any sense for me.

1)Take the Full backup,
2) Restore thebackup file over to the existing Database with Standby mode.

I beleive this is what you are looking for.

Manoj
MCP, MCTS

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-08-08 : 16:17:33

Did you refresh your screen after the "restore with recovery"?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

hitesh6221
Starting Member

28 Posts

Posted - 2008-08-11 : 07:44:13

Hi
Its better to use Mirroring or LogShipment

Regards,
Hitesh Soni

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-08-11 : 08:56:46

quote:
Originally posted by hitesh6221

Hi
Its better to use Mirroring or LogShipment

Regards,
Hitesh Soni

Does this relate with OP's Question? And There is no "Logshipment" in SQL Server. Please get details from Booksonline and post.

hitesh6221
Starting Member

28 Posts

Posted - 2008-08-12 : 01:20:10

Sodeep Please check this link for Idea about Log Shipping(ment)

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/55da6b94-3a4b-4bae-850f-4bf7f6e918ca.htm

Regards,
Hitesh Soni

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-08-12 : 08:17:19

You don't have to show ideas about Log shipping . I have been working with it since SQL server 7.5 and SQL 2000(Custom Log shipping)

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources