• Replies 3 replies
  • Subscribers 336 subscribers
  • Views 8 views
  • Users 0 members are here
Related

SQL SERVER 2008 - Backup Compression

Former Member
Former Member $organization

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

Parents
  • $organization

    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

Reply
  • $organization

    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

Children