August 23, 2011 at 12:30 pm
Can I run any maintenance jobs on a read-only database?
Thanks.
August 23, 2011 at 12:32 pm
Backups and integrity checks, not index rebuilds or stats updates.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 23, 2011 at 12:44 pm
Thanks Gail. Is it necessary to run integrity checks on the databases which are marked read-only? I may be wrong but since the data won't change, I'm assuming DBCC CheckDB isn't necessary.
August 23, 2011 at 12:47 pm
Sure it is.
Corruption is typically an IO subsystem problem. A misbehaving IO subsystem isn't going to check and see if the DB is flagged as read-only before mangling it.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 23, 2011 at 12:54 pm
That answers my question. Thanks Gail.
August 23, 2011 at 1:11 pm
Forgot to ask one last question:
Is it necessary to run any kind of maintenance jobs on static databases? These static databases will not be marked read-only.
August 23, 2011 at 1:29 pm
Same thing, backup once after it becomes static, checkDB still necessary.
If it's static, make it read-only.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply