Search This Blog

Friday 10 March 2017

SQL Server Database stuck in “Restoring” state

If You have a SharePoint server. you have an issue with your backup tool and now some of your databases are stuck in restoring state!












You run the following query against the SQL Server instance and found that the database immediately became usable:


RESTORE DATABASE <database name> WITH RECOVERY

After apply the query facing the result is OK.













You can apply as same in all Databases.

No comments:

Post a Comment