Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2003
    Posts
    2

    Unanswered: 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,

    alex

  2. #2
    Join Date
    Feb 2003
    Location
    Brisbane, Australia
    Posts
    110
    It's a long shot but, was your hard disk full? This would then not allow for your db to grow.

  3. #3
    Join Date
    Mar 2003
    Posts
    2

    Smile MS SQL 2000 sp3 problem

    I have found the answer to my question

    A Timeout Occurs When a Database Is Automatically Expanding
    http://support.microsoft.com/default...b;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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •