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.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Maintenance Plan wizard

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 advise

thank you

nil

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.
Go to Top of Page

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 helps

Regards
Shanky
SQL Server MVP
http://social.technet.microsoft.com/wiki/contents/articles/24253.list-of-articles-by-shanky.aspx
Go to Top of Page
   

- Advertisement -