BACKUP DATABASE is terminating abnormally.

  • Hi All,

    One of our database backup is terminating abnormally with below error:

    Msg 3013, Level 16, State 1, Line 1

    BACKUP DATABASE is terminating abnormally.

    Msg 9001, Level 21, State 1, Line 1

    The log for database 'XXXXX' is not available. Check the event log for related error messages. Resolve any errors and restart the database.

    Database status is online. Also both mdf and ldf files exists on appropriate path.

    -----------------
    Aditya Rathour
    SQL DBA

    Not Everything that is faced can be changed,
    but nothing can be changed until it is faced.

  • I've seen this before with databases that have the autoclose setting set as true. Try changing it to false if it is set to true.

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

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