Microsoft SQL Server: zipping backup and performance

  • anonymous / 205 / Wed, 24 Jun 2009 01:56: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/382155/«« 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

      andrew | Mon, 02 Jun 2008 01:11: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

      keith | Mon, 02 Jun 2008 01:12:00 GMT |