Sunday, March 25, 2012

DBCC SHRINK DATABASE TIMED OUT

Hi all,

mydbcc schrink database command failed to shrink

a datbase of 461 gb on sql server 2005 CTP

here's the error. pls help

Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

thanks

joey

have you seen ken's blog http://blogs.msdn.com/khen1234/archive/2005/10/20/483015.aspx

and tibor's article http://www.karaszi.com/sqlserver/info_dont_shrink.asp

No comments:

Post a Comment