Shrinking a db

2 Sep 2005 5:34 PM

bagman3rd

I am having trouble shrinking a database. The database is 14 gig, with 6 gig
free space. I have tried to shrink the db with ERM, and I have tried from
command line with dbcc shrinkdatabase and dbcc shrinkfile with no success.
Anybody have a clue as to what I am doing wrong. Thanks for the help.

Archer

2 Sep 2005 5:48 PM

Andrew J. Kelly

6 GB of free space is really not that much. I would leave it as is. But
more than likely you have an open transaction somewhere that is preventing
the shrink. What does DBCC OPENTRAN() say?

--
Andrew J. Kelly SQL MVP

Show quote

"bagman3rd" <bagman***@discussions.microsoft.com> wrote in message
news:8358EF2F-65E8-4CF0-9629-1707E44CA84A@microsoft.com...
>I am having trouble shrinking a database. The database is 14 gig, with 6
>gig
> free space. I have tried to shrink the db with ERM, and I have tried from
> command line with dbcc shrinkdatabase and dbcc shrinkfile with no success.
> Anybody have a clue as to what I am doing wrong. Thanks for the help.
>
> Archer

2 Sep 2005 5:51 PM

David Gugick

bagman3rd wrote:

> I am having trouble shrinking a database. The database is 14 gig,
> with 6 gig free space. I have tried to shrink the db with ERM, and I
> have tried from command line with dbcc shrinkdatabase and dbcc
> shrinkfile with no success. Anybody have a clue as to what I am doing
> wrong. Thanks for the help.
>
> Archer

The database is composed of one or more data files and one or more log
files. Which file are you trying to shrink using DBCC SHRINKFILE? If
it's the log file, you might try truncating the log or backing it up
first.

--
David Gugick
Quest Software
www.imceda.com
www.quest.com