Home > Archive > Microsoft SQL Server forum > June 2005 > No disk activity during database restore









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author No disk activity during database restore
pshroads@gmail.com

2005-06-24, 8:23 pm

I am trying to restore a 200 GB database on to a newly formatted SAN
volume. The restore has been running for hours but there doesn't seem
to be a lot of disk activity on the disks I'm restoring to and I'm
wondering if that's anything to worry about.

Using perfmon I'm monitoring the % Disk time for the disk I'm restoring
to. It will show around 99% for a minute or so and then drop to zero
for 3-4 minutes. Is this normal? I know that since I'm restoring to a
new volume that SQL Server needs to zero out the 200 GB before it
starts the actual restore but I would expect to see 100% disk time
while it does this.

Any insight appreciated.

Thanks!

Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2009 droptable.com