Link to home
Start Free TrialLog in
Avatar of knaren1975
knaren1975

asked on

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
ASKER CERTIFIED SOLUTION
Avatar of barlet
barlet
Flag of North Macedonia image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of knaren1975
knaren1975

ASKER

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
It is just part of the STANDBY FileName.
As rajeevnandanmishra said, it is just the file name!