52 Hours to Back Up a 17.5 TB DB

  • imani_technology

    SSCertifiable

    Points: 7981

    A vendor just informed me that it takes them 52 hours to back up our 17.5 TB SQL Server 2008 R2 Database.  That seems VERY slow to me.  Is it just me?  Here is what I know:

    SQL Server 2008 R2 On Prem
    Simple Recovery Mode
    Using LiteSpeed by Quest for backup software
    Backing up to a NAS on the same network/site

  • richardwillemain

    SSC Veteran

    Points: 291

    Would the transfer rate be approx 98 MB/sec ?  No idea what details you gave your vendor, but chances are it might be an [optimistic} estimate., since they may know their performance specs best.  Alot of variables to consider, including who or what else might be using the NAS and how well it is interfaces to the server's storage subsys, etc.  I'd suggest making a test db  of know size, and do some basic sanity-checks, then project with alot leeway !    Best luck in any event.

  • alen teplitsky

    SSC-Dedicated

    Points: 30014

    This will depend on your IO speed, network bandwidth of source server, network at destination, IO at destination, the amount of work the NAS is doing at any time during the backup from other tasks, etc etc etc

    I've also seen weird speed differences between backup times when backing up to the same destination which I could only explain by differences in data and index structure

    You should also look at upgrading to 2016 or 2017 or moving backups to something like Commvault which does pretty awesome compression on SQL. BAK files are very inefficient

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply