December 22, 2010 at 1:15 pm
dajonx (12/22/2010)
Oh wow, that DBA bunch price is very good compared to just LiteSpeed's license. I'm completely drooling over the virtual restore (since I'm wishing that I have that right now...). Thanks for recommending me. I'll have to try out their tools.
I agree, Red Gate's tools are fantastic. But, be aware, Virtual Restore is only marginally faster than a regular restore because the process of validating the data that SQL Server goes through is still the same. It does sound like you'd really benefit from data compression though.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 23, 2010 at 9:24 am
dajonx (12/22/2010)
Hi,I was wondering if anyone has any resolution to this problem that I'm having. I currently have 64-bit SQL Server 2005 SP2 on my backup server and I am doing a restore database of (10) 600 GB backup files. The estimated time that sys.dm_exec_requests says that the database will complete restoring is 58 hours. Also, the server becomes extremely slow. The CPU usage is very low and there are no other users using this server.
The way I moved the backup files was by external hard drive. I just attached the external hard drive to the server. However, I had to reboot the server because the disk manager service wouldn't load (or restart). We then thought that moving the files to the local drives would help the restore database process since the files were on the external, but that did not help at all.
Does anyone happen to have encountered this problem and have a solution to this?
Any help is appreciated.
sounds like you used a USB drive
NIC's will run at 100Mbps or 1000Mbps
newer USB drives will run at 480Mbps max if it's a USB2 drive and the server has USB2 ports
old USB drives take a lot longer
Viewing 4 posts - 16 through 18 (of 18 total)
You must be logged in to reply to this topic. Login to reply