Exec xp_cmdshell 'defrag d:' is the correct way to defrag through SQL Server

Prashant Thakwani




-----Original Message-----
From: Shrikant S. Patil
[mailto:mssqldba-ezmlmshield-x15032482.[Email address protected]
Sent: Monday, May 31, 2004 1:29 PM
To: LazyDBA.com Discussion
Subject: RE: NTFS Defrag


It is possible to initiate defrag from SQL.

-- to defrag for example drive d
Exec xp_cmdshell 'defrag d:'

Regds,
Shrikant Patil
MCDBA

-----Original Message-----
From: Jason Volpe
[mailto:mssqldba-ezmlmshield-x16349430.[Email address protected]
Sent: Monday, May 31, 2004 6:56 AM
To: LazyDBA.com Discussion
Subject: NTFS Defrag

Is there a way that I can initiate an NTFS level defrag from SQL?

Would it be as simple as running it thru xp_cmdshell? If so,

what would the command be?



Jason Volpe
Information Systems Management
intesource Powering Procurement, Advancing Business
office: 602-445-2291
mobile: 720-938-0926






---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY Website :
http://www.LazyDBA.com To unsubscribe:
http://www.lazydba.com/unsubscribe.html
For additional commands, e-mail: mssqldba-[Email address protected]



---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
For additional commands, e-mail: mssqldba-[Email address protected]





MS Sql Server LazyDBA home page