Problem shrinking a database

[Jaeger]

Hi all.

I'm having trouble shrinking a database. In short, using the SQL Query
Analyzer,
I enter the following commands:

DBCC SHRINKDATABASE (database, 80)
GO

The command returns the expected 'DBCC execution completed.' response, but
the database
remains the same size when I run 'sp_helpdb database'. Am I missing
something?

Thanks in advance,

Jaeger

[Simon Hayes]

"Jaeger" <ja******@adelphia.net> wrote in message
news:x7********************@adelphia.com...

Hi all.

I'm having trouble shrinking a database. In short, using the SQL Query
Analyzer,
I enter the following commands:

DBCC SHRINKDATABASE (database, 80)
GO

The command returns the expected 'DBCC execution completed.' response, but
the database
remains the same size when I run 'sp_helpdb database'. Am I missing
something?

Thanks in advance,

Jaeger

Here's one possible reason:

http://support.microsoft.com/default...b;en-us;324432

Also, you can't shrink a database below its minimum file size, and you can't
shrink it smaller than the model database - see "DBCC SHRINKDATABASE" in
Books Online. You might want to try using DBCC SHRINKFILE to shrink the
files individually, as that way you can specify a precise size for the
files.

Simon

[Jaeger]

Thanks for the reply, Simon.

Crazy thing is that I'm doing an excercise as outlined in the 'Teach
yourself MS SQL Server 2000 in 21 days' wherein this very instruction is to
be performed. One would expect these exercises to be tried and tested.

Jaeger

"Simon Hayes" <sq*@hayes.ch> wrote in message
news:41**********@news.bluewin.ch...

"Jaeger" <ja******@adelphia.net> wrote in message
news:x7********************@adelphia.com...

Hi all.

I'm having trouble shrinking a database. In short, using the SQL Query
Analyzer,
I enter the following commands:

DBCC SHRINKDATABASE (database, 80)
GO

The command returns the expected 'DBCC execution completed.' response, but the database
remains the same size when I run 'sp_helpdb database'. Am I missing
something?

Thanks in advance,

Jaeger
Here's one possible reason:

http://support.microsoft.com/default...b;en-us;324432

Also, you can't shrink a database below its minimum file size, and you

can't shrink it smaller than the model database - see "DBCC SHRINKDATABASE" in
Books Online. You might want to try using DBCC SHRINKFILE to shrink the
files individually, as that way you can specify a precise size for the
files.

Simon