Re: defragging SQL Database files

skfunx_at_yahoo.com
Date: 06/26/04 

Date: 26 Jun 2004 14:04:42 -0700

Hi Ashwini,

were you ever able to get the disk to defrag?
Please let me know I need to do similar thing.

SK

>
> I have done that.Even that is not working.
>
> "Dejan Sarka"
> <dejan_please_reply_to_newsgroups.sarka@avtenta.si> wrote
> in message news:#e1T6rY5DHA.2720@TK2MSFTNGP09.phx.gbl...
> > Stop the SQL Server - I guess OS can't defrag open
> files. >
> > --
> > Dejan Sarka, SQL Server MVP
> > Associate Mentor
> > Solid Quality Learning
> > More than just Training
> > www.SolidQualityLearning.com
> >
> > "Ashwini Khanna" <ashwini400@hotmail.com> wrote in
> > message news:ejtQNOW5DHA.2720@TK2MSFTNGP09.phx.gbl...
> > > I am trying to defrag my Hard-disk drive. Windows 2000
> > > Server does not defrag my drice compoletely as major
> > portion is occupied by my SQL database
> > > whose size is around 2GB. The Defrag program on
> > > completion says that it cannot defrag the SQL Database
> > > files. Then how do I do it? Is there any way to defrag
> the SQL Database files? I
> > > need to do it as major portion of my HDD is occupied
> > by database files. >
> > > Regards,
> > > Ashwini
> > >
> > >
> >
> >
>
>

Relevant Pages

  • Re: Best Practice for SBS 2008
    ... The one thing both of your cited examples have in common is SQL. ... If you index properly and occasionally defrag the database then you are actually reducing the number of PAGES that have to be read. ... And it should be noted that a SQL database does not need to be on a separate partition to be cleaned up. ... , SQL database showing 58,000+ fragments of the MDF ...
    (microsoft.public.windows.server.sbs)
  • Re: RAID5 performance + defragmentation
    ... We have HW RAID5 volume for user data on our SBS box, ... We have a massive 12 drive RAID-5 system that holds SQL Database files ... Schedule a Sunday night automated defrag of Drive..... ... mapped drives, lots of daily use... ...
    (microsoft.public.windows.server.sbs)
  • Re: Extending partition size using diskpart utility
    ... If you're extending the disk in a cluster environment, ... > Unfortunately it is not possible for us to create a new partition. ... >> Ryan Sokolowski ... >>> data or we need to take some precautionary steps on SQL database ...
    (microsoft.public.windows.server.clustering)
  • Re: Running Defrag on a SQL server with RAID
    ... > devices without first having to stop SQL services. ... windows defrag utility on 2000 server does not defrag ANY ... The MS SQL database files, ... Unless you are going to write a custom app to make use of the API, ...
    (microsoft.public.win2000.general)
  • Re: SyncToy v2.0 Network
    ... In my case it was just the addition of a new disk that moved most of my previous disks to the next higher letter. ... I suspect that SyncToy2 will make it harder to implement this, because it keeps its records in an SQL database, and I bet that the drive letters find their way into that database. ... Synctoy1 kept its data in the root of the folder being backed up, so it had no need to include its location. ...
    (microsoft.public.windowsxp.photos)