Restoring sqlserver database with standby

Hi

How to restore database with standby mode using T-Sql command. as far as I know we need to use the following command

restore database test
from disk = '......bak'
with standby

is there any other parameters we need to add to the above command.

Thx
Naren
knaren1975Asked:
Who is Participating?
 
barletCommented:
Please have a look at the link below... it explains how to restore with standby option
http://sqlserverpedia.com/wiki/Restore_With_Standby
0
 
knaren1975Author Commented:
Hi

I gone through the link which you sent ..thx for the link. I have one query related to the restore command

RESTORE DATABASE [DisasterDatabase]
  FROM  DISK = N'C:\MSSQL\BACKUP\DisasterDatabase.bak'
  WITH  FILE = 2,
  REPLACE,
  STANDBY = N'C:\MSSQL\BACKUP\ROLLBACK_UNDO_DisasterDatabase.BAK'

in the above command (5th line) ROLLBACK_UNDO ..any idea what exactly it do ...

Thx
Naren
0
 
rajeevnandanmishraCommented:
It is just part of the STANDBY FileName.
0
 
barletCommented:
As rajeevnandanmishra said, it is just the file name!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.