I would also want to be able to just get the analyze results, run
defrag only if it meets a specified threshold, and then report
the before and after numbers.
Jason
-----Original Message-----
From: Jason Volpe
[mailto:mssqldba-ezmlmshield-x16349430.[Email address protected]
Sent: Sunday, May 30, 2004 6:26 PM
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]
begin 666 winmail.dat
M>)\^(A(!`0:0" `$```````!``$``0>0!@`(````Y 0```````#H``$(@ <`
M& ```$E032Y-:6-R;W-[Email address protected] ! `"`````@`"``$$
[Email Address Removed] $`$ ```%)%.B!.5$93($1E9G)A9P"5! $%@ ,`#@```-0'!0`>`!(`)@`'
M````/0$!(( #``X```#4!P4`'@`2`"8`!P```#T!`0F `0`A````048U-[Email Address Removed] &`#@)```U````"P`"
M``$````#`"8```````L`*P```````P`N```````#`#8``````$ `.0"NYH+L
MKT;$`1X`/0`!````!0```%)%.B ``````@%'``$````Q````8SU54SMA/2 [
M<#U);G1E<V]U<F-E.VP]5%=%1519+3 T,#4S,3 Q,[Email address protected]
M< `!````# ```$Y41E,@1&5F<F%G``(!<0`!````&P````'$1JYK/NANB_J[
MWT=(I=R:@:FLD"X``%;+T `>`!H,`0````P```!*87-O;B!6;VQP90`>`!T.
M`0````P```!.5$93($1E9G)A9P`"`0D0`0```)P#``"8`P``=P4``$Q:1G50
M5#&/`P`*`')C<&<Q,C7B,@-#=&5X!4$!`P'W_PJ `J0#Y <3`H /\P!0!%8_
M"%4'LA$E#E$#`0(`8VCA"L!S970R!@`&PQ$E]C,$1A.W,!(L$3,([PGWMCL8
M'PXP-1$B#&!C`% S"PD!9#,V%E +IB!)1"!W"&!L9" '0',N;QT``' %0'0=
MH&)[Email Address Removed] >4!X1:G5S!4![Email Address Removed] P
M=0N0"K$*@ $!<F'L9R "(!_P( :0(A %0(<'@![Email Address Removed] (D!U0
M'X @[Email Address Removed] `<".""? @,7 7P2$$WQ^"'D "$!@@)$-A`8 [Email Address Removed] .A)XDM*5)/O0409PN !T %T >0<R&@EF4I4R$$[Email Address Removed] H-.96!O C$"!;`, #$!X0%#IM!!!Q'4!B82W097IM;"SP: B0'4 `+[Email Address Removed] N+D P.#4Y`#8X.#<T0$QA0'IY1$)!+@[Email Address Removed] (P*Y!3
M(.!DU&%Y(+!-,7 @+K @L $!T# T(#8Z,C:H(%!-(014+- @+ZGT($0$`&,?
M``"0`B P=1AU8FH%D#$!3E1&[07P1"%S)WI)!" ?@28BMQVQ(@`?@&$%0!SP
M8P.1?PN (E ', ZP'[$UU!Z0=ATN`" A90-2!@!13#]])WI7'2,B41Y"!" `
MD&WO"U \PR#1`P!N(; B42.A`'[Email Address Removed] _<$DB,/<=D""P
M)WIW.%(=%!^","'_`X$=4!Y /V G>BB+*[DV]7YN)@$`P#[Email Address Removed] ?0 > '>$A! N %PZP'9 (<&,>4%!O=_L&<3X!4 -@-( 8($;"(+"X
M061V`' C,#X!0A\`;PN *D$_<"$$;P$@#>!E`RN0'# R+30T-2VP,C(Y,2B%
M!&!B`Q #2W$!P2TY,[Email Address Removed] ) <#HO+W?M6M N+ZDR]B @X"!@6>!_!0$>0%I+
M"V OP"U!,!(O/5Q9+[Email Address Removed] J]06Q863^9#D1`B J`4'%(*$JD"R"9RN0+/<_
M(7! 7=E#6GT!9& >`#40`0```$,````\-$4P040U14,R-3E$-4$T-4)&-CDX
M1D9"1C5#0T(R-T1&03%#0S! ='=E971Y+G!H>"YI;G1E<V]U<F-E+FYE=#X`
M`!X`0A !````.0```#PR,# T,#4S,3 R,#$Q-"XR,S8P-2YQ;6%I;$!W=W<N
M=V5B<VET97-O;F1A=&%B87-E<RYC;VT^``````,`@!#_____`P"6$ `````?
M`/,0`0```"P```!2`$4`)0`S`$$`( !.`%0`[Email Address Removed] `1 !E`&8`<@!A`&<`
M+@!%`$T`3 ````L`]A `````0 `', P/:^RO1L0!0 `(,")PC.RO1L0!`P#>
M/Y].```#`/$_"00``!X`^#\!````# ```$IA<V]N(%9O;'!E``(!^3\!````
M8 ````````#<IT#(P$(0&K2Y" `K+^&"`0`````````O3SU)3E1%4T]54D-%
M+T]5/49)4E-4($%$34E.25-44D%4259%($=23U50+T-./5)%0TE0245.5%,O
M0TX]2E9/3%!%`!X`^C\!````%0```%-Y<W1E;2!!9&UI;FES=')A=&]R````
M``(!^S\!````'@````````#<IT#(P$(0&K2Y" `K+^&"`0`````````N````
M`P#]/^0$```#`!E ``````,`&D `````'@`P0 $````'````2E9/3%!%```>
M`#% `0````<```!*5D],4$4``!X`.$ !````!P```$I63TQ010``'@`Y0 $`
M```"````+@````,`"5D!````"P![Email Address Removed] ```````$8`````#H4`
M```````#`'Z!"" &``````# ````````[Email Address Removed] 8`
M`````, ```````!&`````%2%```!````!0```#$Q+C ``````P#"@[Email Address Removed] ```````$8``````84```````! `,2!"" &``````# ````````[Email Address Removed] &``````# ````````[Email Address Removed] 8``````, ```````!&`````!"%`````````P#[Email Address Removed] ```````$8`````&(4````````+`.J!"" &``````# ````````[Email Address Removed] 8``````, ```````!&``````:%````````"P`I````
M```+`",```````,`!A 9T 6L`P`'$!T#```#`! 0``````,`$1 `````'@`(
M$ $```!E````25=/54Q$04Q33U=!3E143T)%04),151/2E535$=%5%1(14%.
M04Q96D5215-53%13+%)53D1%1E)!1T].3%E)1DE4345%5%-!4U!%0TE&245$
M5$A215-(3TQ$+$%.1%1(14Y210`````"`7\``0```$,````\-$4P040U14,R
M-3E$-4$T-4)&-CDX1D9"1C5#0T(R-T1&03%#0S! ='=E971Y+G!H>"YI;G1E
/<V]U<F-E+FYE=#X````9
`
end
MS Sql Server LazyDBA home page