Thursday, November 22, 2012

SharePoint SQL Server Database Went Offline Mode - How to Bring it back to Online?

Suddenly SharePoint Database Went Offline.
sql server database is offline
Analyzed Event Logs and found Database went offline because: Backup failure.

SQL Server How to Bring Database Online?
Alright, How to Bring it back to Online? one line T-SQL!

ALTER DATABASE STS_G1WSS01_1385353007 SET ONLINE

sql server bring database online
Database is up and we are back to business!



You might also like:
SharePoint Usage Reports
Usage reports, collaboration and audit for SharePoint.
Document SharePoint Farm
Automatically generate SharePoint documentation.
*Sponsored


Check out these SharePoint products:

No comments :

Post a Comment

Please Login and comment to get your questions answered!

You might also like:

Related Posts Plugin for WordPress, Blogger...