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 - SharePoint Expert with Two decades of SharePoint Experience. Love to Share my knowledge and experience with the SharePoint community, through real-time articles!

Leave a Reply

Your email address will not be published. Required fields are marked *