Wednesday 29 April 2015

How to restore huge backup if its stop in between restoring time due to power failure,restart Server or connection failure?

Today I found one interesting thing related to restore backup failure example you are restoring a huge backup on SQL server and you found that only 10 % backup restore pending that we be restore soon and you send the email to client with full confidence backup will be finish with in 30 or 40 minutes. then suddenly backup got failed due to some network issue or power failure  restart the server by somebody mistakenly . So how you will proceed again  .the first thing come in mind we have to start restore operation from beginning and need a lot of time to restore .


But here we can use one technique if you don't want to restore backup from starting.

Here is great feature provided by Microsoft that is WITH RESTART option.

You can restart the failure backup from the same point where is got stopped.

See below command :-

You can see in below scree shot the Advetureworks2012 database in restoring state because server got stopped when it was restoring from backup and when we strat server again it gone in restoring state . 










Here you can restart your interrupt backup again with the following command and it will work as below :)

RESTORE  DATABASE AdventureWorks2012 FROM DISK='D:\AdventureWorks2012.BAK' WITH RESTART






Thanks :)


No comments:

Post a Comment