Hi,
If a database file size grows and shrinks it becomes fragmented. When creating a backup of a database and to restore it on another SQL Server, does it increase the fragmentation on that server?
How can I keep database files defragmented? Does SQL Server have tools for that or should Windows defragmentation tools be used?
/M
I think you are confusing data file fragmentation with disk fragmentation. They are two separate issues although they both affect performance of SQL Server.
If you backup your database and restore to a different server, it will not have any disk fragmentation if there is enough contiguous space to hold all of the data. Otherwise, it is at the mercy of the new disk drive.
For file fragmentation, creating a backup does not relocate data within the files. So a restored backup on a new server will have the exact same file fragmentation as the original version on the old server.
|||Thank you for your answer, I was not aware of the two different framentation problems. Now I am curious on fragmentation solutions. Our SQL Server database is set to grow 10 % when needed and not to auto shrink.
I guess disk fragmentation can be solved using the standard Disk Defragmenter in Windows.
How can file fragmentation be solved within the database files?
/M
No comments:
Post a Comment