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.
- 1Why the h*** do run database backup during business hours?Mathias R. Jessen– Mathias R. Jessen2012-02-27 23:09:10 +00:00Commented Feb 27, 2012 at 23:09
- 1@MathiasR.Jessen Maybe his business hours are 24/7Wesley– Wesley2012-02-28 01:25:28 +00:00Commented Feb 28, 2012 at 1:25
Add a comment |
1 Answer
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.
- 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– Bryan2012-02-28 16:45:26 +00:00Commented Feb 28, 2012 at 16:45
- Yes this is normall for sharepoint.Zapto– Zapto2012-03-01 20:56:16 +00:00Commented Mar 1, 2012 at 20:56