October 9, 2008 at 11:56 am
Hi All,
If a system crashes during a restore process, than is there a way figure out the last restored point.
Regards,
[font="Verdana"]Sqlfrenzy[/font]
October 9, 2008 at 12:03 pm
Are you asking if you can restart the restore from the point of failure? No. You have to restart the restore from the beginning of the process.
(But then again, I may be mistake, but I haven't seen any way to do this yet.)
😎
October 9, 2008 at 12:20 pm
RESTART
Note:
Supported only by RESTORE.
Specifies that SQL Server should restart a restore operation that has been interrupted. RESTART restarts the restore operation at the point it was interrupted.
http://msdn.microsoft.com/en-us/library/ms178615(SQL.90).aspx
Someone in the MVP group pointed this out to me this year.
October 9, 2008 at 1:27 pm
Learn something new every day on this site!
Keep up the good work, Steve!
😎
October 9, 2008 at 1:49 pm
Steve Jones - Editor (10/9/2008)
RESTARTNote:
Supported only by RESTORE.
Specifies that SQL Server should restart a restore operation that has been interrupted. RESTART restarts the restore operation at the point it was interrupted.
Thnks steve....
though we can restart from the point of interruption, however is it possible to get the exact point of interruption..something like timestamp ...
Regards,
[font="Verdana"]Sqlfrenzy[/font]
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply