SQL Server Performance

Backup Failing. Status=112

Discussion in 'General DBA Questions' started by photura, Mar 27, 2006.

  1. photura New Member

    Does anyone know what status 112 is. I looked in BOL and it said "Variables are not allowed in the %ls statement."

    ??

    Any thoughts would be greatly appreciated.

    Thanks.
  2. Tahsin New Member

  3. photura New Member

    Yes. You were absolutely correct. The disk was out of space.

    Thanks!


    quote:Originally posted by Tahsin

    Could you be a little more descriptive with the problem scenario. I am guessing it is an I/O error. Check the disk space and see if it is full. BTW, what is your disk setup?

    This article may provide some insight:
    http://support.microsoft.com/default.aspx?scid=kb;en-us;325334

    - Tahsin
  4. Luis Martin Moderator

    Well done Tahsin!!!!!!!

    Luis Martin
    Moderator
    SQL-Server-Performance.com

    Although nature commences with reason and ends in experience it is necessary for us to do the opposite, that is to commence with experience and from this to proceed to investigate the reason.
    Leonardo Da Vinci

    Nunca esperes el reconocimiento de tus hijos, eso ocurrirá luego de tu muerte


    All postings are provided “AS IS” with no warranties for accuracy.



  5. satya Moderator

    Post the queyr used to backup the database/log for further investigations, in addition to what has been referred above.

    Satya SKJ
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  6. Tahsin New Member

    <blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><i>Originally posted by LuisMartin</i><br /><br />Well done Tahsin!!!!!!!<br /><br />Luis Martin<br />Moderator<br />SQL-Server-Performance.com<br /><br /><hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote"><br /><br />Thanks Luis [<img src='/community/emoticons/emotion-2.gif' alt=':D' />]
  7. photura New Member

    BACKUP DATABASE [Database] TO DISK = N'E:BackupDatabase_Test_Backup' WITH INIT , NOUNLOAD , NAME = N'Database backup - Nightly Full', NOSKIP , STATS = 10, NOFORMAT DECLARE @i INT
    select @i = position from msdb..backupset where database_name='Database'and type!='F' and backup_set_id=(select max(backup_set_id) from msdb..backupset where database_name='Database')
    RESTORE VERIFYONLY FROM DISK = N'E:BackupDatabase_Test_Backup' WITH FILE = @i





    quote:Originally posted by satya

    Post the queyr used to backup the database/log for further investigations, in addition to what has been referred above.

    Satya SKJ
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

Share This Page