By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,413 Members | 1,594 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,413 IT Pros & Developers. It's quick & easy.

MDF Disk Fragmentation - Backup and Restore

P: n/a
If databases on a physical drive [G:] are fragmented, and the drive is
extended by adding more hard drives to the array, does it make sense to
backup and restore the fragmented databases?

The Windows Server should be able to find contiguous space for each
database, since it shows 75% free space on the SQL Data drive without
any file fragments on it.

Or will it restore to the original location, in which case does it make
sense to delete the databases and restore them from the backups?
Thank you very much!

Jul 23 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Hopefully Paul Randal will answer more authoritatively / correct me.
The way I understand it, is that MSFT says for hardware RAID disk
arrays -- physical fragmentation isn't much of a concern. (It isn't
necessary to run DiskKeeper or Windows Defrag). However logical
fragmentation is a concern. That is the MSSQL datafile may be
contiguous on the disk but the actual data inside the data pages are
logically out of sequence. DBCC DBReindex, I believe, corrects both
physical and logical frag. DBCC IndexDefrag, I believe, only corrects
the logical frag. (Which I think is all that is needed?)

Jul 23 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.