none
Restore a database RRS feed

  • Question

  • Hi,

    I have a 327069 GB database backup file. to restore a this much size db, approximately how long time required and how much space required in a c drive?

    Any help would be appreciated.

    Thanks,

    Priviya

    Tuesday, October 22, 2019 7:06 AM

All replies

  • Do a RESTORE FILELISTONLY and check Size column for all files and you will have an notion.

    Now, how long time is hard to say at first glance, depends on hardware, resource available, SQL environment, backup file is compressed, and so on, and so on, and so on...


    Tuesday, November 26, 2019 8:56 PM
  • do you really have a 327,069 Gigabyte backup file? as in 327TB?

    is this one backup of a single database, is this a set of multiple backups of a database to the file?

    A powerful storage system perfectly configured for a multi-file SQL Server database can support combined transfer rates of 20GB/s or more between multiple files, with correct IO paths. So a restore rate on the order of 1TB is possible. But few people bother to do this, and 1-3GB/s is more common for typical SAN systems, so you are looking at 1-3 days to transfer 327TB of data, more if this was a compressed backup

    A SQL Server restore consists of reading data from the backup, writing to the data file locations,

    then replaying the log portion. The RESTORE FILELISTONLY should tell you how much data and log there are separately?

    I don't much space is required on C drive, only on the location of the data and log files


    jchang

    Tuesday, November 26, 2019 10:14 PM