I have a database sizing 55 GB. The database backup job created on SQL Server 2005 Maintenance Plan.
The total disk space on the drive is 100 GB . The retention period for the database backup is 22 Hours.
The full database backup job scheduled by 10:00 PM daily, based on the client requirement.
Since the backup job created using SQL Server 2005 Maintenance plan, it require double the disk space to have successfull backup.
Because, as per design the yesterday backup (55 GB ) will be deleted only on successful of todays backup.
We advised the client to delete the yesterday database backup before database backup job kick on today. This client rejected as on any eventuality happening during the backup job window, we will not be able to recover the database.
Client advising to have a look on the following options,
1. Use pZip, 7-Zip, WinZip to compress the database backup after SQL Server database backup job completion.
2. Strip the database backup with multiple backup devices on the same disk volume. Enable the NTFS compression on the backup device folder.
I would welcome any workaround ,good solution on handling this issue.
Sivaprasad S - [ SIVA ]http://sivasql.blogspot.com/