Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Physical SQL file defrag - needed?
Message
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Maintenance bases de données
Titre:
Physical SQL file defrag - needed?
Divers
Thread ID:
00545604
Message ID:
00545604
Vues:
45
For various reasons (one of which is the quicker backup of SQL server using 3rd party applications), the files of a SQL database have to be defragmented. I am referring to the physical file fragmentation (not internal data/page fragmentation of a database/table) on disk.

Defragmentation utilities, like DiskKeeper, can do the job, but require that SQL server be shut down during defragmentation. As this is not possible in most cases, how is defragmentation accomplished in 24x7 operations? Is it necessary? Does anyone have any experience with this issue?

Thank you,
Aristotle
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform