March 23, 2015 at 10:33 am
Hi
I use Ola Hallegren's scripts of backups, and database integrity checking. I have 2 questions.
1. Should SSISDB have Checkdb run against it
2. Ola has scripts set up for System databases and another setup for user databases. Does SSISDB fit into either of these categories?
Thanks
Kathy
March 23, 2015 at 10:44 am
Kathy
I would categorise it as a user database (although I don't think it's all that important which pigeon-hole you choose to put it in). It can't do any harm to include it in your suite of DBCC checks.
John
March 23, 2015 at 11:51 am
Thanks John
March 23, 2015 at 12:32 pm
Quick thought, unless you can afford to lose it, do the check!
😎
March 23, 2015 at 2:39 pm
Absolutely
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
March 23, 2015 at 4:08 pm
I think the difference between system databases and user databases is that SQL Server will fail to come online if the system databases are corrupt or inaccessible (or in the case of TempDB if the configured file path is inaccessible).
One of things I like to do down a downtime is make sure I have recent copies of the master, msdb and model mdf & ldf files in a folder on the C:\ drive. This can save a lot time in case these files become corrupt or the drives they are on are lost. Yes, you probably have bak backups of these databases but you can't run a restore command to restore from a bak unless the instance itself can start.
As for whether to call a SSISDB maintenance job a system or user maintenance job, do whatever makes sense to you.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply