Solved

Restoring sqlserver database with standby

Posted on 2012-04-03
4
417 Views
Last Modified: 2012-04-03
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
Comment
Question by:knaren1975
  • 2
4 Comments
 
LVL 7

Accepted Solution

by:
barlet earned 500 total points
ID: 37799780
Please have a look at the link below... it explains how to restore with standby option
http://sqlserverpedia.com/wiki/Restore_With_Standby
0
 

Author Comment

by:knaren1975
ID: 37799803
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
 
LVL 9

Expert Comment

by:rajeevnandanmishra
ID: 37799834
It is just part of the STANDBY FileName.
0
 
LVL 7

Expert Comment

by:barlet
ID: 37799883
As rajeevnandanmishra said, it is just the file name!
0

Featured Post

Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

I wrote this interesting script that really help me find jobs or procedures when working in a huge environment. I could I have written it as a Procedure but then I would have to have it on each machine or have a link to a server-related search that …
Nowadays, some of developer are too much worried about data. Who is using data, who is updating it etc. etc. Because, data is more costlier in term of money and information. So security of data is focusing concern in days. Lets' understand the Au…
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

757 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now