Options
Backup Failure
stevejmartin
Posts: 7
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
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
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.