Automatic Defragmentation?

Hi!
I have sql server system and in the diary backup i have
seen that the database size has been reduced a lot, from
one day to another.
I have any deframentation actived, Is the defragmentation
activated by defect in sql server'
Thanks.
Best RegardsThere is no automatic method for controlling fragmentation. See the
whitepaper at
http://www.microsoft.com/technet/treeview/default.asp?url=/technet/prodtechnol/sql/maintain/optimize/ss2kidbp.asp
for more details.
--
Paul Randal
DBCC Technical Lead, Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"fran" <gimmacks@.telepolis.com> wrote in message
news:001901c37938$47abd980$a101280a@.phx.gbl...
> Hi!
>
> I have sql server system and in the diary backup i have
> seen that the database size has been reduced a lot, from
> one day to another.
> I have any deframentation actived, Is the defragmentation
> activated by defect in sql server'
>
> Thanks.
> Best Regards|||Hi!
Thanks for your response.
If there is any automatic method for controlling
defragmentation, Do you have any idea why this has
happend'
Thanks
>--Original Message--
>There is no automatic method for controlling
fragmentation. See the
>whitepaper at
>http://www.microsoft.com/technet/treeview/default.asp?
url=/technet/prodtechnol/sql/maintain/optimize/ss2kidbp.asp
>for more details.
>--
>Paul Randal
>DBCC Technical Lead, Microsoft SQL Server Storage Engine
>This posting is provided "AS IS" with no warranties, and
confers no rights.
>"fran" <gimmacks@.telepolis.com> wrote in message
>news:001901c37938$47abd980$a101280a@.phx.gbl...
>> Hi!
>>
>> I have sql server system and in the diary backup i have
>> seen that the database size has been reduced a lot, from
>> one day to another.
>> I have any deframentation actived, Is the
defragmentation
>> activated by defect in sql server'
>>
>> Thanks.
>> Best Regards
>
>.
>|||No there isn't. Please read the whitepaper which should explain everything
you've asked.
--
Paul Randal
DBCC Technical Lead, Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"fran" <pnoia@.iespana.es> wrote in message
news:06ee01c37b6c$d3589c30$a101280a@.phx.gbl...
> Hi!
> Thanks for your response.
> If there is any automatic method for controlling
> defragmentation, Do you have any idea why this has
> happend'
>
> Thanks
>
> >--Original Message--
> >There is no automatic method for controlling
> fragmentation. See the
> >whitepaper at
> >http://www.microsoft.com/technet/treeview/default.asp?
> url=/technet/prodtechnol/sql/maintain/optimize/ss2kidbp.asp
> >for more details.
> >
> >--
> >Paul Randal
> >DBCC Technical Lead, Microsoft SQL Server Storage Engine
> >
> >This posting is provided "AS IS" with no warranties, and
> confers no rights.
> >"fran" <gimmacks@.telepolis.com> wrote in message
> >news:001901c37938$47abd980$a101280a@.phx.gbl...
> >> Hi!
> >>
> >>
> >> I have sql server system and in the diary backup i have
> >> seen that the database size has been reduced a lot, from
> >> one day to another.
> >> I have any deframentation actived, Is the
> defragmentation
> >> activated by defect in sql server'
> >>
> >>
> >> Thanks.
> >>
> >> Best Regards
> >
> >
> >.
> >