Hi:
Is anyone using the new Backup Compression feature in SQL SERVER 2008? If so, have you run into any issues, and have you restored a compressed backup without any issues?
I know there are several tools available to compress backups, but I am looking for the tried and true type, and if possible, one that is not a resource intense program.
Thanks,
James
James,
Our 13.5 GB database backs up to a 2.1 GB backup file.
Jeff Stahel
Database Administrator
Tennessee Performing Arts Center
505 Deaderick Street
Nashville, TN 37243
Phone: 615-782-4021
mailto:jstahel@tpac.org
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of James Fairfield Sent: Friday, January 20, 2012 5:48 PM To: Jeff Stahel Subject: Re: [Tessitura Technical Forum] SQL SERVER 2008 - Backup Compression
Jeff:
Thank you, that is good to know. One more question, do you know by how much the files decreased in size?
From: Jeff Stahel <bounce-jeffstahel5025@tessituranetwork.com> Sent: 1/20/2012 5:20:38 PM
Hi James,
We are using the backup compression functionality in SQL Server 2008 R2 and it is working very well for us. I have been able to restore compressed backups of our live database to the test system with no problems at all.
I have been using Ola Hallengren's maintenance solution, which is a free and well documented set of stored procedures, which makes the backup process quick and easy to implement.
Jeff
This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!