Results 1 to 6 of 6

Thread: backup log file fail

  1. #1
    songqh Guest

    backup log file fail

    My database's log file is full. i want to backup it .
    First i create a backup device named aa.
    Than i use Enterprise to backup trasaction log.
    But it popup an error messagebox.
    The title is "Microsoft SQL-DMO(ODBC SQL state:42000)
    The content is "write on 'aa' failed,status=112. See the SQL error log for more details.Backup or Restore operation terminating abnormally.
    What's the matter ?

  2. #2
    Craig Guest

    backup log file fail (reply)

    See the SQL error log as indicated in the message!


    ------------
    songqh at 8/23/01 8:05:58 AM

    My database's log file is full. i want to backup it .
    First i create a backup device named aa.
    Than i use Enterprise to backup trasaction log.
    But it popup an error messagebox.
    The title is "Microsoft SQL-DMO(ODBC SQL state:42000)
    The content is "write on 'aa' failed,status=112. See the SQL error log for more details.Backup or Restore operation terminating abnormally.
    What's the matter ?

  3. #3
    Join Date
    Jan 2009
    Posts
    1
    Please check disk space. Either free some space or change the disk drive where the backup is being created.

    Alberto Morillo
    SQLCoffee.com

  4. #4
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    Once the log disk becomes full you can't back it up unless you add disk space on the drive (if it is SAN) or delete something else to free up some space so that backup can continue.

    If that is not an option, run backup log with truncate_only command, then shrink the log file, take a full backup.

  5. #5
    Join Date
    Sep 2002
    Posts
    5,938
    Guys, it's 7 and half years old thread.

  6. #6
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932

Posting Permissions

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