restore

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » restore

restore

Rate Topic

Display Mode

Topic Options

Author

Message

charipg

Posted Wednesday, August 12, 2009 9:53 AM

Old Hand

Group: General Forum Members
Last Login: Thursday, May 16, 2013 12:43 AM
Points: 378, Visits: 897

what is the difference between stanby,recovery,norecovery options when doing restore.

Post #769455

Animal Magic

Posted Wednesday, August 12, 2009 9:55 AM

SSC Eights!

Group: General Forum Members
Last Login: Monday, June 10, 2013 7:21 AM
Points: 983, Visits: 13,356

recovery bring the database online and allows full database activity.

norecovery leaves the database in a restoring state ready for the next backup file to be applied (nobody can connect in this state)

Standy puts the database in a read only state and is normally seen in this state during a log shipping scenario.

Why do you ask? do you have a specific problem or is just a general knowledge question?

Post #769458

murthykalyani

Posted Wednesday, August 12, 2009 9:56 AM

SSC-Addicted

Group: General Forum Members
Last Login: Tuesday, May 08, 2012 7:35 PM
Points: 474, Visits: 1,345

Please refer to SQL Server BOL
or
http://msdn.microsoft.com/en-us/library/ms186858(SQL.90).aspx

Post #769460

« Prev Topic | Next Topic »

Permissions