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 - Information Technology Expert with Two-decades of hands-on experience, specializing in SharePoint, PowerShell, Microsoft 365, and related products. He has held various positions including SharePoint Architect, Administrator, Developer and consultant, has helped many organizations to implement and optimize SharePoint solutions. Known for his deep technical expertise, He's passionate about sharing the knowledge and insights to help others, through the real-world articles!

Leave a Reply

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