Saturday, February 25, 2012

MS SQL 2000 sp3 problem

Recently we upgrade sql2000 with sp3 and had a problem with database full, we find that even thou "autogrow" was set database was full.
Any ideas?
Thanks,
alexIt's a long shot but, was your hard disk full? This would then not allow for your db to grow.|||I have found the answer to my question

A Timeout Occurs When a Database Is Automatically Expanding
http://support.microsoft.com/default.aspx?scid=kb;en-us;305635
A database does not expand automatically although you have the autogrow option on.
The Errorlog file does not contain any messages that indicate that the database is full.
Client computers that try to modify data in this database receive a "Timeout Expired" message on their user transaction.

Thanks,

alex

No comments:

Post a Comment