Error when doing Diff Backup

Hi Everyone,
I'm getting this weird error when doing a differential backup. Does anyone
know what could be the problem or how to fix it? Here is the log text.
========================================
==============================
Job server: WFLEXSQL
Job name: Winflex daily diff.
Job started: Tuesday, May 18, 2004 at 12:05:09 PM
Job type: Backup
Log file: BEX23.txt
========================================
==============================
Consistency checking WINFLEX
Consistency Check including Indexes.
There was a problem running the DBCC.
^ ^ ^ ^ ^
SQL Server returned the following error message:
Index row (1:196847:125) with values (BenefCode = 'MEDICAL ' and CoCode =
'GUN ' and EmpNum = '502709265g ' and PlanYear = 2003 and BenefCode =
'MEDICAL ') points to the data row identified by ().
^ ^ ^ ^ ^
Consistency checking tables from WINFLEX
Consistency checking PRIMARY
Consistency Check including Indexes.
There was a problem running the DBCC.
^ ^ ^ ^ ^
SQL Server returned the following error message:
Index row (1:196847:125) with values (BenefCode = 'MEDICAL ' and CoCode =
'GUN ' and EmpNum = '502709265g ' and PlanYear = 2003 and BenefCode =
'MEDICAL ') points to the data row identified by ().
^ ^ ^ ^ ^
Drive and media information from media mount:
Changer Name:
Drive Name: SONY 1
Media Slot: 0
Media Cartridge Label: 4MM000025
Targeted Media Set Name: Media Set 1
========================================
==============================
Job Operation - Backup
Media operation - overwrite.
Hardware compression enabled.
========================================
==============================
Media Name: "Media created 5/18/04 12:09:38 PM"
Backup of "WFLEXSQL "
Backup set #1 on storage media #1
Backup set description: "Winflex daily diff."
Backup Type: DATABASE - Only Back Up Database Changes (Differential)
Backup started on 5/18/04 at 12:09:52 PM.
Backup completed on 5/18/04 at 12:13:44 PM.
Backed up 1 database(s)
Backed up 1 filegroup(s) in 1 database(s)
Processed 1,520,449,536 bytes in 3 minutes and 52 seconds.
Throughput rate: 375.0 MB/min
---
========================================
==============================
Job Operation - Verify
========================================
==============================
Verify of "WFLEXSQL "
Backup set #1 on storage media #1
Backup set description: "Winflex daily diff."
Verify started on 5/18/04 at 12:14:01 PM.
Verify completed on 5/18/04 at 12:17:15 PM.
Verified 1 database(s)
Processed 1,520,449,536 bytes in 3 minutes and 14 seconds.
Throughput rate: 448.5 MB/min
---
Consistency checking WINFLEX
Consistency Check including Indexes.
There was a problem running the DBCC.
^ ^ ^ ^ ^
SQL Server returned the following error message:
Index row (1:196847:125) with values (BenefCode = 'MEDICAL ' and CoCode =
'GUN ' and EmpNum = '502709265g ' and PlanYear = 2003 and BenefCode =
'MEDICAL ') points to the data row identified by ().
^ ^ ^ ^ ^
Consistency checking tables from WINFLEX
Consistency checking PRIMARY
Consistency Check including Indexes.
There was a problem running the DBCC.
^ ^ ^ ^ ^
SQL Server returned the following error message:
Index row (1:196847:125) with values (BenefCode = 'MEDICAL ' and CoCode =
'GUN ' and EmpNum = '502709265g ' and PlanYear = 2003 and BenefCode =
'MEDICAL ') points to the data row identified by ().
^ ^ ^ ^ ^
========================================
==============================
Job ended: Tuesday, May 18, 2004 at 12:21:39 PM
Job completion status: Failed
========================================
==============================
Thank you in advance! I really appreciate it.
Josh Gerszewski> Hi Everyone,
> I'm getting this weird error when doing a differential backup. Does anyone
> know what could be the problem or how to fix it? Here is the log text.
> ========================================
==============================
> Job server: WFLEXSQL
> Job name: Winflex daily diff.
> Job started: Tuesday, May 18, 2004 at 12:05:09 PM
> Job type: Backup
> Log file: BEX23.txt
> ========================================
==============================
> Consistency checking WINFLEX
> Consistency Check including Indexes.
> There was a problem running the DBCC.
> ^ ^ ^ ^ ^
> SQL Server returned the following error message:
> Index row (1:196847:125) with values (BenefCode = 'MEDICAL ' and CoCode =
> 'GUN ' and EmpNum = '502709265g ' and PlanYear = 2003 and BenefCode =
> 'MEDICAL ') points to the data row identified by ().
>
> ^ ^ ^ ^ ^
> Consistency checking tables from WINFLEX
> Consistency checking PRIMARY
> Consistency Check including Indexes.
> There was a problem running the DBCC.
> ^ ^ ^ ^ ^
> SQL Server returned the following error message:
> Index row (1:196847:125) with values (BenefCode = 'MEDICAL ' and CoCode =
> 'GUN ' and EmpNum = '502709265g ' and PlanYear = 2003 and BenefCode =
> 'MEDICAL ') points to the data row identified by ().
>
> ^ ^ ^ ^ ^
>
> Drive and media information from media mount:
> Changer Name:
> Drive Name: SONY 1
> Media Slot: 0
> Media Cartridge Label: 4MM000025
> Targeted Media Set Name: Media Set 1
> ========================================
==============================
> Job Operation - Backup
> Media operation - overwrite.
> hardware compression enabled.
> ========================================
==============================
> Media Name: "Media created 5/18/04 12:09:38 PM"
> Backup of "WFLEXSQL "
> Backup set #1 on storage media #1
> Backup set description: "Winflex daily diff."
> Backup Type: DATABASE - Only Back Up Database Changes (Differential)
> Backup started on 5/18/04 at 12:09:52 PM.
> Backup completed on 5/18/04 at 12:13:44 PM.
> Backed up 1 database(s)
> Backed up 1 filegroup(s) in 1 database(s)
> Processed 1,520,449,536 bytes in 3 minutes and 52 seconds.
> Throughput rate: 375.0 MB/min
> ---
> ========================================
==============================
> Job Operation - Verify
> ========================================
==============================
> Verify of "WFLEXSQL "
> Backup set #1 on storage media #1
> Backup set description: "Winflex daily diff."
> Verify started on 5/18/04 at 12:14:01 PM.
> Verify completed on 5/18/04 at 12:17:15 PM.
> Verified 1 database(s)
> Processed 1,520,449,536 bytes in 3 minutes and 14 seconds.
> Throughput rate: 448.5 MB/min
> ---
> Consistency checking WINFLEX
> Consistency Check including Indexes.
> There was a problem running the DBCC.
> ^ ^ ^ ^ ^
> SQL Server returned the following error message:
> Index row (1:196847:125) with values (BenefCode = 'MEDICAL ' and CoCode =
> 'GUN ' and EmpNum = '502709265g ' and PlanYear = 2003 and BenefCode =
> 'MEDICAL ') points to the data row identified by ().
>
> ^ ^ ^ ^ ^
> Consistency checking tables from WINFLEX
> Consistency checking PRIMARY
> Consistency Check including Indexes.
> There was a problem running the DBCC.
> ^ ^ ^ ^ ^
> SQL Server returned the following error message:
> Index row (1:196847:125) with values (BenefCode = 'MEDICAL ' and CoCode =
> 'GUN ' and EmpNum = '502709265g ' and PlanYear = 2003 and BenefCode =
> 'MEDICAL ') points to the data row identified by ().
>
> ^ ^ ^ ^ ^
>
> ========================================
==============================
> Job ended: Tuesday, May 18, 2004 at 12:21:39 PM
> Job completion status: Failed
> ========================================
==============================
> Thank you in advance! I really appreciate it.
> Josh Gerszewski
--
Hi Josh,
You should run
DBCC CheckDB 'WINFLEX', repair_fast
to fix these errors. For more details, please consult your SQL Server Books
Online.
Hope this helps,
Eric Crdenas
Senior support professional
This posting is provided "AS IS" with no warranties, and confers no rights.sql