Wednesday, March 21, 2012

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 Cárdenas
Senior support professional
This posting is provided "AS IS" with no warranties, and confers no rights.

No comments:

Post a Comment