Comments
Sort by recent activity
Would it be OK, if I could ask you of how to access SQL backup internal database, apart from the command you had posted.
That would help me in creating a datastore, from which I could derive the information that I require. I am comfortable running this command directly from my reporting tool
Thanks again! / comments
Would it be OK, if I could ask you of how to access SQL backup internal database, apart from the command you had posted.
That would help me in creating a datastore, from which I could derive the in...
petey wrote:
If you are using version 5, here's something you can use to quickly compare the total compressed size against the total native backup size, for all backups made to date using v5: EXEC master..sqbdata 'SELECT (SUM(size) / 1048576) TotalNativeMB, (SUM(compressed_size) / 1048576) TotalCompressedMB FROM backuphistory'
I ran this command and I think this takes information from the msdb database. As we clean the history regularly from the msdb database, the numbers that we get, may not reflect the complete picture.
Any suggestions ? / comments
petey wrote:
If you are using version 5, here's something you can use to quickly compare the total compressed size against the total native backup size, for all backups made to date using v5:EXE...