June 16, 2009 at 11:31 am
Surely, there has got to be a way to do this. We have added new databases to our SQL server, and they want me to add these databases to our nightly backup which is done in a maintenance plan. I can't find anywhere that allows me to select new databases. I click modify and it only allows me to change the backup schedule. What am I missing here? Thanks!
June 16, 2009 at 11:39 am
txdave35 (6/16/2009)
Surely, there has got to be a way to do this. We have added new databases to our SQL server, and they want me to add these databases to our nightly backup which is done in a maintenance plan. I can't find anywhere that allows me to select new databases. I click modify and it only allows me to change the backup schedule. What am I missing here? Thanks!
Double click the backup plan, in the databases drop down, check the newly created database, then save the maintainance plan.
June 16, 2009 at 11:47 am
Where are you clicking on modify? Are you trying to modify the SQL Server Agent job, or the Maintenance Plan?
For SSMS Maintenance Plans, you should not modify the agent job because the next person that comes along and modifies the maintenance plan can overwrite your changes to the agent job.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
June 16, 2009 at 11:49 am
Thanks! For some reason, I didn't think to click the drop down. lol
June 16, 2009 at 11:51 am
I was clicking under Management - Maintenance Plans.
June 16, 2009 at 11:53 am
txdave35 (6/16/2009)
Thanks! For some reason, I didn't think to click the drop down. lol
LOL:-D. Glad u got it going finally.
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply