Solved

maintenance plan export

Posted on 2014-04-08
2
275 Views
Last Modified: 2014-04-29
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
Comment
Question by:pma111
2 Comments
 
LVL 16

Accepted Solution

by:
Wasim Akram Shaik earned 250 total points
ID: 39985423
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
 
LVL 69

Assisted Solution

by:Éric Moreau
Éric Moreau earned 250 total points
ID: 39985600
right click on your MP and generate a script from it
0

Featured Post

Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

Join & Write a Comment

Suggested Solutions

Entering a date in Microsoft Access can be tricky. A typo can cause month and day to be shuffled, entering the day only causes an error, as does entering, say, day 31 in June. This article shows how an inputmask supported by code can help the user a…
CCModeler offers a way to enter basic information like entities, attributes and relationships and export them as yEd or erviz diagram. It also can import existing Access or SQL Server tables with relationships.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

705 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now