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.
Asked
Active
Viewed 488 times
0
-
1Why the h*** do run database backup during business hours? – Mathias R. Jessen Feb 27 '12 at 23:09
-
1@MathiasR.Jessen Maybe his business hours are 24/7 – Wesley Feb 28 '12 at 01:25
1 Answers
1
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.
Publiccert
- 1,110
- 1
- 8
- 22
-
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
-