Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have SharePoint 2007. When the database backups run using SQLCMD, SharePoint sites go into read-only. Users can't add anything to the sites and the buttons are grayed out. On the backend the databases do not get set to read-only. My question is this, is this normal with SharePoint? I have read some forums that say SharePoint does this by default but the information is a little murky.

share|improve this question
Why the h*** do run database backup during business hours? – Mathias R. Jessen Feb 27 '12 at 23:09
@MathiasR.Jessen Maybe his business hours are 24/7 – Wesley Feb 28 '12 at 1:25

This is standard practice. You wouldn't want your users trying to submit changes to a database that is being backed up. Also, stop doing backups during production hours. Schedule them for after-hours or something. It's very poor practice to do otherwise.

share|improve this answer
It is 24X7 and we have a set of users that edit a log for turnover for the next shift. SQL 2005 t-sql backups do not lock or put databases in read-only. My question is, is this normal for sharepoint? – Bryan Feb 28 '12 at 16:45
Yes this is normall for sharepoint. – t1nt1n Mar 1 '12 at 20:56

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.