469,111 Members | 1,923 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,111 developers. It's quick & easy.

MDF Disk Fragmentation - Backup and Restore

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
1 2120
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.

Similar topics

3 posts views Thread by James | last post: by
3 posts views Thread by Tim Morrison | last post: by
3 posts views Thread by butatista | last post: by
6 posts views Thread by Eric Herber | last post: by
4 posts views Thread by Hardy | last post: by
reply views Thread by raj.raghavan | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by kglaser89 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.