Sql compression and backing up in sql server 2005

Question

Hi there

I want to backup my database with compression. This is my code :

BACKUP DATABASE dbbbb
TO DISK = N'C:\\dbbb.bak'
WITH COMPRESSION

this running correctly in Sql Server 2008. But my server has Sql Server 2005 and COMPRESSION is not a recognized BACKUP option in 2005. How can i compress my backup in 2005

Thank you for your helps.

Answer 1

You compress the generated file. Backup compression was added in 2008, so - sorry, out of luck.

Answer 2

Following on from TomTom, if you're in the situation with not enough disk space for your backup then you can attach an external USB drive or compress the target folder using NTFS