SQL SERVER – Source Database in Restoring State

A client whom I often help with Comprehensive Database Performance Health Check recently reached out to me with an interesting problem about Source Database in Restoring State.

SQL SERVER - Source Database in Restoring State RestoringState-800x472

My client had used SSMS to restore the database based on the original database. After doing a restore, he was very surprised as he was able to successfully use the new database but the original database in the restoring state. It was very much a surprise to him as he had just used a database as a source and it went into restoring state.

Well, this happens when you forget to tick the tail backup option in the SSMS wizard. The fix of this situation is very simple. Just run the following statement and it will immediately fix your source database.


Here are my few recent videos and I would like to know what is your feedback about them. Do not forget to subscribe SQL in Sixty Seconds series. I hope you appreciate learning about the Last 5 SQL in Sixty Seconds Video.

If you have any questions, you can always reach out to me on Twitter.

Reference: Pinal Dave (http://blog.SQLAuthority.com)

SQL Backup, SQL Restore, SQL Scripts, SQL Server, SQL Server Management Studio, SSMS
Previous Post
SQL SERVER – Adjust Memory with Dedicated Administrator Connection (DAC)
Next Post
SQL SERVER – Converting Unix TimeStamp to DateTime

Related Posts

Leave a Reply