I will be moving databases to a new server by doing a backup and restore. I just wanted to confirm that the database files would be restored without any physical fragmentation. Is this correct?
Yes that is correct. When the database is restored the file will be laid down as one large block, assuming that there is nothing else on the disk and there is enough free space in a single large block.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply