Search

Thursday, August 23, 2012

Backup job failed – no space Error 112

Generally we get 112 error for backup and other sql related error log errors as: 

[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3202: [Microsoft][ODBC SQL Server Driver][SQL Server]Write on 'xxx.BAK' failed, status = 112. See the SQL Server error log for more details. [Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP DATABASE is terminating abnormally. 

DESCRIPTION: BackupMedium:: ReportIoError: write failure on backup device 'zzz.bak'. Operating system error 112(There is not enough space on the disk.). 

Note– “When you create a maintenance plan and maintenance plan job fails always check the history at maintenance plan history or report location to get the exact error” 
112 error means disk is occupied and full, and if you read the error it clearly specifies that there is not enough space. On this drive 

To solve this error:
  • Remove old backup unwanted files from that drive  
  • Move the backup or database files to another drive.  
  • Increase the drive size(external Drive SAN) 

21 comments:

  1. I am really happy with your blog because your article is very unique and powerful for new reader.
    selenium training in chennai

    ReplyDelete
  2. Outstanding blog thanks for sharing such wonderful blog with us ,after long time came across such knowlegeble blog. keep sharing such informative blog with us.
    Regards,
    SQL Training in Chennai | SQL DPA Training in Chennai | SQL Training institute in Chennai

    ReplyDelete
  3. I wish to show thanks to you just for bailing me out of this particular trouble.As a result of checking through the net and meeting techniques that were not productive, I thought my life was done.
    angular js training in chennai

    angular js training in tambaram

    full stack training in chennai

    full stack training in tambaram

    php training in chennai

    php training in tambaram

    photoshop training in chennai

    photoshop training in tambaram

    ReplyDelete
  4. It is the science and engineering of making intelligent machines, especially intelligent computer programs. Yes, but what is intelligence? Intelligence is the computational part of the ability to achieve goals in the world. Varying kinds and degrees of intelligence occur in people, many animals and some machines.
    AI Training in Bangalore

    AI Course in Bangalore

    ReplyDelete
  5. It s a very useful page. Thank you. 9c93e68488999220524b340122676c52
    karaman
    caybasi
    kursunlu
    saraykent
    turhal
    efeler
    refahiye
    altindag
    kayseri

    ReplyDelete
  6. It s a very useful page. Thank you. cafd676f0ea8ec457dd2e831a7ab62a7
    posof
    ortahisar
    boronova
    geybe
    golbasi
    kilis
    yenice
    bayramoren
    selendi

    ReplyDelete
  7. It s a very useful page. Thank you. 9d8e8f690e044ce30035037514d20064
    macka
    fatsa
    alapli
    kiziloren
    cigli
    cilimli
    narman
    tufanbeyli
    korkuteli

    ReplyDelete
  8. Congratulations on your article, it was very helpful and successful. 855b4788283431c686a37cdcf260a1ba
    website kurma
    sms onay
    website kurma

    ReplyDelete
  9. Thank you for your explanation, very good content. 4f97af6c4a6316404347cc3d98d14d0a
    altın dedektörü

    ReplyDelete