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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
It is just part of the STANDBY FileName.
As rajeevnandanmishra said, it is just the file name!
ASKER
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\Disaster
WITH FILE = 2,
REPLACE,
STANDBY = N'C:\MSSQL\BACKUP\ROLLBACK
in the above command (5th line) ROLLBACK_UNDO ..any idea what exactly it do ...
Thx
Naren