|
|
Error when doing Diff Backup |
|
Author |
Message |
jenaemr
|
Posted: Thu Jun 03 21:56:49 CDT 2004 |
Top |
SQL Server >> 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
SQL Server22
|
|
|
|
|
ecardena
|
Posted: Thu Jun 03 21:56:49 CDT 2004 |
Top |
SQL Server >> 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 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.
|
|
|
|
|
|
|