Regarding the above errors, I decided to apply sp4. A copy of the database was made and placed on a test server and now we cannot start the SQL Server. I have checked the registration and all seems fine. Any ideas ?Check the contents of the ERRORLOG file in LOGS directory as well as Application and System errorlog in Event Viewer and let us know what you see there.|||You need to identify what the base cause of this problem is. The first step to doing that is reviewing all errors on the machine in question.|||The above problem is now okay. DBAs from another Department came over and assisted with the problem. Because we had problems moving the data to another location, we decided to make a copy of the database and run DBCC repair on the production database. This fixed the problem and only a few records were lost.
Thanks to all for your assistance.
Showing posts with label regarding. Show all posts
Showing posts with label regarding. Show all posts
Monday, March 26, 2012
Sunday, March 11, 2012
ERROR 605, SEVERITY 21
Hi,
I found error in the SERVER(subscriber in merge replication) windows event
viewer the error is regarding a particular database(out of 15).
Event Type: Error
Event Source: MSSQLSERVER
Event Category: (2)
Event ID: 17052
Date: 6/23/2005
Time: 12:32:26 AM
User: N/A
Computer: DTDPMS
Description:
Error: 605, Severity: 21, State: 1
Attempt to fetch logical page (1:98036) in database 'CERES' belongs to
object 'PatientAlerts', not to object 'chargepostingprocs'.
Data:
0000: 5d 02 00 00 15 00 00 00 ]......
0008: 07 00 00 00 44 00 54 00 ...D.T.
0010: 44 00 50 00 4d 00 53 00 D.P.M.S.
0018: 00 00 06 00 00 00 43 00 .....C.
0020: 45 00 52 00 45 00 53 00 E.R.E.S.
0028: 00 00 ..
can u help me.
What is the reason for this message?
How can I resolve this?
Thanks,
Sourahttp://www.mssqlcity.com/FAQ/Trouble/er605.htm
--
HTH, Jens Suessmeyer.
--
http://www.sqlserver2005.de
--
"SouRa" <SouRa@.discussions.microsoft.com> schrieb im Newsbeitrag
news:3A2EC9C8-06D3-4BC7-85BF-22A732A35B6C@.microsoft.com...
> Hi,
> I found error in the SERVER(subscriber in merge replication) windows event
> viewer the error is regarding a particular database(out of 15).
>
> Event Type: Error
> Event Source: MSSQLSERVER
> Event Category: (2)
> Event ID: 17052
> Date: 6/23/2005
> Time: 12:32:26 AM
> User: N/A
> Computer: DTDPMS
> Description:
> Error: 605, Severity: 21, State: 1
> Attempt to fetch logical page (1:98036) in database 'CERES' belongs to
> object 'PatientAlerts', not to object 'chargepostingprocs'.
> Data:
> 0000: 5d 02 00 00 15 00 00 00 ]......
> 0008: 07 00 00 00 44 00 54 00 ...D.T.
> 0010: 44 00 50 00 4d 00 53 00 D.P.M.S.
> 0018: 00 00 06 00 00 00 43 00 .....C.
> 0020: 45 00 52 00 45 00 53 00 E.R.E.S.
> 0028: 00 00 ..
> can u help me.
> What is the reason for this message?
> How can I resolve this?
> Thanks,
> Soura
>|||The first thing should be to check the db integrity using "dbcc checkdb".
AMB
"SouRa" wrote:
> Hi,
> I found error in the SERVER(subscriber in merge replication) windows event
> viewer the error is regarding a particular database(out of 15).
>
> Event Type: Error
> Event Source: MSSQLSERVER
> Event Category: (2)
> Event ID: 17052
> Date: 6/23/2005
> Time: 12:32:26 AM
> User: N/A
> Computer: DTDPMS
> Description:
> Error: 605, Severity: 21, State: 1
> Attempt to fetch logical page (1:98036) in database 'CERES' belongs to
> object 'PatientAlerts', not to object 'chargepostingprocs'.
> Data:
> 0000: 5d 02 00 00 15 00 00 00 ]......
> 0008: 07 00 00 00 44 00 54 00 ...D.T.
> 0010: 44 00 50 00 4d 00 53 00 D.P.M.S.
> 0018: 00 00 06 00 00 00 43 00 .....C.
> 0020: 45 00 52 00 45 00 53 00 E.R.E.S.
> 0028: 00 00 ..
> can u help me.
> What is the reason for this message?
> How can I resolve this?
> Thanks,
> Soura
>|||http://www.karaszi.com/SQLServer/info_corrupt_suspect_db.asp
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"SouRa" <SouRa@.discussions.microsoft.com> wrote in message
news:3A2EC9C8-06D3-4BC7-85BF-22A732A35B6C@.microsoft.com...
> Hi,
> I found error in the SERVER(subscriber in merge replication) windows event
> viewer the error is regarding a particular database(out of 15).
>
> Event Type: Error
> Event Source: MSSQLSERVER
> Event Category: (2)
> Event ID: 17052
> Date: 6/23/2005
> Time: 12:32:26 AM
> User: N/A
> Computer: DTDPMS
> Description:
> Error: 605, Severity: 21, State: 1
> Attempt to fetch logical page (1:98036) in database 'CERES' belongs to
> object 'PatientAlerts', not to object 'chargepostingprocs'.
> Data:
> 0000: 5d 02 00 00 15 00 00 00 ]......
> 0008: 07 00 00 00 44 00 54 00 ...D.T.
> 0010: 44 00 50 00 4d 00 53 00 D.P.M.S.
> 0018: 00 00 06 00 00 00 43 00 .....C.
> 0020: 45 00 52 00 45 00 53 00 E.R.E.S.
> 0028: 00 00 ..
> can u help me.
> What is the reason for this message?
> How can I resolve this?
> Thanks,
> Soura
>
I found error in the SERVER(subscriber in merge replication) windows event
viewer the error is regarding a particular database(out of 15).
Event Type: Error
Event Source: MSSQLSERVER
Event Category: (2)
Event ID: 17052
Date: 6/23/2005
Time: 12:32:26 AM
User: N/A
Computer: DTDPMS
Description:
Error: 605, Severity: 21, State: 1
Attempt to fetch logical page (1:98036) in database 'CERES' belongs to
object 'PatientAlerts', not to object 'chargepostingprocs'.
Data:
0000: 5d 02 00 00 15 00 00 00 ]......
0008: 07 00 00 00 44 00 54 00 ...D.T.
0010: 44 00 50 00 4d 00 53 00 D.P.M.S.
0018: 00 00 06 00 00 00 43 00 .....C.
0020: 45 00 52 00 45 00 53 00 E.R.E.S.
0028: 00 00 ..
can u help me.
What is the reason for this message?
How can I resolve this?
Thanks,
Sourahttp://www.mssqlcity.com/FAQ/Trouble/er605.htm
--
HTH, Jens Suessmeyer.
--
http://www.sqlserver2005.de
--
"SouRa" <SouRa@.discussions.microsoft.com> schrieb im Newsbeitrag
news:3A2EC9C8-06D3-4BC7-85BF-22A732A35B6C@.microsoft.com...
> Hi,
> I found error in the SERVER(subscriber in merge replication) windows event
> viewer the error is regarding a particular database(out of 15).
>
> Event Type: Error
> Event Source: MSSQLSERVER
> Event Category: (2)
> Event ID: 17052
> Date: 6/23/2005
> Time: 12:32:26 AM
> User: N/A
> Computer: DTDPMS
> Description:
> Error: 605, Severity: 21, State: 1
> Attempt to fetch logical page (1:98036) in database 'CERES' belongs to
> object 'PatientAlerts', not to object 'chargepostingprocs'.
> Data:
> 0000: 5d 02 00 00 15 00 00 00 ]......
> 0008: 07 00 00 00 44 00 54 00 ...D.T.
> 0010: 44 00 50 00 4d 00 53 00 D.P.M.S.
> 0018: 00 00 06 00 00 00 43 00 .....C.
> 0020: 45 00 52 00 45 00 53 00 E.R.E.S.
> 0028: 00 00 ..
> can u help me.
> What is the reason for this message?
> How can I resolve this?
> Thanks,
> Soura
>|||The first thing should be to check the db integrity using "dbcc checkdb".
AMB
"SouRa" wrote:
> Hi,
> I found error in the SERVER(subscriber in merge replication) windows event
> viewer the error is regarding a particular database(out of 15).
>
> Event Type: Error
> Event Source: MSSQLSERVER
> Event Category: (2)
> Event ID: 17052
> Date: 6/23/2005
> Time: 12:32:26 AM
> User: N/A
> Computer: DTDPMS
> Description:
> Error: 605, Severity: 21, State: 1
> Attempt to fetch logical page (1:98036) in database 'CERES' belongs to
> object 'PatientAlerts', not to object 'chargepostingprocs'.
> Data:
> 0000: 5d 02 00 00 15 00 00 00 ]......
> 0008: 07 00 00 00 44 00 54 00 ...D.T.
> 0010: 44 00 50 00 4d 00 53 00 D.P.M.S.
> 0018: 00 00 06 00 00 00 43 00 .....C.
> 0020: 45 00 52 00 45 00 53 00 E.R.E.S.
> 0028: 00 00 ..
> can u help me.
> What is the reason for this message?
> How can I resolve this?
> Thanks,
> Soura
>|||http://www.karaszi.com/SQLServer/info_corrupt_suspect_db.asp
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"SouRa" <SouRa@.discussions.microsoft.com> wrote in message
news:3A2EC9C8-06D3-4BC7-85BF-22A732A35B6C@.microsoft.com...
> Hi,
> I found error in the SERVER(subscriber in merge replication) windows event
> viewer the error is regarding a particular database(out of 15).
>
> Event Type: Error
> Event Source: MSSQLSERVER
> Event Category: (2)
> Event ID: 17052
> Date: 6/23/2005
> Time: 12:32:26 AM
> User: N/A
> Computer: DTDPMS
> Description:
> Error: 605, Severity: 21, State: 1
> Attempt to fetch logical page (1:98036) in database 'CERES' belongs to
> object 'PatientAlerts', not to object 'chargepostingprocs'.
> Data:
> 0000: 5d 02 00 00 15 00 00 00 ]......
> 0008: 07 00 00 00 44 00 54 00 ...D.T.
> 0010: 44 00 50 00 4d 00 53 00 D.P.M.S.
> 0018: 00 00 06 00 00 00 43 00 .....C.
> 0020: 45 00 52 00 45 00 53 00 E.R.E.S.
> 0028: 00 00 ..
> can u help me.
> What is the reason for this message?
> How can I resolve this?
> Thanks,
> Soura
>
ERROR 605, SEVERITY 21
Hi,
I found error in the SERVER(subscriber in merge replication) windows event
viewer the error is regarding a particular database(out of 15).
Event Type: Error
Event Source: MSSQLSERVER
Event Category: (2)
Event ID: 17052
Date: 6/23/2005
Time: 12:32:26 AM
User: N/A
Computer: DTDPMS
Description:
Error: 605, Severity: 21, State: 1
Attempt to fetch logical page (1:98036) in database 'CERES' belongs to
object 'PatientAlerts', not to object 'chargepostingprocs'.
Data:
0000: 5d 02 00 00 15 00 00 00 ]......
0008: 07 00 00 00 44 00 54 00 ...D.T.
0010: 44 00 50 00 4d 00 53 00 D.P.M.S.
0018: 00 00 06 00 00 00 43 00 .....C.
0020: 45 00 52 00 45 00 53 00 E.R.E.S.
0028: 00 00 ..
can u help me.
What is the reason for this message?
How can I resolve this?
Thanks,
Sourahttp://www.mssqlcity.com/FAQ/Trouble/er605.htm
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
--
"SouRa" <SouRa@.discussions.microsoft.com> schrieb im Newsbeitrag
news:3A2EC9C8-06D3-4BC7-85BF-22A732A35B6C@.microsoft.com...
> Hi,
> I found error in the SERVER(subscriber in merge replication) windows event
> viewer the error is regarding a particular database(out of 15).
>
> Event Type: Error
> Event Source: MSSQLSERVER
> Event Category: (2)
> Event ID: 17052
> Date: 6/23/2005
> Time: 12:32:26 AM
> User: N/A
> Computer: DTDPMS
> Description:
> Error: 605, Severity: 21, State: 1
> Attempt to fetch logical page (1:98036) in database 'CERES' belongs to
> object 'PatientAlerts', not to object 'chargepostingprocs'.
> Data:
> 0000: 5d 02 00 00 15 00 00 00 ]......
> 0008: 07 00 00 00 44 00 54 00 ...D.T.
> 0010: 44 00 50 00 4d 00 53 00 D.P.M.S.
> 0018: 00 00 06 00 00 00 43 00 .....C.
> 0020: 45 00 52 00 45 00 53 00 E.R.E.S.
> 0028: 00 00 ..
> can u help me.
> What is the reason for this message?
> How can I resolve this?
> Thanks,
> Soura
>|||The first thing should be to check the db integrity using "dbcc checkdb".
AMB
"SouRa" wrote:
> Hi,
> I found error in the SERVER(subscriber in merge replication) windows event
> viewer the error is regarding a particular database(out of 15).
>
> Event Type: Error
> Event Source: MSSQLSERVER
> Event Category: (2)
> Event ID: 17052
> Date: 6/23/2005
> Time: 12:32:26 AM
> User: N/A
> Computer: DTDPMS
> Description:
> Error: 605, Severity: 21, State: 1
> Attempt to fetch logical page (1:98036) in database 'CERES' belongs to
> object 'PatientAlerts', not to object 'chargepostingprocs'.
> Data:
> 0000: 5d 02 00 00 15 00 00 00 ]......
> 0008: 07 00 00 00 44 00 54 00 ...D.T.
> 0010: 44 00 50 00 4d 00 53 00 D.P.M.S.
> 0018: 00 00 06 00 00 00 43 00 .....C.
> 0020: 45 00 52 00 45 00 53 00 E.R.E.S.
> 0028: 00 00 ..
> can u help me.
> What is the reason for this message?
> How can I resolve this?
> Thanks,
> Soura
>|||http://www.karaszi.com/SQLServer/in..._suspect_db.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"SouRa" <SouRa@.discussions.microsoft.com> wrote in message
news:3A2EC9C8-06D3-4BC7-85BF-22A732A35B6C@.microsoft.com...
> Hi,
> I found error in the SERVER(subscriber in merge replication) windows event
> viewer the error is regarding a particular database(out of 15).
>
> Event Type: Error
> Event Source: MSSQLSERVER
> Event Category: (2)
> Event ID: 17052
> Date: 6/23/2005
> Time: 12:32:26 AM
> User: N/A
> Computer: DTDPMS
> Description:
> Error: 605, Severity: 21, State: 1
> Attempt to fetch logical page (1:98036) in database 'CERES' belongs to
> object 'PatientAlerts', not to object 'chargepostingprocs'.
> Data:
> 0000: 5d 02 00 00 15 00 00 00 ]......
> 0008: 07 00 00 00 44 00 54 00 ...D.T.
> 0010: 44 00 50 00 4d 00 53 00 D.P.M.S.
> 0018: 00 00 06 00 00 00 43 00 .....C.
> 0020: 45 00 52 00 45 00 53 00 E.R.E.S.
> 0028: 00 00 ..
> can u help me.
> What is the reason for this message?
> How can I resolve this?
> Thanks,
> Soura
>
I found error in the SERVER(subscriber in merge replication) windows event
viewer the error is regarding a particular database(out of 15).
Event Type: Error
Event Source: MSSQLSERVER
Event Category: (2)
Event ID: 17052
Date: 6/23/2005
Time: 12:32:26 AM
User: N/A
Computer: DTDPMS
Description:
Error: 605, Severity: 21, State: 1
Attempt to fetch logical page (1:98036) in database 'CERES' belongs to
object 'PatientAlerts', not to object 'chargepostingprocs'.
Data:
0000: 5d 02 00 00 15 00 00 00 ]......
0008: 07 00 00 00 44 00 54 00 ...D.T.
0010: 44 00 50 00 4d 00 53 00 D.P.M.S.
0018: 00 00 06 00 00 00 43 00 .....C.
0020: 45 00 52 00 45 00 53 00 E.R.E.S.
0028: 00 00 ..
can u help me.
What is the reason for this message?
How can I resolve this?
Thanks,
Sourahttp://www.mssqlcity.com/FAQ/Trouble/er605.htm
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
--
"SouRa" <SouRa@.discussions.microsoft.com> schrieb im Newsbeitrag
news:3A2EC9C8-06D3-4BC7-85BF-22A732A35B6C@.microsoft.com...
> Hi,
> I found error in the SERVER(subscriber in merge replication) windows event
> viewer the error is regarding a particular database(out of 15).
>
> Event Type: Error
> Event Source: MSSQLSERVER
> Event Category: (2)
> Event ID: 17052
> Date: 6/23/2005
> Time: 12:32:26 AM
> User: N/A
> Computer: DTDPMS
> Description:
> Error: 605, Severity: 21, State: 1
> Attempt to fetch logical page (1:98036) in database 'CERES' belongs to
> object 'PatientAlerts', not to object 'chargepostingprocs'.
> Data:
> 0000: 5d 02 00 00 15 00 00 00 ]......
> 0008: 07 00 00 00 44 00 54 00 ...D.T.
> 0010: 44 00 50 00 4d 00 53 00 D.P.M.S.
> 0018: 00 00 06 00 00 00 43 00 .....C.
> 0020: 45 00 52 00 45 00 53 00 E.R.E.S.
> 0028: 00 00 ..
> can u help me.
> What is the reason for this message?
> How can I resolve this?
> Thanks,
> Soura
>|||The first thing should be to check the db integrity using "dbcc checkdb".
AMB
"SouRa" wrote:
> Hi,
> I found error in the SERVER(subscriber in merge replication) windows event
> viewer the error is regarding a particular database(out of 15).
>
> Event Type: Error
> Event Source: MSSQLSERVER
> Event Category: (2)
> Event ID: 17052
> Date: 6/23/2005
> Time: 12:32:26 AM
> User: N/A
> Computer: DTDPMS
> Description:
> Error: 605, Severity: 21, State: 1
> Attempt to fetch logical page (1:98036) in database 'CERES' belongs to
> object 'PatientAlerts', not to object 'chargepostingprocs'.
> Data:
> 0000: 5d 02 00 00 15 00 00 00 ]......
> 0008: 07 00 00 00 44 00 54 00 ...D.T.
> 0010: 44 00 50 00 4d 00 53 00 D.P.M.S.
> 0018: 00 00 06 00 00 00 43 00 .....C.
> 0020: 45 00 52 00 45 00 53 00 E.R.E.S.
> 0028: 00 00 ..
> can u help me.
> What is the reason for this message?
> How can I resolve this?
> Thanks,
> Soura
>|||http://www.karaszi.com/SQLServer/in..._suspect_db.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"SouRa" <SouRa@.discussions.microsoft.com> wrote in message
news:3A2EC9C8-06D3-4BC7-85BF-22A732A35B6C@.microsoft.com...
> Hi,
> I found error in the SERVER(subscriber in merge replication) windows event
> viewer the error is regarding a particular database(out of 15).
>
> Event Type: Error
> Event Source: MSSQLSERVER
> Event Category: (2)
> Event ID: 17052
> Date: 6/23/2005
> Time: 12:32:26 AM
> User: N/A
> Computer: DTDPMS
> Description:
> Error: 605, Severity: 21, State: 1
> Attempt to fetch logical page (1:98036) in database 'CERES' belongs to
> object 'PatientAlerts', not to object 'chargepostingprocs'.
> Data:
> 0000: 5d 02 00 00 15 00 00 00 ]......
> 0008: 07 00 00 00 44 00 54 00 ...D.T.
> 0010: 44 00 50 00 4d 00 53 00 D.P.M.S.
> 0018: 00 00 06 00 00 00 43 00 .....C.
> 0020: 45 00 52 00 45 00 53 00 E.R.E.S.
> 0028: 00 00 ..
> can u help me.
> What is the reason for this message?
> How can I resolve this?
> Thanks,
> Soura
>
ERROR 605, SEVERITY 21
Hi,
I found error in the SERVER(subscriber in merge replication) windows event
viewer the error is regarding a particular database(out of 15).
Event Type: Error
Event Source: MSSQLSERVER
Event Category: (2)
Event ID: 17052
Date: 6/23/2005
Time: 12:32:26 AM
User: N/A
Computer: DTDPMS
Description:
Error: 605, Severity: 21, State: 1
Attempt to fetch logical page (1:98036) in database 'CERES' belongs to
object 'PatientAlerts', not to object 'chargepostingprocs'.
Data:
0000: 5d 02 00 00 15 00 00 00 ]......
0008: 07 00 00 00 44 00 54 00 ...D.T.
0010: 44 00 50 00 4d 00 53 00 D.P.M.S.
0018: 00 00 06 00 00 00 43 00 .....C.
0020: 45 00 52 00 45 00 53 00 E.R.E.S.
0028: 00 00 ..
can u help me.
What is the reason for this message?
How can I resolve this?
Thanks,
Soura
http://www.mssqlcity.com/FAQ/Trouble/er605.htm
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
"SouRa" <SouRa@.discussions.microsoft.com> schrieb im Newsbeitrag
news:3A2EC9C8-06D3-4BC7-85BF-22A732A35B6C@.microsoft.com...
> Hi,
> I found error in the SERVER(subscriber in merge replication) windows event
> viewer the error is regarding a particular database(out of 15).
>
> Event Type: Error
> Event Source: MSSQLSERVER
> Event Category: (2)
> Event ID: 17052
> Date: 6/23/2005
> Time: 12:32:26 AM
> User: N/A
> Computer: DTDPMS
> Description:
> Error: 605, Severity: 21, State: 1
> Attempt to fetch logical page (1:98036) in database 'CERES' belongs to
> object 'PatientAlerts', not to object 'chargepostingprocs'.
> Data:
> 0000: 5d 02 00 00 15 00 00 00 ]......
> 0008: 07 00 00 00 44 00 54 00 ...D.T.
> 0010: 44 00 50 00 4d 00 53 00 D.P.M.S.
> 0018: 00 00 06 00 00 00 43 00 .....C.
> 0020: 45 00 52 00 45 00 53 00 E.R.E.S.
> 0028: 00 00 ..
> can u help me.
> What is the reason for this message?
> How can I resolve this?
> Thanks,
> Soura
>
|||The first thing should be to check the db integrity using "dbcc checkdb".
AMB
"SouRa" wrote:
> Hi,
> I found error in the SERVER(subscriber in merge replication) windows event
> viewer the error is regarding a particular database(out of 15).
>
> Event Type: Error
> Event Source: MSSQLSERVER
> Event Category: (2)
> Event ID: 17052
> Date: 6/23/2005
> Time: 12:32:26 AM
> User: N/A
> Computer: DTDPMS
> Description:
> Error: 605, Severity: 21, State: 1
> Attempt to fetch logical page (1:98036) in database 'CERES' belongs to
> object 'PatientAlerts', not to object 'chargepostingprocs'.
> Data:
> 0000: 5d 02 00 00 15 00 00 00 ]......
> 0008: 07 00 00 00 44 00 54 00 ...D.T.
> 0010: 44 00 50 00 4d 00 53 00 D.P.M.S.
> 0018: 00 00 06 00 00 00 43 00 .....C.
> 0020: 45 00 52 00 45 00 53 00 E.R.E.S.
> 0028: 00 00 ..
> can u help me.
> What is the reason for this message?
> How can I resolve this?
> Thanks,
> Soura
>
|||http://www.karaszi.com/SQLServer/inf...suspect_db.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"SouRa" <SouRa@.discussions.microsoft.com> wrote in message
news:3A2EC9C8-06D3-4BC7-85BF-22A732A35B6C@.microsoft.com...
> Hi,
> I found error in the SERVER(subscriber in merge replication) windows event
> viewer the error is regarding a particular database(out of 15).
>
> Event Type: Error
> Event Source: MSSQLSERVER
> Event Category: (2)
> Event ID: 17052
> Date: 6/23/2005
> Time: 12:32:26 AM
> User: N/A
> Computer: DTDPMS
> Description:
> Error: 605, Severity: 21, State: 1
> Attempt to fetch logical page (1:98036) in database 'CERES' belongs to
> object 'PatientAlerts', not to object 'chargepostingprocs'.
> Data:
> 0000: 5d 02 00 00 15 00 00 00 ]......
> 0008: 07 00 00 00 44 00 54 00 ...D.T.
> 0010: 44 00 50 00 4d 00 53 00 D.P.M.S.
> 0018: 00 00 06 00 00 00 43 00 .....C.
> 0020: 45 00 52 00 45 00 53 00 E.R.E.S.
> 0028: 00 00 ..
> can u help me.
> What is the reason for this message?
> How can I resolve this?
> Thanks,
> Soura
>
I found error in the SERVER(subscriber in merge replication) windows event
viewer the error is regarding a particular database(out of 15).
Event Type: Error
Event Source: MSSQLSERVER
Event Category: (2)
Event ID: 17052
Date: 6/23/2005
Time: 12:32:26 AM
User: N/A
Computer: DTDPMS
Description:
Error: 605, Severity: 21, State: 1
Attempt to fetch logical page (1:98036) in database 'CERES' belongs to
object 'PatientAlerts', not to object 'chargepostingprocs'.
Data:
0000: 5d 02 00 00 15 00 00 00 ]......
0008: 07 00 00 00 44 00 54 00 ...D.T.
0010: 44 00 50 00 4d 00 53 00 D.P.M.S.
0018: 00 00 06 00 00 00 43 00 .....C.
0020: 45 00 52 00 45 00 53 00 E.R.E.S.
0028: 00 00 ..
can u help me.
What is the reason for this message?
How can I resolve this?
Thanks,
Soura
http://www.mssqlcity.com/FAQ/Trouble/er605.htm
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
"SouRa" <SouRa@.discussions.microsoft.com> schrieb im Newsbeitrag
news:3A2EC9C8-06D3-4BC7-85BF-22A732A35B6C@.microsoft.com...
> Hi,
> I found error in the SERVER(subscriber in merge replication) windows event
> viewer the error is regarding a particular database(out of 15).
>
> Event Type: Error
> Event Source: MSSQLSERVER
> Event Category: (2)
> Event ID: 17052
> Date: 6/23/2005
> Time: 12:32:26 AM
> User: N/A
> Computer: DTDPMS
> Description:
> Error: 605, Severity: 21, State: 1
> Attempt to fetch logical page (1:98036) in database 'CERES' belongs to
> object 'PatientAlerts', not to object 'chargepostingprocs'.
> Data:
> 0000: 5d 02 00 00 15 00 00 00 ]......
> 0008: 07 00 00 00 44 00 54 00 ...D.T.
> 0010: 44 00 50 00 4d 00 53 00 D.P.M.S.
> 0018: 00 00 06 00 00 00 43 00 .....C.
> 0020: 45 00 52 00 45 00 53 00 E.R.E.S.
> 0028: 00 00 ..
> can u help me.
> What is the reason for this message?
> How can I resolve this?
> Thanks,
> Soura
>
|||The first thing should be to check the db integrity using "dbcc checkdb".
AMB
"SouRa" wrote:
> Hi,
> I found error in the SERVER(subscriber in merge replication) windows event
> viewer the error is regarding a particular database(out of 15).
>
> Event Type: Error
> Event Source: MSSQLSERVER
> Event Category: (2)
> Event ID: 17052
> Date: 6/23/2005
> Time: 12:32:26 AM
> User: N/A
> Computer: DTDPMS
> Description:
> Error: 605, Severity: 21, State: 1
> Attempt to fetch logical page (1:98036) in database 'CERES' belongs to
> object 'PatientAlerts', not to object 'chargepostingprocs'.
> Data:
> 0000: 5d 02 00 00 15 00 00 00 ]......
> 0008: 07 00 00 00 44 00 54 00 ...D.T.
> 0010: 44 00 50 00 4d 00 53 00 D.P.M.S.
> 0018: 00 00 06 00 00 00 43 00 .....C.
> 0020: 45 00 52 00 45 00 53 00 E.R.E.S.
> 0028: 00 00 ..
> can u help me.
> What is the reason for this message?
> How can I resolve this?
> Thanks,
> Soura
>
|||http://www.karaszi.com/SQLServer/inf...suspect_db.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"SouRa" <SouRa@.discussions.microsoft.com> wrote in message
news:3A2EC9C8-06D3-4BC7-85BF-22A732A35B6C@.microsoft.com...
> Hi,
> I found error in the SERVER(subscriber in merge replication) windows event
> viewer the error is regarding a particular database(out of 15).
>
> Event Type: Error
> Event Source: MSSQLSERVER
> Event Category: (2)
> Event ID: 17052
> Date: 6/23/2005
> Time: 12:32:26 AM
> User: N/A
> Computer: DTDPMS
> Description:
> Error: 605, Severity: 21, State: 1
> Attempt to fetch logical page (1:98036) in database 'CERES' belongs to
> object 'PatientAlerts', not to object 'chargepostingprocs'.
> Data:
> 0000: 5d 02 00 00 15 00 00 00 ]......
> 0008: 07 00 00 00 44 00 54 00 ...D.T.
> 0010: 44 00 50 00 4d 00 53 00 D.P.M.S.
> 0018: 00 00 06 00 00 00 43 00 .....C.
> 0020: 45 00 52 00 45 00 53 00 E.R.E.S.
> 0028: 00 00 ..
> can u help me.
> What is the reason for this message?
> How can I resolve this?
> Thanks,
> Soura
>
Subscribe to:
Posts (Atom)