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.
Showing posts with label weird. Show all posts
Showing posts with label weird. Show all posts
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.
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.
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
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
Monday, March 12, 2012
Error when changing sa password or when trying to access DB via sa
Hi,
Two weird things with the sa account, and I found a solution on
Microsoft.com, but it's not working.
First, when I go to change the SA password in Enterprise Manager, I
get the following error:
Error 21776: [SQL-DMO] The name 'dbo' was not found in the Users
collection. If the name is a qualified name, use [] to separate
various parts of the name, and try again.
So, I checked the knowledgebase and found this:
http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/Q218/1/72.ASP&NoWebContent=1#appliesto
This is the exact issue I'm having, but when I run: sp_changedbowner
sa
... I get the following message in Query Analyzer:
Server: Msg 15109, Level 16, State 1, Procedure sp_changedbowner, Line
22
Cannot change the owner of the master database.
So, I searched for this error and found this:
http://support.microsoft.com/default.aspx?scid=kb;en-us;328173
Catch-22... I need to change the Master DB to be owned by 'sa', yet it
won't let me change it since it's not already owned. Am I missing
something? This did happen just after I restored a database, just as
discribed in the first support doc, but it gives no exact syntax on
what to plug into Query Analyzer to resolve the issue, other then
using the sp_changedbowner stored procedure. And I must be using it
incorrectly to get the error, or it's another bug in MS SQL.
Can someone point me to the right direction? What should be an easy
back-up and restore is turning into a multi-hour ordeal.
Thanks,
Alex.If your a local admin or domain admin connect to the SQL Server using Query
Analyser and ask for a 'WinNT Authentication' then issue the following
command
A. Change the password of a login without a former password
This example changes the password for the login Victoria from a NULL
password to "B3r12-36".
EXEC sp_password NULL, 'B3r12-36', 'Victoria'
In EnterPrise manager Delete and Re-Register the troublesome server, when
registering use the new password.
--
HTH
Ryan Waight, MCDBA, MCSE
"Alex" <alex@.totallynerd.com> wrote in message
news:2ba4b4eb.0310270835.36d6e245@.posting.google.com...
> Hi,
> Two weird things with the sa account, and I found a solution on
> Microsoft.com, but it's not working.
> First, when I go to change the SA password in Enterprise Manager, I
> get the following error:
> Error 21776: [SQL-DMO] The name 'dbo' was not found in the Users
> collection. If the name is a qualified name, use [] to separate
> various parts of the name, and try again.
> So, I checked the knowledgebase and found this:
>
http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/Q218/1/72.ASP&NoWebContent=1#appliesto
> This is the exact issue I'm having, but when I run: sp_changedbowner
> sa
> ... I get the following message in Query Analyzer:
> Server: Msg 15109, Level 16, State 1, Procedure sp_changedbowner, Line
> 22
> Cannot change the owner of the master database.
> So, I searched for this error and found this:
> http://support.microsoft.com/default.aspx?scid=kb;en-us;328173
> Catch-22... I need to change the Master DB to be owned by 'sa', yet it
> won't let me change it since it's not already owned. Am I missing
> something? This did happen just after I restored a database, just as
> discribed in the first support doc, but it gives no exact syntax on
> what to plug into Query Analyzer to resolve the issue, other then
> using the sp_changedbowner stored procedure. And I must be using it
> incorrectly to get the error, or it's another bug in MS SQL.
> Can someone point me to the right direction? What should be an easy
> back-up and restore is turning into a multi-hour ordeal.
> Thanks,
> Alex.|||Yes, you cannot change database owner to MASTER.
If you run sp_helpuser on your restored database, should
show the "LoginName" as NULL if 'sa' do not own it.
You only needed to run sp_changedbowner on your restored
database. -->
use <restored_db>
go
sp_changedbowner 'sa'
go
Two weird things with the sa account, and I found a solution on
Microsoft.com, but it's not working.
First, when I go to change the SA password in Enterprise Manager, I
get the following error:
Error 21776: [SQL-DMO] The name 'dbo' was not found in the Users
collection. If the name is a qualified name, use [] to separate
various parts of the name, and try again.
So, I checked the knowledgebase and found this:
http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/Q218/1/72.ASP&NoWebContent=1#appliesto
This is the exact issue I'm having, but when I run: sp_changedbowner
sa
... I get the following message in Query Analyzer:
Server: Msg 15109, Level 16, State 1, Procedure sp_changedbowner, Line
22
Cannot change the owner of the master database.
So, I searched for this error and found this:
http://support.microsoft.com/default.aspx?scid=kb;en-us;328173
Catch-22... I need to change the Master DB to be owned by 'sa', yet it
won't let me change it since it's not already owned. Am I missing
something? This did happen just after I restored a database, just as
discribed in the first support doc, but it gives no exact syntax on
what to plug into Query Analyzer to resolve the issue, other then
using the sp_changedbowner stored procedure. And I must be using it
incorrectly to get the error, or it's another bug in MS SQL.
Can someone point me to the right direction? What should be an easy
back-up and restore is turning into a multi-hour ordeal.
Thanks,
Alex.If your a local admin or domain admin connect to the SQL Server using Query
Analyser and ask for a 'WinNT Authentication' then issue the following
command
A. Change the password of a login without a former password
This example changes the password for the login Victoria from a NULL
password to "B3r12-36".
EXEC sp_password NULL, 'B3r12-36', 'Victoria'
In EnterPrise manager Delete and Re-Register the troublesome server, when
registering use the new password.
--
HTH
Ryan Waight, MCDBA, MCSE
"Alex" <alex@.totallynerd.com> wrote in message
news:2ba4b4eb.0310270835.36d6e245@.posting.google.com...
> Hi,
> Two weird things with the sa account, and I found a solution on
> Microsoft.com, but it's not working.
> First, when I go to change the SA password in Enterprise Manager, I
> get the following error:
> Error 21776: [SQL-DMO] The name 'dbo' was not found in the Users
> collection. If the name is a qualified name, use [] to separate
> various parts of the name, and try again.
> So, I checked the knowledgebase and found this:
>
http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/Q218/1/72.ASP&NoWebContent=1#appliesto
> This is the exact issue I'm having, but when I run: sp_changedbowner
> sa
> ... I get the following message in Query Analyzer:
> Server: Msg 15109, Level 16, State 1, Procedure sp_changedbowner, Line
> 22
> Cannot change the owner of the master database.
> So, I searched for this error and found this:
> http://support.microsoft.com/default.aspx?scid=kb;en-us;328173
> Catch-22... I need to change the Master DB to be owned by 'sa', yet it
> won't let me change it since it's not already owned. Am I missing
> something? This did happen just after I restored a database, just as
> discribed in the first support doc, but it gives no exact syntax on
> what to plug into Query Analyzer to resolve the issue, other then
> using the sp_changedbowner stored procedure. And I must be using it
> incorrectly to get the error, or it's another bug in MS SQL.
> Can someone point me to the right direction? What should be an easy
> back-up and restore is turning into a multi-hour ordeal.
> Thanks,
> Alex.|||Yes, you cannot change database owner to MASTER.
If you run sp_helpuser on your restored database, should
show the "LoginName" as NULL if 'sa' do not own it.
You only needed to run sp_changedbowner on your restored
database. -->
use <restored_db>
go
sp_changedbowner 'sa'
go
Subscribe to:
Posts (Atom)