Re: Shrink problem

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

From: Andrew J. Kelly (sqlmvpnooospam_at_shadhawk.com)
Date: 09/29/04 

Date: Wed, 29 Sep 2004 18:17:52 -0400

Chances are that it Auto Grew immediately after it shrunk since there was no
room for any changes. 

-- 
Andrew J. Kelly  SQL MVP
"inamori" <test@test.com> wrote in message
news:cjc0gp$5t54@imsp212.netvigator.com...
> why it has unused space again  after 3 hours shrinking?
>
>
> "Andrew J. Kelly" <sqlmvpnooospam@shadhawk.com> ¦b¶l¥ó
> news:eFwyquOpEHA.1992@TK2MSFTNGP09.phx.gbl ¤¤¼¶¼g...
> > No don't turn on Auto Shrink.  A database needs lots of free space to
> > operate properly and if you don't have enough space it will grow.
Chances
> > are someone kicked off an Index Rebuild (or a scheduled job) that grew
it
> > again.
> >
> > -- 
> > Andrew J. Kelly  SQL MVP
> >
> >
> > "inamori" <test@test.com> wrote in message
> > news:cj5h5u$j2a1@imsp212.netvigator.com...
> > > In sql 2000, i have shrinked the database
> > > 17Gb used data, 13 GB free data(need to be dhrinked)
> > >
> > > then i shrinked it...
> > > that 13 GB is minmized, become only 17GB
> > > so it should be fine.
> > >
> > > but few hourse later
> > > that 13GB is come out again
> > >
> > > how can i solve it
> > >
> > > can I tick Auto-shrink function?
> > >
> > > and what is that 13Gb space for?
> > >
> > >
> >
> >
>
>

Relevant Pages

  • Re: Enterprise Manager for shared server
    ... databases will make it somewhat slow. ... Andrew J. Kelly SQL MVP ... >> Sounds like the databases may have Auto Close turned on. ... >> Andrew J. Kelly SQL MVP ...
    (microsoft.public.sqlserver.programming)
  • Re: Extremely high % Disk Time .. How is this possible??
    ... Andrew J. Kelly SQL MVP ... > Slicing them into logical drives may look better but it does not increase ... I prefer to look at disk queue ... >>> Andrew J. Kelly SQL MVP ...
    (microsoft.public.sqlserver.clustering)
  • Re: disk I/O tool
    ... Andrew J. Kelly SQL MVP ... "Jay" wrote in message ... I guess he really doesn't understand SAN's very well either because SAN's are notoriously slow for writing small but frequent I/O's and direct attached drives will often outperform them hands down. ...
    (microsoft.public.sqlserver.server)
  • Re: Performance really poor if calling data from sql clients
    ... Andrew J. Kelly SQL MVP ... The TCP connection is running from the client ... On a computer running the test which is not the database hosting ...
    (microsoft.public.sqlserver.clients)
  • Re: Procedure execution problem - Clients performances
    ... Again check the parameters and plan with a trace. ... Andrew J. Kelly SQL MVP ... Dim conn As New SqlConnection ...
    (microsoft.public.sqlserver.clients)