Hello,
So far, I've been programming distributed multiuser applications using MSDE
as my choice of db.
I got another project that requires client (local) application.
Which database would you suggest?
I don't want to use MSDE as I'm having fear about it running as service,
they might disable it + it will put additional cpu load on client.
Is Access or plain XML solution to my problem ?
Of course, I'm trying to stay as cheap as possible, if not free.
Thank you
Vlado
Vlado,
Jet might work depending on the number of users and the size.
HTH
Jerry
"Vlado Jasovic (excelleinc.com)" <vjasovicATexcelleincDOTcom> wrote in
message news:OkTNX0n1FHA.612@.TK2MSFTNGP10.phx.gbl...
> Hello,
> So far, I've been programming distributed multiuser applications using
> MSDE as my choice of db.
> I got another project that requires client (local) application.
> Which database would you suggest?
> I don't want to use MSDE as I'm having fear about it running as service,
> they might disable it + it will put additional cpu load on client.
> Is Access or plain XML solution to my problem ?
> Of course, I'm trying to stay as cheap as possible, if not free.
>
> Thank you
> Vlado
>
Showing posts with label ive. Show all posts
Showing posts with label ive. Show all posts
Monday, March 19, 2012
Tuesday, February 14, 2012
CHECKDB finds consistency errors in table 'sysdepends'
I've tried to follow any kind of tips for the solution og this problem, but
I cannot use the repair tools because of the system table "sysdepends".
What can I do? The regular integrity check, database and transaction log
backups fail every single day!
The error, according to CHECKDB is:
"CHECKDB found 0 allocation errors and 1 consistency errors in table
'sysdepends' (object ID 12)."
(SQL 2000 SP3)
Any suggestions?
/Angelo
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/
"Angelo Brusati" <angelo@.intrasuite.net> wrote in message
news:unfjPEWBGHA.4076@.TK2MSFTNGP14.phx.gbl...
> I've tried to follow any kind of tips for the solution og this problem, but
> I cannot use the repair tools because of the system table "sysdepends".
> What can I do? The regular integrity check, database and transaction log
> backups fail every single day!
> The error, according to CHECKDB is:
> "CHECKDB found 0 allocation errors and 1 consistency errors in table
> 'sysdepends' (object ID 12)."
> (SQL 2000 SP3)
> Any suggestions?
>
> /Angelo
>
>
|||Tibor, thanks for your answer.
But has the article of your link something to do with my problem?
The database is not suspect and the hardware is OK, as well as the disks.
/Angelo
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:eja3qWZBGHA.272@.TK2MSFTNGP09.phx.gbl...
> 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/
>
> "Angelo Brusati" <angelo@.intrasuite.net> wrote in message
> news:unfjPEWBGHA.4076@.TK2MSFTNGP14.phx.gbl...
>
|||The DBCC message states that you have a corruption in your database. So the database isn't suspect,
but you still have a corruption in the database.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Angelo Brusati" <angelo@.intrasuite.net> wrote in message
news:%23u%231PugBGHA.3984@.TK2MSFTNGP14.phx.gbl...
> Tibor, thanks for your answer.
> But has the article of your link something to do with my problem?
> The database is not suspect and the hardware is OK, as well as the disks.
> /Angelo
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in message
> news:eja3qWZBGHA.272@.TK2MSFTNGP09.phx.gbl...
>
I cannot use the repair tools because of the system table "sysdepends".
What can I do? The regular integrity check, database and transaction log
backups fail every single day!
The error, according to CHECKDB is:
"CHECKDB found 0 allocation errors and 1 consistency errors in table
'sysdepends' (object ID 12)."
(SQL 2000 SP3)
Any suggestions?
/Angelo
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/
"Angelo Brusati" <angelo@.intrasuite.net> wrote in message
news:unfjPEWBGHA.4076@.TK2MSFTNGP14.phx.gbl...
> I've tried to follow any kind of tips for the solution og this problem, but
> I cannot use the repair tools because of the system table "sysdepends".
> What can I do? The regular integrity check, database and transaction log
> backups fail every single day!
> The error, according to CHECKDB is:
> "CHECKDB found 0 allocation errors and 1 consistency errors in table
> 'sysdepends' (object ID 12)."
> (SQL 2000 SP3)
> Any suggestions?
>
> /Angelo
>
>
|||Tibor, thanks for your answer.
But has the article of your link something to do with my problem?
The database is not suspect and the hardware is OK, as well as the disks.
/Angelo
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:eja3qWZBGHA.272@.TK2MSFTNGP09.phx.gbl...
> 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/
>
> "Angelo Brusati" <angelo@.intrasuite.net> wrote in message
> news:unfjPEWBGHA.4076@.TK2MSFTNGP14.phx.gbl...
>
|||The DBCC message states that you have a corruption in your database. So the database isn't suspect,
but you still have a corruption in the database.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Angelo Brusati" <angelo@.intrasuite.net> wrote in message
news:%23u%231PugBGHA.3984@.TK2MSFTNGP14.phx.gbl...
> Tibor, thanks for your answer.
> But has the article of your link something to do with my problem?
> The database is not suspect and the hardware is OK, as well as the disks.
> /Angelo
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in message
> news:eja3qWZBGHA.272@.TK2MSFTNGP09.phx.gbl...
>
CHECKDB allocation error
Hello all,
I've got this error as result of CHECKDB command:
CHECKDB found 1 allocation errors and 4 consistency errors in database
'Data'.
repair_allow_data_loss is the minimum repair level for the errors found by
DBCC CHECKDB (Data ).
It looks like the CHECKDB with repair_allow_data_loss can solve the problem.
Is there any way to know beforehand, what data will be lost?
Thanks,
peti
Hi Peti
It would be useful to see the exact errors, but you may want to look at DBCC
PAGE, googling for "DBCC CHECKDB" AND "DBCC PAGE" comes up with quite a few
results including http://tinyurl.com/y9rk25 and http://tinyurl.com/yjabup
Reading "Inside SQL Server 2000" by Kalen Delany ISBN 0-7356-0998-5 and "The
Guru's Guide to Transact-SQL" by Ken Henderson ISBN 0-201-61576-2 will give
you useful information on these as well.
John
"peti" wrote:
> Hello all,
> I've got this error as result of CHECKDB command:
> CHECKDB found 1 allocation errors and 4 consistency errors in database
> 'Data'.
> repair_allow_data_loss is the minimum repair level for the errors found by
> DBCC CHECKDB (Data ).
> It looks like the CHECKDB with repair_allow_data_loss can solve the problem.
> Is there any way to know beforehand, what data will be lost?
> Thanks,
> peti
>
>
|||Thank you John,
I've read those posts but I'm still confused - for the error 8981, if the
dbbcc checkdb REPAIR_ALLOW_DATA_LOSS works fine, how can I find what data is
missing?
DBCC CHECKDB outcome:
DBCC results for 'conflict_edu_Script_tab'.
Server: Msg 8979, Level 16, State 1, Line 1
Table error: Object ID 772614241, index ID 1. Page (1:482455) is missing
references from parent (unknown) and previous (page (1:482777)) nodes.
Possible bad root entry in sysindexes.
There are 0 rows in 0 pages for object 'conflict_edu_Script_tab'.
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=53072
...................
DBCC results for 'cse_CaseFolder_tab'.
Server: Msg 8981, Level 16, State 1, Line 1
Table error: Object ID 772614241, index ID 1. The next pointer of (1:482455)
refers to page (1:482776). Neither (1:482776) nor its parent were
encountered. Possible bad chain linkage.
Server: Msg 8981, Level 16, State 1, Line 1
Table error: Object ID 772614241, index ID 1. The next pointer of (1:493336)
refers to page (1:482778). Neither (1:482778) nor its parent were
encountered. Possible bad chain linkage.
There are 4622077 rows in 91565 pages for object 'cse_CaseFolder_tab'.
CHECKDB found 0 allocation errors and 3 consistency errors in table
'cse_Case_tab' (object ID 772614241).
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=63537
...........
There are 29 rows in 1 pages for object 'cse_Note_tab'.
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'DB', index 'cse_Case_tab.cse_Case_ind7' (ID
1520633106) (index ID 7). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:24702:1) with values (CTId = 10 and ToCTA = NULL and CCId = 1
and CFId = 1049716 and CaseId = 1) points to the data row identified by ().
http://msdn.microsoft.com/library/de...err_2_6f7a.asp
http://msdn.microsoft.com/library/de...err_2_6f76.asp
/peti
"peti" <bpetigaspar@.gmail.com> wrote in message
news:eh59ee$j2v$3@.news.al.sw.ericsson.se...
> Hello all,
> I've got this error as result of CHECKDB command:
> CHECKDB found 1 allocation errors and 4 consistency errors in database
> 'Data'.
> repair_allow_data_loss is the minimum repair level for the errors found by
> DBCC CHECKDB (Data ).
> It looks like the CHECKDB with repair_allow_data_loss can solve the
problem.
> Is there any way to know beforehand, what data will be lost?
> Thanks,
> peti
>
|||Hi Peti
If there are a large number of errors the most likely cause would be a
hardware fault you would first need to eliminate what caused it before trying
to repair the database. You can always drop and re-create indexes to try and
remove any inconsistencies, what does the NOINDEX option for CHECKDB return?
John
"peti" wrote:
> Thank you John,
> I've read those posts but I'm still confused - for the error 8981, if the
> dbbcc checkdb REPAIR_ALLOW_DATA_LOSS works fine, how can I find what data is
> missing?
> DBCC CHECKDB outcome:
>
> DBCC results for 'conflict_edu_Script_tab'.
> Server: Msg 8979, Level 16, State 1, Line 1
> Table error: Object ID 772614241, index ID 1. Page (1:482455) is missing
> references from parent (unknown) and previous (page (1:482777)) nodes.
> Possible bad root entry in sysindexes.
> There are 0 rows in 0 pages for object 'conflict_edu_Script_tab'.
> http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=53072
> ...................
> DBCC results for 'cse_CaseFolder_tab'.
> Server: Msg 8981, Level 16, State 1, Line 1
> Table error: Object ID 772614241, index ID 1. The next pointer of (1:482455)
> refers to page (1:482776). Neither (1:482776) nor its parent were
> encountered. Possible bad chain linkage.
> Server: Msg 8981, Level 16, State 1, Line 1
> Table error: Object ID 772614241, index ID 1. The next pointer of (1:493336)
> refers to page (1:482778). Neither (1:482778) nor its parent were
> encountered. Possible bad chain linkage.
> There are 4622077 rows in 91565 pages for object 'cse_CaseFolder_tab'.
> CHECKDB found 0 allocation errors and 3 consistency errors in table
> 'cse_Case_tab' (object ID 772614241).
> http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=63537
> ...........
> There are 29 rows in 1 pages for object 'cse_Note_tab'.
> Server: Msg 8952, Level 16, State 1, Line 1
> Table error: Database 'DB', index 'cse_Case_tab.cse_Case_ind7' (ID
> 1520633106) (index ID 7). Extra or invalid key for the keys:
> Server: Msg 8956, Level 16, State 1, Line 1
> Index row (1:24702:1) with values (CTId = 10 and ToCTA = NULL and CCId = 1
> and CFId = 1049716 and CaseId = 1) points to the data row identified by ().
>
> http://msdn.microsoft.com/library/de...err_2_6f7a.asp
> http://msdn.microsoft.com/library/de...err_2_6f76.asp
> /peti
>
>
> "peti" <bpetigaspar@.gmail.com> wrote in message
> news:eh59ee$j2v$3@.news.al.sw.ericsson.se...
> problem.
>
>
|||It was a power failure.
In my case the clustered index is corupt (Object ID 772614241, index ID 1).
Does it mean data loss?
What means data loss - only one row or the entire table?
/peti
"peti" <bpetigaspar@.gmail.com> wrote in message
news:eh5qb1$s3r$1@.news.al.sw.ericsson.se...
> Thank you John,
> I've read those posts but I'm still confused - for the error 8981, if the
> dbbcc checkdb REPAIR_ALLOW_DATA_LOSS works fine, how can I find what data
is
> missing?
> DBCC CHECKDB outcome:
>
> DBCC results for 'conflict_edu_Script_tab'.
> Server: Msg 8979, Level 16, State 1, Line 1
> Table error: Object ID 772614241, index ID 1. Page (1:482455) is missing
> references from parent (unknown) and previous (page (1:482777)) nodes.
> Possible bad root entry in sysindexes.
> There are 0 rows in 0 pages for object 'conflict_edu_Script_tab'.
> http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=53072
> ...................
> DBCC results for 'cse_CaseFolder_tab'.
> Server: Msg 8981, Level 16, State 1, Line 1
> Table error: Object ID 772614241, index ID 1. The next pointer of
(1:482455)
> refers to page (1:482776). Neither (1:482776) nor its parent were
> encountered. Possible bad chain linkage.
> Server: Msg 8981, Level 16, State 1, Line 1
> Table error: Object ID 772614241, index ID 1. The next pointer of
(1:493336)
> refers to page (1:482778). Neither (1:482778) nor its parent were
> encountered. Possible bad chain linkage.
> There are 4622077 rows in 91565 pages for object 'cse_CaseFolder_tab'.
> CHECKDB found 0 allocation errors and 3 consistency errors in table
> 'cse_Case_tab' (object ID 772614241).
> http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=63537
> ..........
> There are 29 rows in 1 pages for object 'cse_Note_tab'.
> Server: Msg 8952, Level 16, State 1, Line 1
> Table error: Database 'DB', index 'cse_Case_tab.cse_Case_ind7' (ID
> 1520633106) (index ID 7). Extra or invalid key for the keys:
> Server: Msg 8956, Level 16, State 1, Line 1
> Index row (1:24702:1) with values (CTId = 10 and ToCTA = NULL and CCId = 1
> and CFId = 1049716 and CaseId = 1) points to the data row identified by
().
>
>
http://msdn.microsoft.com/library/de...err_2_6f7a.asp
>
http://msdn.microsoft.com/library/de...err_2_6f76.asp[vbcol=seagreen]
> /peti
>
>
> "peti" <bpetigaspar@.gmail.com> wrote in message
> news:eh59ee$j2v$3@.news.al.sw.ericsson.se...
by
> problem.
>
|||Hi
The index page is missing it's parent reference it does not necessarily mean
that it contains data. Examples of the syntax and using DBCC PAGE can be
found at http://www.sql-server-performance.com/dbcc_commands.asp and
http://www.sql-server-performance.co...tructures.asp. I assume
that you are persuing this route because you don't have a good backup that
you can roll forward? make sure you backup before correcting the database,
and you may want to compare what you have against the last good backup you
have with something like SQL Data Compare from Red Gate www.red-gate.com, or
compare the pre-repared database to the post-repaired database (which may
only confirm that you have already lost the data!).
John
"peti" wrote:
> It was a power failure.
> In my case the clustered index is corupt (Object ID 772614241, index ID 1).
> Does it mean data loss?
> What means data loss - only one row or the entire table?
> /peti
> "peti" <bpetigaspar@.gmail.com> wrote in message
> news:eh5qb1$s3r$1@.news.al.sw.ericsson.se...
> is
> (1:482455)
> (1:493336)
> ().
> http://msdn.microsoft.com/library/de...err_2_6f7a.asp
> http://msdn.microsoft.com/library/de...err_2_6f76.asp
> by
>
>
I've got this error as result of CHECKDB command:
CHECKDB found 1 allocation errors and 4 consistency errors in database
'Data'.
repair_allow_data_loss is the minimum repair level for the errors found by
DBCC CHECKDB (Data ).
It looks like the CHECKDB with repair_allow_data_loss can solve the problem.
Is there any way to know beforehand, what data will be lost?
Thanks,
peti
Hi Peti
It would be useful to see the exact errors, but you may want to look at DBCC
PAGE, googling for "DBCC CHECKDB" AND "DBCC PAGE" comes up with quite a few
results including http://tinyurl.com/y9rk25 and http://tinyurl.com/yjabup
Reading "Inside SQL Server 2000" by Kalen Delany ISBN 0-7356-0998-5 and "The
Guru's Guide to Transact-SQL" by Ken Henderson ISBN 0-201-61576-2 will give
you useful information on these as well.
John
"peti" wrote:
> Hello all,
> I've got this error as result of CHECKDB command:
> CHECKDB found 1 allocation errors and 4 consistency errors in database
> 'Data'.
> repair_allow_data_loss is the minimum repair level for the errors found by
> DBCC CHECKDB (Data ).
> It looks like the CHECKDB with repair_allow_data_loss can solve the problem.
> Is there any way to know beforehand, what data will be lost?
> Thanks,
> peti
>
>
|||Thank you John,
I've read those posts but I'm still confused - for the error 8981, if the
dbbcc checkdb REPAIR_ALLOW_DATA_LOSS works fine, how can I find what data is
missing?
DBCC CHECKDB outcome:
DBCC results for 'conflict_edu_Script_tab'.
Server: Msg 8979, Level 16, State 1, Line 1
Table error: Object ID 772614241, index ID 1. Page (1:482455) is missing
references from parent (unknown) and previous (page (1:482777)) nodes.
Possible bad root entry in sysindexes.
There are 0 rows in 0 pages for object 'conflict_edu_Script_tab'.
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=53072
...................
DBCC results for 'cse_CaseFolder_tab'.
Server: Msg 8981, Level 16, State 1, Line 1
Table error: Object ID 772614241, index ID 1. The next pointer of (1:482455)
refers to page (1:482776). Neither (1:482776) nor its parent were
encountered. Possible bad chain linkage.
Server: Msg 8981, Level 16, State 1, Line 1
Table error: Object ID 772614241, index ID 1. The next pointer of (1:493336)
refers to page (1:482778). Neither (1:482778) nor its parent were
encountered. Possible bad chain linkage.
There are 4622077 rows in 91565 pages for object 'cse_CaseFolder_tab'.
CHECKDB found 0 allocation errors and 3 consistency errors in table
'cse_Case_tab' (object ID 772614241).
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=63537
...........
There are 29 rows in 1 pages for object 'cse_Note_tab'.
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'DB', index 'cse_Case_tab.cse_Case_ind7' (ID
1520633106) (index ID 7). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:24702:1) with values (CTId = 10 and ToCTA = NULL and CCId = 1
and CFId = 1049716 and CaseId = 1) points to the data row identified by ().
http://msdn.microsoft.com/library/de...err_2_6f7a.asp
http://msdn.microsoft.com/library/de...err_2_6f76.asp
/peti
"peti" <bpetigaspar@.gmail.com> wrote in message
news:eh59ee$j2v$3@.news.al.sw.ericsson.se...
> Hello all,
> I've got this error as result of CHECKDB command:
> CHECKDB found 1 allocation errors and 4 consistency errors in database
> 'Data'.
> repair_allow_data_loss is the minimum repair level for the errors found by
> DBCC CHECKDB (Data ).
> It looks like the CHECKDB with repair_allow_data_loss can solve the
problem.
> Is there any way to know beforehand, what data will be lost?
> Thanks,
> peti
>
|||Hi Peti
If there are a large number of errors the most likely cause would be a
hardware fault you would first need to eliminate what caused it before trying
to repair the database. You can always drop and re-create indexes to try and
remove any inconsistencies, what does the NOINDEX option for CHECKDB return?
John
"peti" wrote:
> Thank you John,
> I've read those posts but I'm still confused - for the error 8981, if the
> dbbcc checkdb REPAIR_ALLOW_DATA_LOSS works fine, how can I find what data is
> missing?
> DBCC CHECKDB outcome:
>
> DBCC results for 'conflict_edu_Script_tab'.
> Server: Msg 8979, Level 16, State 1, Line 1
> Table error: Object ID 772614241, index ID 1. Page (1:482455) is missing
> references from parent (unknown) and previous (page (1:482777)) nodes.
> Possible bad root entry in sysindexes.
> There are 0 rows in 0 pages for object 'conflict_edu_Script_tab'.
> http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=53072
> ...................
> DBCC results for 'cse_CaseFolder_tab'.
> Server: Msg 8981, Level 16, State 1, Line 1
> Table error: Object ID 772614241, index ID 1. The next pointer of (1:482455)
> refers to page (1:482776). Neither (1:482776) nor its parent were
> encountered. Possible bad chain linkage.
> Server: Msg 8981, Level 16, State 1, Line 1
> Table error: Object ID 772614241, index ID 1. The next pointer of (1:493336)
> refers to page (1:482778). Neither (1:482778) nor its parent were
> encountered. Possible bad chain linkage.
> There are 4622077 rows in 91565 pages for object 'cse_CaseFolder_tab'.
> CHECKDB found 0 allocation errors and 3 consistency errors in table
> 'cse_Case_tab' (object ID 772614241).
> http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=63537
> ...........
> There are 29 rows in 1 pages for object 'cse_Note_tab'.
> Server: Msg 8952, Level 16, State 1, Line 1
> Table error: Database 'DB', index 'cse_Case_tab.cse_Case_ind7' (ID
> 1520633106) (index ID 7). Extra or invalid key for the keys:
> Server: Msg 8956, Level 16, State 1, Line 1
> Index row (1:24702:1) with values (CTId = 10 and ToCTA = NULL and CCId = 1
> and CFId = 1049716 and CaseId = 1) points to the data row identified by ().
>
> http://msdn.microsoft.com/library/de...err_2_6f7a.asp
> http://msdn.microsoft.com/library/de...err_2_6f76.asp
> /peti
>
>
> "peti" <bpetigaspar@.gmail.com> wrote in message
> news:eh59ee$j2v$3@.news.al.sw.ericsson.se...
> problem.
>
>
|||It was a power failure.
In my case the clustered index is corupt (Object ID 772614241, index ID 1).
Does it mean data loss?
What means data loss - only one row or the entire table?
/peti
"peti" <bpetigaspar@.gmail.com> wrote in message
news:eh5qb1$s3r$1@.news.al.sw.ericsson.se...
> Thank you John,
> I've read those posts but I'm still confused - for the error 8981, if the
> dbbcc checkdb REPAIR_ALLOW_DATA_LOSS works fine, how can I find what data
is
> missing?
> DBCC CHECKDB outcome:
>
> DBCC results for 'conflict_edu_Script_tab'.
> Server: Msg 8979, Level 16, State 1, Line 1
> Table error: Object ID 772614241, index ID 1. Page (1:482455) is missing
> references from parent (unknown) and previous (page (1:482777)) nodes.
> Possible bad root entry in sysindexes.
> There are 0 rows in 0 pages for object 'conflict_edu_Script_tab'.
> http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=53072
> ...................
> DBCC results for 'cse_CaseFolder_tab'.
> Server: Msg 8981, Level 16, State 1, Line 1
> Table error: Object ID 772614241, index ID 1. The next pointer of
(1:482455)
> refers to page (1:482776). Neither (1:482776) nor its parent were
> encountered. Possible bad chain linkage.
> Server: Msg 8981, Level 16, State 1, Line 1
> Table error: Object ID 772614241, index ID 1. The next pointer of
(1:493336)
> refers to page (1:482778). Neither (1:482778) nor its parent were
> encountered. Possible bad chain linkage.
> There are 4622077 rows in 91565 pages for object 'cse_CaseFolder_tab'.
> CHECKDB found 0 allocation errors and 3 consistency errors in table
> 'cse_Case_tab' (object ID 772614241).
> http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=63537
> ..........
> There are 29 rows in 1 pages for object 'cse_Note_tab'.
> Server: Msg 8952, Level 16, State 1, Line 1
> Table error: Database 'DB', index 'cse_Case_tab.cse_Case_ind7' (ID
> 1520633106) (index ID 7). Extra or invalid key for the keys:
> Server: Msg 8956, Level 16, State 1, Line 1
> Index row (1:24702:1) with values (CTId = 10 and ToCTA = NULL and CCId = 1
> and CFId = 1049716 and CaseId = 1) points to the data row identified by
().
>
>
http://msdn.microsoft.com/library/de...err_2_6f7a.asp
>
http://msdn.microsoft.com/library/de...err_2_6f76.asp[vbcol=seagreen]
> /peti
>
>
> "peti" <bpetigaspar@.gmail.com> wrote in message
> news:eh59ee$j2v$3@.news.al.sw.ericsson.se...
by
> problem.
>
|||Hi
The index page is missing it's parent reference it does not necessarily mean
that it contains data. Examples of the syntax and using DBCC PAGE can be
found at http://www.sql-server-performance.com/dbcc_commands.asp and
http://www.sql-server-performance.co...tructures.asp. I assume
that you are persuing this route because you don't have a good backup that
you can roll forward? make sure you backup before correcting the database,
and you may want to compare what you have against the last good backup you
have with something like SQL Data Compare from Red Gate www.red-gate.com, or
compare the pre-repared database to the post-repaired database (which may
only confirm that you have already lost the data!).
John
"peti" wrote:
> It was a power failure.
> In my case the clustered index is corupt (Object ID 772614241, index ID 1).
> Does it mean data loss?
> What means data loss - only one row or the entire table?
> /peti
> "peti" <bpetigaspar@.gmail.com> wrote in message
> news:eh5qb1$s3r$1@.news.al.sw.ericsson.se...
> is
> (1:482455)
> (1:493336)
> ().
> http://msdn.microsoft.com/library/de...err_2_6f7a.asp
> http://msdn.microsoft.com/library/de...err_2_6f76.asp
> by
>
>
Subscribe to:
Posts (Atom)