• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 455
  • Last Modified:

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
0
knaren1975
Asked:
knaren1975
  • 2
1 Solution
 
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.

Join & Write a Comment

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now