Post reply

Backup Report

  • February 20, 2011 at 6:15 am

    #235278

    Hi Experts,

    I have more than 250 servers and i need to take daily backup report from all these to a text file or excel. How can i achive the same???

    Right now i have a batch file which calls a text file having server names one by one and then .sql file having the select on msdb database to fetch the last backup inform. this will be writtent o a text file.Which again i have to format.

    IS there any easy method to achive this.

  • February 24, 2011 at 10:42 am

    #1291120

    There are different ways of looking for backup information; one is to use msdb (fails if your server's crashed already), another is to look at the backup files themselves.

    Regardless, you're going to need a centralized repository of all SQL Servers (at minimum), after which you can work with backups in a more automated fashion, perhaps with one of the dynamic methods (OPENQUERY/OPENROWSET, etc.)

    Perhaps your backup jobs can put information into a central repository, and a central server can go out and check for file existance and/or do sample restores?

    http://www.sqlservercentral.com/Forums/Topic440139-146-1.aspx; msdb Full backup checks that also look at whether or not the files exist at the location listed

  • March 1, 2011 at 1:20 pm

    #1293178

    You could create an SSRS report that will do this. Base your query off the job id for each backup job and then using that job id in the msdb database get the information you are looking for like date/time completed, job status, duration, etc. Once you have that query, you can make that a dataset in SSRS and set up a subscription to email you out the results in a format (Excel) that you want it in.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply