We moved a 2000 database to another platform by restoring the database. It took a lot longer than I expected. Would it take less time to restore it a second time to the same target database since the allocations are already there?
Thanks
I really doubt it because the files will still need to be extracted from the backup file and those files allocated on the disk. The OS will likely see the files as totally new files and allocate space for them again. If you are using 2005, you have the option for fast recovery, which allows the database to be online while the data is being restored.
No comments:
Post a Comment