We use STANDBY to create a standby server, which is left in a read-only
state between restore operations. The STANDBY file can be used to undo
a restore, since read-only files can't be backed up.

-----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


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