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)
 Where are the maintenance plans stored?

Author  Topic 

andrewhopkinson
Yak Posting Veteran

63 Posts

Posted - 2010-07-22 : 14:46:38
I have created a backup plan using the maintenance plan wizard, but I would like to modify it so the backup file names include the server name as well. Is there a way to do this? thanks.

YellowBug
Aged Yak Warrior

616 Posts

Posted - 2010-07-23 : 04:02:02
From the GUI, connect to the database server then navigate to Management --> Maintenance Plans

Does that help?
Go to Top of Page

andrewhopkinson
Yak Posting Veteran

63 Posts

Posted - 2010-07-23 : 08:59:29
No I mean what database are they stored in, is there a way to modify the SQL statements that create the backups?
Go to Top of Page
   

- Advertisement -