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 |
|
shazz
Starting Member
1 Post |
 Posted - 2014-11-05 : 03:40:07
|
| Hi all,An expert please help me on :1. How do I add my new database created into existing subplan maintenance wizard for auto backup working?The maintenance plan wizard already have several database. I just add new database. And now how do I able to add it into the maintenance plan wizard? Should I drag in or else?please advisethank younil |
|
|
jeffw8713
Aged Yak Warrior
819 Posts |
Posted - 2014-11-10 : 13:27:49
|
| You don't use the Wizard - you just have to open the existing maintenance plan, open each task - and add the database. |
 |
|
|
Shanky
Yak Posting Veteran
84 Posts |
Posted - 2014-11-11 : 06:48:36
|
| From what I can read you want that whenever a new database is created it should automatically add to MP backup. Its very easy when you create MP and reach page where you select list of database(Define back Up Database(full) task page) in Databases from drop down please select all database radio button if you do so whenever it will execute it will backup all databases automatically.Hope this helpsRegardsShankySQL Server MVPhttp://social.technet.microsoft.com/wiki/contents/articles/24253.list-of-articles-by-shanky.aspx |
|
|
|
|
|
|
Maintenance Plan wizard