Compression in SQL Server 2008

5 pts.
Tags:
SQL Server 2008
how can i use compress backup option  in sqlserver 2008r2 

Software/Hardware used:
software

Answer Wiki

Thanks. We'll let you know when a new response is added.

BACKUP DATABASE [dbname] TO DISK = N’drive:\path\filename.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.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Subhendu Sen
    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
    28,600 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following