Hi,
How much time will it take to restore a DB 300MB long in SQL Server 2005 Express?
Full Restore with recovery option?
The thing is that I made a restore process and its been running for about an hour now.
When I open the Management Studio on the database folder it shows "Restoring..."
Is this normal?
Tnx
Hi Giber,
The speed of restoration (and backup) depends on the specifications of the machine (specifically, I/O capabilities). if your machine is just a laptop with an ide drive, then 300MB in over an hour is perhaps expected.
If you'd like to verify that the restoration is still active, you can either view the restore command's state in sysprocesses (select stats from master.dbo.sysprocesses where cmd like '%restore%') or view the current throughput from performance monitor (SQLServer:Databases, Backup/Restore throughput/sec).
Alternatively, you can also execute the restore command and request that it reports when a specified percent has been restored:
RESTORE DATABASE MyDataBase FROM Disk = 'C:\BackupFile.bak' WITH STATS = 10, RECOVERY
The above command will report every time 10% has been restored.
Cheers,
Rob
No comments:
Post a Comment