Defragmented File System
-
Would restoring a database backup of a fragmented database (from production) on a defragmented machine (test environment) be fragmented or defragmented. This is not database level fragmentation this has to do with file system level fragmentation.
Does a fragmented file system really matter much?
TIA
-
SA
your restored database should not be fragmented, at least not if there's enough continous space on the disk available. When you restore the database to a different machine, the first thing SQL Server will do is (re)creating all the files from the backup. So the new files should be continous.
Does that really matter ? Most of the time it won't make much difference, but I've seen some performance loss on larger databases and extremely fragmented files (several hundreds or more parts) . There's a simple free utility from sysinternals you vcan use to analyze your files and even defrag them individually online. http://www.sysinternals.com/Utilities/Contig.html
Good luck
Markus
[font="Verdana"]Markus Bohse[/font]
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply