Hi Juan,

Please kick off all the users from database before shrinking.
Suggest you to put your database in single user mode.
Then do shrinking.

Regards
Javed Iqbal

----- Original Message -----
From: "Juan Vera " <mssqldba-ezmlmshield-x65876943.[Email address protected]
To: "LazyDBA Discussion" <[Email address protected]
Sent: Wednesday, June 29, 2005 7:09 AM
Subject: Shrinking a Database


> Hi, All
>
> I'm having a problem shrinking a database - running:
> dbcc shrinkdatabase(dbName, 10)
> I get a 170GB database not shrunk at all, while reporting 90GB of free
space left at the end.
>
> Is there something I'm missing in how to run the command, or another
explicit way of deallocating space from the database to reduce the size fo
the device?
>
> TIA
>
> Juan Cristián
>
>
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> Website : http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>


MS Sql Server LazyDBA home page