• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 450
  • 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

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

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