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

Problem: Suddenly SharePoint Database Went Offline!
sql server database is offline
Analyzed Event Logs and found the Database went offline because of Backup failure.
MSSQLSERVER EVENT ID 3041
SQL Server: How to Bring Database Online?

Alright, How to Bring it back Online? One line T-SQL!

ALTER DATABASE STS_G1WSS01_1385353007 SET ONLINE

sql server bring database onlineNow the database is up, and we are back to business!

Salaudeen Rajack

Salaudeen Rajack is a SharePoint Architect with Two decades of SharePoint Experience. He loves sharing his knowledge and experiences with the SharePoint community, through his real-world articles!

Leave a Reply