DBCC SHRINKDATABASE

Hello Gurus
In the enterprise manager, when I click on a database, the properties on the right hand side shows that there is 6 GB free space in the secondary data file. However, issuing a DBCC SHRINKDATABASE does not seem to do anything to shrink the database. I have tried SHRINKFILE as well. Why could this be happening
Thanks
Alex GYou have open transactions?
http://www.aspfaq.com/2471
--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Alex G" <anonymous@.discussions.microsoft.com> wrote in message
news:6409A05E-E35A-4E3E-A1D3-4B5DCE741E5D@.microsoft.com...
> Hello Gurus,
> In the enterprise manager, when I click on a database, the properties on
the right hand side shows that there is 6 GB free space in the secondary
data file. However, issuing a DBCC SHRINKDATABASE does not seem to do
anything to shrink the database. I have tried SHRINKFILE as well. Why could
this be happening?
> Thanks,
> Alex G|||Try this
backup log DBName with truncate_only
dbcc shrinkfile ('DBname',0,truncateonly)
dbcc shrinkfile ('DBName',0,truncateonly)
>--Original Message--
>No open transactions.
>DB Size = 11 GB
>Free space = 6 GB
>How can I get that 6 GB back? We are doing a lot of
detaching and attaching programatically and it is PIA
trying to move that big file around especially when you
KNOW there is free space.
>Please help!!
> -- Aaron Bertrand - MVP wrote: --
> You have open transactions?
> http://www.aspfaq.com/2471
> --
> Aaron Bertrand
> SQL Server MVP
> http://www.aspfaq.com/
>
>
> "Alex G" <anonymous@.discussions.microsoft.com>
wrote in message
> news:6409A05E-E35A-4E3E-A1D3-
4B5DCE741E5D@.microsoft.com...
> > Hello Gurus,
> >> In the enterprise manager, when I click on a
database, the properties on
> the right hand side shows that there is 6 GB free
space in the secondary
> data file. However, issuing a DBCC SHRINKDATABASE
does not seem to do
> anything to shrink the database. I have tried
SHRINKFILE as well. Why could
> this be happening?
> >> Thanks,
> > Alex G
>
>.
>