Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.ms-sqlserver > #146

Re: Shrink Database problem!!!

Show all headers | View raw

Dom (dolivastro@gmail.com) writes:
> At 8:00 am Wed, we started a Shrink Database command (though the SSMS
> GUI) on a very large and very active database.  The activity monitor
> usually show the process is "suspended" (what does that mean?)
> although sometimes when I click "Refresh" it says "runnable".
> 
> It is now 3:30 pm Thurs, and the Shrink Database is still going on.
> Should I be worried about this?  As I said, it is a large database,
> with a fair amount of activity, and we recently added a good amount of
> data, and deleted some unnecessary tables.

Yes, you should be worried. By the mere fact that you started Shrink
Database. It is a command you use be very restrictive with. And I 
definitely advice against running it during office hours.

I would recommend that you cancel the operation, and that you schedule
reindexing of the database for the coming weekend, as shrinking introduces
fragmentation.

See also http://www.karaszi.com/SQLServer/info_dont_shrink.asp

-- 
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx

Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

Shrink Database problem!!! Dom <dolivastro@gmail.com> - 2011-04-07 12:23 -0700
  Re: Shrink Database problem!!! Gene Wirchenko <genew@ocis.net> - 2011-04-07 14:07 -0700
  Re: Shrink Database problem!!! Erland Sommarskog <esquel@sommarskog.se> - 2011-04-07 23:32 +0200
  Re: Shrink Database problem!!! ravi p <zygonr@airtel.blackberry.com> - 2011-04-08 06:44 +0000
    Re: Shrink Database problem!!! Dom <dolivastro@gmail.com> - 2011-04-08 07:26 -0700

csiph-web