• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 298
  • Last Modified:

maintenance plan export

Is there any easy way to write a query in SQL to enumerate what backup policy has been configured for all databases in an instance, i.e. backup type, schedule, and where the backup is being written too? I appreciate you can get last backup type reports, but I was more after getting copies of the actual backup plan to CSV.
0
pma111
Asked:
pma111
2 Solutions
 
Wasim Akram ShaikCommented:
I got a link to do the same from web.. check out if this helps

http://sqlservernewbie.blogspot.in/2008/10/how-to-importexport-sql-server.html
0
 
Éric MoreauSenior .Net ConsultantCommented:
right click on your MP and generate a script from it
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now