Post reply

Transaction ERROR

  • May 12, 2003 at 9:45 am

    #59223

    7:31 this morning we get

    28042 Error: Exceeded the allow number of retries (configurable via the registry) on device.

    then we get

    MSSQLSERVER error 9002 Servity 17 State: 6

    The log file for database

    does anyone know how to help?

  • May 12, 2003 at 11:54 am

    #456876

    From BOL.

    "Error 9002

    Severity Level 19

    Message Text

    The log file for database '%.*ls' is full. Back up the transaction log for the database to free up some log space.

    Explanation

    The specified transaction log file has run out of free space.

    Action

    To gain more space, you can free disk space on any disk drive containing the transaction log file for the related database. Freeing disk space allows the recovery system to enlarge the log file automatically. Or you can gain space by adding or enlarging a log file for the specified database.

    Freeing disk space

    You can free disk space on your local drive or on another disk drive. To free disk space on another drive:

    Move the transaction log files with an insufficient amount of free disk space to a different disk drive.

    Detach the database by executing sp_detach_db.

    Attach the database by executing sp_attach_db, pointing to the moved files.

    Adding a log file

    Another solution is to add a log file to the specified database using the ADD FILE clause of the ALTER DATABASE statement. Or you can enlarge the log file using the MODIFY FILE clause of the ALTER DATABASE statement, specifying the SIZE and MAXSIZE syntax. Adding an additional log file allows the existing log to grow."

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply