kwizcom banner advertisement

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.
MSSQLSERVER EVENT ID 3041
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!
SharePoint SQL Server Database Went Offline Mode - How to Bring it back to Online? SharePoint SQL Server Database Went Offline Mode - How to Bring it back to Online? Reviewed by Salaudeen Rajack on November 22, 2012 Rating: 5

No comments:

Please Login and comment to get your questions answered!

Powered by Blogger.