Brings the database online - in read-only mode so it can be queried.
Also allows restores to "continue" when more backup files become
available.

Typical usage scenario is on a "warm standby" to have it to standby, so
the standby can be used for reading near-time data. But still be able
to restore forward without beginning again from the FULL restore.

Dano Smith


-----Original Message-----
From: Mahtab
[mailto:mssqldba-ezmlmshield-x55867273.[Email address protected]
Sent: Friday, September 29, 2006 7:03 AM
To: LazyDBA Discussion
Subject: Use of STANDBY Parameter [bcc][faked-from]
Importance: Low

Hi DBA's

Can anyone please explain the use of 'STANDBY = undo_file_name' with
RESTORE command

Mahtab



---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


MS Sql Server LazyDBA home page