Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
pdset
Constraint Violating Yak Guru
310 Posts |
 Posted - 2011-01-10 : 16:23:50
|
| For some other Upgrade process we have DISABLED the Maintenance plan which governs automatically every day performing FULL BACKUPS.[Before the DISABLE All Databases (User + System) were successfully Backed up].After the Upgrade of application, ENABLED the FULL BACKUP MAintenance Plan and last night it has been performed BUT without the MASTER, MODEL and MSDB (System Databases). Though I have manually performed the FUll backups on these System Databases I wonder why the Maintenance Plan didn't picked up these backups now.What I have done was, I simply made the Maintenance Plans on the Server Agent got DISABLED and later ENABLED. All other activities were normal only this has happened.In the event if this is not done tomorrow where I need to encroach for the cause, and what Shall I do to get them (Full Backup for System Databases also procured along with User databases).Can Anyone suggest me in this regard, many thanks for your advise. |
|
|
Peter99
Constraint Violating Yak Guru
498 Posts |
Posted - 2011-01-10 : 16:31:28
|
| Check maintenance plan if system databases are included. |
 |
|
|
pdset
Constraint Violating Yak Guru
310 Posts |
Posted - 2011-01-10 : 18:40:17
|
| if you recall - All the Databases includes SYSTEM + USER Databases were performed with Full Backups on maintenance Plans.Just inbetween DISABLE and ENABLE the SYSTEM databases were missed out.Thanks for your suggestion. |
|
|
|
pdset
Constraint Violating Yak Guru
310 Posts |
Posted - 2011-01-11 : 16:43:14
|
| Please can anyone through some light on this nuances of why the System Dtaabases were not picked up during Maintenance plan automatically. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
SYSTEM Databases Backup