Home > IT Answers > SQL Server > Compression in SQL Server 2008
Sanjaygutta
5 pts.
 Compression in SQL Server 2008
compressed backup, SQL Server 2008
how can i use compress backup option  in sqlserver 2008r2 

Software/Hardware used:
software
ASKED: November 4, 2011  5:35 AM
UPDATED: May 18, 2012  10:51 PM
RELATED QUESTIONS
Answer Wiki:
BACKUP DATABASE [dbname] TO DISK = N'drive:pathfilename.bak' WITH NOFORMAT, NOINIT, NAME = N'Name Database Backup', SKIP, NOREWIND, NOUNLOAD, COMPRESSION, STATS = 10 GO Or use the GUI and just specify to use compression on the options tab.
Last Wiki Answer Submitted:  May 18, 2012  10:50 pm  by  Colin Smith   845 pts.
All Answer Wiki Contributors:  Colin Smith   845 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

There r two ways to take compress bkups !
Server level, which is by default. If u simply enable it by the following script….
use master;
go
exec sp_configure ‘backup compression default’, ’1′;
reconfigure with override;

another is database level, which is non-default and create a backup by making use of the compression option in the backup. Go to Object explorer of SSMS & select database / DB > properties > tasks > backup > options> compression. That’s it !

For more & good info, plz go here

Subhendu Sen
 22,125 pts.