microsoft.public.sqlserver.server

Author

dbcc shrinkdatabase

Sanjay

2002-10-05, 9:12 pm

does dbcc shrinkdatabase work behind the scenes
I executed dbcc shrinkdatabase and it gave me DBCC
executed succesfully
but db size which sp_helpdb gives me is still the same

pls help
sanjay

Sue Hoegemeier

2002-10-05, 9:13 pm

Depends on what version of SQL Server. For SQL Server 7,
it's a deferred operation. You can back it up to force the
shrink to happen immediately.

-Sue

On Fri, 20 Sep 2002 08:44:35 -0700, "Sanjay"
<sanjayg@hotmail.com> wrote:

>does dbcc shrinkdatabase work behind the scenes
>I executed dbcc shrinkdatabase and it gave me DBCC
>executed succesfully
>but db size which sp_helpdb gives me is still the same
>
>pls help
>sanjay

Sponsored Links