Activity overview
Latest activity by Saran
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...
A Control in SQL 2005 Maintenance Plan
I would like to have a control for SQL Backup inside my Integration Services / Maintenance Plans for my SQL 2005. That would enable me to create my custom way of backing up a database with compress...
SQLBackup ROI Calcluation
How hard would it be to provide the tool with an ROI numbers. I need to show the management that $ that we are saving because of using SQL backup.
It would also enable me to budget for my future
Th...