Microsoft SQL Server: zipping backup and performance

  • mangeshdeshpande / 204 / Wed, 24 Jun 2009 01:55:00 GMT / Comments (2)
  • Hi
    I have a 100GB database. I need to refresh the database on stage every night with min time.

    Most time is consumed in copying the files across network. What is best tool available to zip/compress my backup files.

    Thanks
    Mangesh
  • Keywords:

    zipping, backup, performance, microsoft sql server

  • http://database.itags.org/sql-server/382153/«« Last Thread - Next Thread »»

    1. Take a look at Sql LiteSpeed from www.imceda.com It can significantly reduce
      the backup and restore time.
      Andrew J. Kelly SQL MVP

      "Mangesh Deshpande" <MangeshDeshpande...discussions.microsoft.com> wrote in
      message news:F22AA944-3F3D-47EF-BCC6-247FF37112B8...microsoft.com...
      > Hi
      > I have a 100GB database. I need to refresh the database on stage every
      > night with min time.
      > Most time is consumed in copying the files across network.
      > What is best tool available to zip/compress my backup files.
      > Thanks
      > Mangesh

      andrewj_kelly | Tues, 03 Jun 2008 22:57:00 GMT |

    2. IMCEDA has a product called SQL LiteSpeed
      http://www.imceda.com/Home.htm
      http://www.imceda.com/LiteSpeed_Description.htm

      Red Gate has a product called SQL Backup
      http://www.red-gate.com/sql/sql_backup.htm
      Keith

      "Mangesh Deshpande" <MangeshDeshpande...discussions.microsoft.com> wrote in
      message news:F22AA944-3F3D-47EF-BCC6-247FF37112B8...microsoft.com...
      > Hi
      > I have a 100GB database. I need to refresh the database on stage every
      > night with min time.
      > Most time is consumed in copying the files across network.
      > What is best tool available to zip/compress my backup files.
      > Thanks
      > Mangesh

      keithkratochvil | Tues, 03 Jun 2008 22:59:00 GMT |