i use a dts package to maintain a standby server - this dts package does the
following:

creates a complete backup file on main server
restores this database on the main server as a 'temporary' database
some sql is ran to remove sensitive information from the newly restored
'temp' database on main server
temp database is backed up on the main server
temp database backup file is copied from the main server to the backup
server
temp database is restored on the backup server

the strange thing is this: the backup and restore operations on the main
server take 30 - 45 minutes each, but the restore on the backup server takes
about 5 minutes - and it is restoring a file of essentially the same size.

this machine is not even a faster machine than the main server, so i'm not
sure what might be the reason for this

any suggestions??

tia

jt

In message <Oo781JiJEHA.3016 (AT) tk2msftngp13 (DOT) phx.gbl>, JT <jt (AT) nospam (DOT) com>
writes
Restores will be very disk intensive, so try looking at the disk
performance counters on the slow server. Still sounds excessive. You
aren't going across a network by any chance?

--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org