Home Forums SQL Server 2005 Backups Restore Dbs on SQL Server 2012 via SQL Script taking more than 2hrs. RE: Restore Dbs on SQL Server 2012 via SQL Script taking more than 2hrs.

  • Have you checked the physical layer - are they all actually getting gigabit data transfer rates (try a Windows Explorer file copy) if you're restoring over the network.

    Check the actual file sizes.

    Is there excessive fragmentation of the free space on the 2012 restore server?

    Does the 2012 restore server have a bad battery on the RAID card, or is cache otherwise disabled?