Backup Failure

stevejmartinstevejmartin Posts: 7
edited December 11, 2007 12:09PM in SQL Backup Previous Versions
I'm currently looking at the trial version for evaluation purposes.

I have SQL 2005 installed locally on the same machine that SQL backup is installed.

I can successfully backup two of the smaller DB's to my local drive (which has over 400Gb available) but when I try to backup a 41Gb DB I get the following messages:

local: Backup - Failed
======================

Performing full backups - Failed

This operation failed with errors.

Backing up fish4 (full database) to:
E:\MSSQL.1\MSSQL\Backup\FULL_fish4_20071211_151436.sqb
Thread 0 error:
Error 620: Error writing to backup file(s).
Process terminated unexpectedly. Error code: -2139684860
Warning 210: Thread 0 warning:
Warning 210: Error writing to backup file: E:\MSSQL.1\MSSQL\Backup\FULL_fish4_20071211_151436.sqb
Warning: System error 87 (The parameter is incorrect)
SQL error 3013: SQL error 3013: BACKUP DATABASE is terminating abnormally.
SQL error 3271: SQL error 3271: A nonrecoverable I/O error occurred on file "SQLBACKUP_F07989DE-6EF7-49E0-BC11-7FA57CDA1878:" 995(error not found).
SQL error 7694: SQL error 7694: Failed to pause catalog for backup. Backup was aborted.
SQL Backup exit code: 790
SQL error code: 7694



Updating SQL Server information - Successful

This operation completed successfully.


Many thanks
Steve

Comments

  • Brian DonahueBrian Donahue Posts: 6,590 New member
    The error eludes to a fulltext catalogue that cannot be backed up. I would check that the msftesql service is running on the SQL Server and that the service account for the service is valid.

    Alternatively you could enable some trace flags that will log more information about the full-text service into the SQl Server logs:

    dbcc traceon(7603,7604,-1)

    Hopefully some of these suggestions help. The problem is not with the size of the database, it's just that this particualr database either has a damaged full-text catalog or a problem in the FTX service.
Sign In or Register to comment.