Backup Failing

  • I have schedule Backup Job which is failing since yesterday, it was running fine until yesterday. I have schedule it through DB Maintance wizard.

    Any clue?

     

     

  • what is the error message? 

    -- Cory

  • The description for Event ID ( 17055 ) in Source ( MSSQLSERVER ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. The following information is part of the event: 18265, Log backed up: Database: SPCD1, creation date(time): 2005/01/12(10:29:30), first LSN: 182711:4556:1, last LSN: 184705:10023:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'d:\MSSQL\BACKUP\SPCD1\ESICV2_20070312.BAK'}).

    .

  • Look through the SQL Server Error Log....there is a good chance you ran out of space on your backup drive.

    -SQLBill

  • It looks like a success message to me.  Did you check to see if the file in the "Log backed up" message exists and has a log backup in it?

     

    A disk full problem should generate OS error 112.

     

     

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply