Microsoft – SQLServer – Database Backup – Maintenance Plan “Skipping some databases”
Still reviewing database backup history log and discovered that some of our databases are not getting backed up.
Reviewing our maintenance plan and it looks clean. It is set to backup all databases, as opposed to maintenance plans with explicitly listed databases.
Everything looks good – reviewed the job log, a bit compressed and not as easy to read.
And, so modified the plan by adding “Reporting and Logging”.
Re-ran the backup and still no backup, though, now the reports is much easier to read.
I thus set forth to determine if there was something special about that database. Is its owner valid, is it online, etc…
Select the database and right click on it to access it’s property:
Noticed that the database status’s states “Shutdown, Normal”.
Also reviewed the database’s properties – Options Tab: And, confirmed that it is offline.
These two information:
- Database Status indicating “Shutdown\Normal”
- And, Database Option \ “Auto Close” stating “True”
is “telling”. The database is not getting backed-up consistently as in some cases it might be offline.
Switching off “Auto Close” will probably lead to greener pastures….