Re: Running Defrag on a SQL server with RAID

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Leythos (void_at_nowhere.org)
Date: 11/30/04 

Date: Tue, 30 Nov 2004 17:41:51 GMT

In article <3800F089-B78D-4175-9199-1F79A1D45AA8@microsoft.com>,
chargerman@discussions.microsoft.com says...
> I have a Win2K server running SQL and the drives are in a RAID 5 config is
> there any problems that I might have running defrag on this server?

The SQL files, the actual database files for each database, will not be
defragged while online - you have to stop the database while defragging
them or they won't be moved.
  

-- 
-- 
spamfree999@rrohio.com
(Remove 999 to reply to me)

Relevant Pages

  • Re: sqlservr.exe taking 90% of memory
    ... On the defrag issue I would stop all non-essential services but specifically ... It might be worth asking this on an sql server specific ... It would be interesting to have SQL Server Manager running and ... the database server every 30 minutes, which if you are having a slowdown ...
    (microsoft.public.windows.server.sbs)
  • Re: sqlservr.exe taking 90% of memory
    ... It might be worth asking this on an sql server specific ... the database server every 30 minutes, which if you are having a slowdown ... exchange stores to a different partition along with the swap file. ... shutdown the database and do a defrag. ...
    (microsoft.public.windows.server.sbs)
  • Re: Exchange 2000 SP3 defrag problem
    ... Just make sure you do a backup before doing the defrag and then ... like to perform a defrag on the database by copying it to another server, ... We use Robocopy for this and ran it from the Exchange server. ...
    (microsoft.public.exchange.admin)
  • Re: Defrag
    ... The only way to reduce the size of a database is to defrag it. ... Microsoft Exchange Support ... > The PRIV.EDB on my Exchange 5.5 server has grown to 35gb. ...
    (microsoft.public.exchange.admin)
  • Re: Defrag
    ... that its working as expected you can delete the old database. ... > email will stop because you have to stop the Information Store to run ... >> How long will it take to complete the Defrag. ... > the main server but I have since built a further two Exchange ...
    (microsoft.public.exchange.admin)