Two times a day, a SharePoint snapshot starts up. - In the SQL Server Log this message appears;

12/31/2015 9:11:45AM Starting up database 'WSS_INTRANET_AZDOA_GOV_20151231_161138_1989585'. When staff comes into work to use SharePoint, the transactions get blocked by this query;


Can anyone tell me what is going on? And how I can stop it from happening?

  • can you tell us what is the SQL configuration including server architecture/topology – kesava Jan 4 '16 at 20:51
  • SQL Server 2012 on an EC2 instance in the AWS Cloud – Peggy Jan 4 '16 at 21:07
  • 1
    This query is inserting document content (Word, Excel, etc.) into DocStreams. What do you mean by "SharePoint snapshot"? – Trevor Seward Jan 4 '16 at 21:12
  • 2
    When this database starts up twice a day, I could not do anything with it because SQL Server recognizes it as a snapshot - I tried to put it into Single user mode. So getting back to my original question Why is data from the snapshot being inserted into the main SharePoint database, WSS_INTRANET_AZDOA_GOV? – Peggy Jan 4 '16 at 21:35

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.