Sign in
Microsoft.com
 
SQL Server TechCenter
 
 
 
SQL Server TechCenter > SQL Server Forums > SQL Server Disaster Recovery and Availability > BACKUP LOG is terminating abnormally
Ask a questionAsk a question
Search Forums:
 

AnswerBACKUP LOG is terminating abnormally

  • Monday, May 12, 2008 4:31 AMFarzad Azarm Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    Sign In to Vote
    0
    Sign In to Vote


    Hi! I have a db with Full recovery model, when i try to run Transaction Log Backup, i get this error- sometimes sooner than reaching 90 percent, in spite of friendly working that i had before.

    10 percent processed.
    20 percent processed.
    30 percent processed.
    40 percent processed.
    50 percent processed.
    60 percent processed.
    70 percent processed.
    80 percent processed.
    90 percent processed.
    Msg 3202, Level 16, State 2, Line 1
    Write on "D:\Simaap_Backup\SimaapFullBackup_870218" failed: 112(error not found)
    Msg 3013, Level 16, State 1, Line 1
    BACKUP LOG is terminating abnormally.

    Any solution would be appreciated!!
    Thanks!

     

     

Answers

  • Monday, May 12, 2008 4:52 AMRishi Maini SQL DBA Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     Answer
    Sign In to Vote
    0
    Sign In to Vote

     

    For Backup and Recovery queries, please use the following forum link http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=744&SiteID=1

     

    Anyway coming back to your issue:-

     

    Error 112 is a OS Error which means :- "There is not enough space on the disk."

     

    So please check the space available on your D drive and if you are running short of space , make some space available on the D drive or try to backup the DB on a different drive that has sufficient space on it.

     

    Regards

    Rishi

     

All Replies

  • Monday, May 12, 2008 4:52 AMRishi Maini SQL DBA Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     Answer
    Sign In to Vote
    0
    Sign In to Vote

     

    For Backup and Recovery queries, please use the following forum link http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=744&SiteID=1

     

    Anyway coming back to your issue:-

     

    Error 112 is a OS Error which means :- "There is not enough space on the disk."

     

    So please check the space available on your D drive and if you are running short of space , make some space available on the D drive or try to backup the DB on a different drive that has sufficient space on it.

     

    Regards

    Rishi

     
  • Monday, May 12, 2008 6:00 AMDeepak RangarajanMVP, ModeratorUsers MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    Sign In to Vote
    0
    Sign In to Vote

    As mentioned by Rishi check the disk space. Thread moved to appropriate forum.

     

    - Deepak

     

     
  • Monday, May 12, 2008 2:52 PMVidhyaSagarMVP, ModeratorUsers MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    Sign In to Vote
    0
    Sign In to Vote

    Hi,

     

    To avoid this try to take transaction log backup frequently so that tlog backup size will be minimal!! Check and clear space in the drive where you are taking backup!

     
  • Monday, May 12, 2008 3:05 PMPraveen Barath Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    Sign In to Vote
    0
    Sign In to Vote

     

    It may not simply be disk space. It could also be rights to the share if it says "error not found".

    But as in this case i hope its a Disk space , i suggest you to kindly check both free disk space and security.

    Try to provide more disk as its occupying by .BAK file,

    Example - 10 GB of bak file try to free up space atleast 15 GB. Please correct me if i am wrong.

     

    Practically speaking it resolve my issues.

     

    Praveen Barath  

     
  • Tuesday, November 03, 2009 6:15 PMBenn21 Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    Sign In to Vote
    0
    Sign In to Vote
    COrrecto, es el espacion en disco..