Full Backup Report

Question

Full Backup Report

Arjun SreeVastsva

SSCertifiable

Points: 7141
More actions
October 9, 2015 at 7:31 pm

#321439

Hi,
according to envionemnet .we are planning to genrate the weekly full backups report of all the servers.i have developed the SSIS Package that will run in all servers and genrate the report.but i want to caputure the full backups only with location.
Can any one provide script for this.
format is like
ServerName Database ReoveryModel FullBackup(Date&Time) BackupLocation
Can anyone give the script please

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

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

Jeff Moden SSC Guru Points: 1004407 More actions · Answer 1

Arjun SreeVastsva (10/9/2015)
Hi,
according to envionemnet .we are planning to genrate the weekly full backups report of all the servers.i have developed the SSIS Package that will run in all servers and genrate the report.but i want to caputure the full backups only with location.
Can any one provide script for this.
format is like
ServerName Database ReoveryModel FullBackup(Date&Time) BackupLocation
Can anyone give the script please

You should do this yourself so that you learn more about the underlying tables in MSDB. Get a copy of "Books Online" (the documentation that used to come with SQL Server) and lookup the backup related tables in MSDB. I'd also recommend that if you're using this weekly report as the only source of information as to whether backups actually occurred or not, then you're going to have a real problem someday. You need to know that a backup failed as soon as it fails.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Arjun SreeVastsva SSCertifiable Points: 7141 More actions · Answer 2

i have tried to get the code but unable to get complete output.