Re: Shrinking the index file group

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Andrew J. Kelly (sqlmvpnooospam_at_shadhawk.com)
Date: 10/22/04 

Date: Fri, 22 Oct 2004 13:32:04 -0400

When you use DBCC SHRINKDATABASE you leave control up to SQL Server as to
exactly how much it will shrink each file including the log file. Use DBCC
SHRINKFILE instead to ensure you are getting what you want. But remember
you can not shrink a file smaller than it was originally created at. 

-- 
Andrew J. Kelly  SQL MVP
"Patrick" <patriarck@gmail.com> wrote in message 
news:eh3K$HFuEHA.3980@TK2MSFTNGP12.phx.gbl...
> Hi Freinds,
> I have a seperate file group for mu indexes. I can't see any difference on 
> file size after shrinking the database.
>
> How can I shrink the index file group too?
>
> Thanks in advance,
> Pat
>

Relevant Pages

  • Re: Transaction log keeps growing
    ... Introduced in SQL Server 7.0 was the ability automatically grow and to ... shrink the physical size of database data and transaction log files. ...
    (comp.databases.ms-sqlserver)
  • Re: tempdb.mdf & tempdb.ldf
    ... you might want to read my article on shrink: ... Tibor Karaszi, SQL Server MVP ... >>> it'll truncate the log after each checkpt for those ... > Hi Uri, ...
    (microsoft.public.sqlserver.server)
  • Re: Reclaiming diskspace after deleting rows
    ... OK, so it's SQL Server. ... It's not a good idea to shrink your database. ... Please reply to the newsgroup. ...
    (microsoft.public.data.ado)
  • Re: Shrinking MDF and LDF Files
    ... written a stored procedure that will delete all the data in all tables and ... With the database empty I'd like to SHRINK the database so the files are ... State what version of SQL Server you are using and specify the content ...
    (microsoft.public.access.adp.sqlserver)
  • Re: shrink db
    ... For tempdb, shrink won't touch temp table and work tables (because locking ... Microsoft SQL Server Storage Engine ... >> can not shrink the current virtual log it is using. ...
    (microsoft.public.sqlserver.server)