Wednesday, October 17, 2012

Restore database with restart

Restore database with restart option is available since SQL Server 2005 onwards. This option is very helpful while restoring very large databases. If a restore was failed due to some reason then using Restart
option we can start restore from the failed point which helps to save time in VLDB.

If a restore operation fails then database will be in restoring mode, to bring it to online then we cam use restore with replace or we can use restore with restart

Restore with Replace -- It performs restore from starting onwards.

Restore with Restart -- It performs restore from failed point onwards. (we can save time in this option)

Restore database kalyandb from disk = 'c:\fullbackups\kalyandb.bak' with restart

No comments: