SharePoint Content Database Issue

Category: sharepoint 2013 - setup, upgrade, administration and operations

Question

Kishore Thapa on Mon, 20 Aug 2018 12:20:49


Hi All,

I am having issue with SharePoint since past 2,3 weeks. When full backup of content database is completed, the web page stops working. There is nothing shown in web page. Content database size is about 700GB, It stats working after sql server restart. What is the cause of the issue? Please suggest me a solution.

Thank you in advance!!!

Replies

sadomovalex on Mon, 20 Aug 2018 15:31:01


check Sharepoint logs with Verbose logging after content database backup when page is empty (before restarting the SQL server). When there are problems with SQL server these logs may contain useful information.

taylor.l on Mon, 20 Aug 2018 17:52:57


Might be locked due to the size of the DB. Restarting the SQL service will release it hence why you're seeing that behavior 

If this is helpful please mark it so. Also if this solved your problem mark as answer.


Sara Fan on Tue, 21 Aug 2018 08:50:14


Hi Kishore,

Did the web page work after the SQL Server is restarted?

What page did stop working? A site page or Central Administration page? Are all pages empty?

What method did you use to perform a backup?

To troubleshoot the issue, you could check the ULS Log.

To check the ULS Log, go to C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\15\LOGS.

Best Regards,

Sara Fan

Sara Fan on Thu, 23 Aug 2018 01:25:49


Hi Kishore,

How is everything going?

Is there anything update about this issue?

If the reply is helpful to you, you could mark the reply as answer. Thanks for your understanding.

Best regards,

Sara Fan