dbTalk Databases Forums  

defragging

microsoft.public.sqlserver.clustering microsoft.public.sqlserver.clustering


Discuss defragging in the microsoft.public.sqlserver.clustering forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Allan Hirt
 
Posts: n/a

Default defragging - 02-10-2004 , 10:19 AM






Well, there are two levels of fragmentation: logical and
physical. Within the SQL DBs, there would be logical and
that is normal SQL maintenance. I assume you mean
physical, meaning disk fragmentation at the OS level/disk
level.

I wouldn't do it while SQL Server was on, as it is moving
pages around. In theory, if you sized your DB correctly,
you shouldn't have much fragmentation at the OS/physical
layer, but mainly at the logical.
Quote:
-----Original Message-----
I have an active/active sql cluster environment running
on W2K and Sql2000 sp3. My db's are on an array. Is it
possible (safe) to defrag the array without losing or
corrupting data or db's?
Quote:
Thanks.
.


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.