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
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...
Do you have same type of disks & servers between these servers? I can say sometimes the restore will take time because for the first time it needs to create the files on operating system. You can take help of http://sqlserver-qa.net/blogs/perft...and-restore-performance-stats-with-a-dmv.aspx the script here to see what is happening.