Printable View
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 ?
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 ?
Please check disk space. Either free some space or change the disk drive where the backup is being created.
Alberto Morillo
SQLCoffee.com
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.
Guys, it's 7 and half years old thread.
We are time travelling I guess