compression backup

• jmaksons2

  Grasshopper

  Points: 10

  More actions

  July 15, 2015 at 3:04 am

  #302356

  Hello, can you suggest an easy way to compress backup file. I use SQL Server 2008 R2

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  July 15, 2015 at 3:21 am

  #1812557

  Use SQL's native backup compression.

  Gail Shaw
  Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
  SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

  We walk in the dark places no others will enter
  We stand on the bridge and no one may pass

• TEJABI

  Old Hand

  Points: 368

  More actions

  July 15, 2015 at 5:55 am

  #1812581

  please follow for below given link then you will be get idea

  https://www.mssqltips.com/sqlservertip/1513/exploring-database-backup-compression-in-sql-server-2008/

• jmaksons2

  Grasshopper

  Points: 10

  More actions

  July 15, 2015 at 7:39 am

  #1812627

  TEJABI (7/15/2015)

  ---

  please follow for below given link then you will be get idea

  https://www.mssqltips.com/sqlservertip/1513/exploring-database-backup-compression-in-sql-server-2008/%5B/quote%5D

  Thanks, really an intresting article.

• apogoreliy

  SSC Journeyman

  Points: 94

  More actions

  July 15, 2015 at 7:49 am

  #1812630

  Backup compression is set off by default. There ia an opportunity to override the default setting when you are creating a single backup or when you set up a schedule for a series of routine backups.

  There is another an interesting article which shows how to configure compression for backup different kinds of SQL Servers versions 2008 and later (2008 R2, 2012).[url= http://sqlbak.com/blog/how-to-configure-backup-compression/%5D http://sqlbak.com/blog/how-to-configure-backup-compression/%5B/url%5D Hope it will be useful