i have sql 2000 db of about 120 GB. its taking about 10 -12 hours to restore on the same disk as new database.
server configuration is good.
when i try to restore another db of about 10 GB size, its restoring in about 5 minutes.
A slow restore could be any number of things.
Is the backup on the local disk, or the network? What else is the drive with the backup doing? What else is the drive that the restore is going to doing? How much data is in the transaction log that needs to be rolled forward/backward?
|||backup and restore is on the same local disk.
not much processes are going on, except log backup every 15 min will put data on the disk, the log backup with be finished within seconds.
reg: data in transaction log that needs to be rolled forward/ backword: i really cant say because i dont know how to calculate it.
No comments:
Post a Comment