12/07/2006

Error 952 Database 'Foo' is in transition...

I have yet to find a reliable source of the definition of 'transition' in SQL Server 2005.

My customer had this error come up in conjunction with a database that got set to 64000% Autogrow and went nuts.

The only reference I found was here:
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=209294&SiteID=1

I used his resolution and it worked. This must be a horrible design issue when closing the client utility affects the availability of a database.

Ugh. No fries with this one, since the database was offline for 4 hours.

Please post a comment if you can explain more about this error to me...

Thanks

No comments: