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