SQL Server Performance

Restore takes way too long

Discussion in 'SQL Server 2005 Clustering' started by GopalMynam, May 4, 2009.

  1. GopalMynam New Member

    Hi,
    I have the following configuration for prodn server:
    Node1: Win 2003 server x64 + SQL server 2005 x64 Ent (one sql instance)
    Node2: Win 2003 server x64 + SQL server 2005 x64 Ent (one sql instance)
    When I try to restore a backup taken from the database on node 1 takes way too long. It takes about 1 hour 16 min for a 64 MB backup.
    Do I need to make any configuration chnages?
    Thanks,
    Gopal
  2. MohammedU New Member

    I don't think you need to make any config changes to restore 64 MB db...
    But check the restore throughput and recovery time after restore...
  3. satya Moderator

Share This Page