HI, I am restoring a DB .BAK file which is around 1.8 GBs. It is taking a lot of time to complete. Is this expected?
Thanks a lot.
It all depends on your hardware components and system configuration.......generally speaking it should not take more than 10 mins for 2 GB backup files..........also check if the backup file is valid by using,
restore verifyonly from disk='path of the backup file'
Also I think you should have posted this in database engine forum as that seems to be more appropriate for your question......
|||Also, it may be that your data and log files are much larger than 1.8GB and its taking a long time to create these files.
The database backup file will be the size of the actual data stored whereas the files you restore will have the blank pages allocated as well which could make them much larger.
This is quite a common scenario with the transaction log when it can grow quite large over time but is never physically truncated.
HTH!
No comments:
Post a Comment