Monday, March 19, 2012

Error 7105

I have a vb program and database in sql server. the program run fine all the
while but today start i always hit 1 error when i do update. the error is
"Fatal Error 7105"... i have search in microsoft site and their explanation
is "Page %S_PGID, slot %d for text, ntext, or image node does not exist."
I suspect this is a message from sql server. i check the sql server, looks
like ok... then i try to shrink the database. Error 7105 come out again when
half shrink the database. the error message is "Error 7105: Page(1:136654),
slot 6 fot text, ntext, or image node does not exist."
so, i try to run DDBC CHECKDB ('MyDB', Repair_Fast). Then i got this error
message : "Server: Msg 7995, Level 16, State 1, Line 1
Database 'WEBLOS' consistency errors in sysobjects, sysindexes, syscolumns,
or systypes prevent further CHECKDB processing.
DBCC execution completed. If DBCC printed error messages, contact your
system administrator."
i really don't understant what is these error means. can somebody help me on
this?
thanx... thanx... thanx...
Hi
Seems to me that your data is corrupted. Do you have a last backup of the
database?
"wlho" <wlho@.discussions.microsoft.com> wrote in message
news:B84748D9-7ABA-4346-BB5F-1278A72B77A8@.microsoft.com...
> I have a vb program and database in sql server. the program run fine all
the
> while but today start i always hit 1 error when i do update. the error is
> "Fatal Error 7105"... i have search in microsoft site and their
explanation
> is "Page %S_PGID, slot %d for text, ntext, or image node does not exist."
> I suspect this is a message from sql server. i check the sql server, looks
> like ok... then i try to shrink the database. Error 7105 come out again
when
> half shrink the database. the error message is "Error 7105:
Page(1:136654),
> slot 6 fot text, ntext, or image node does not exist."
> so, i try to run DDBC CHECKDB ('MyDB', Repair_Fast). Then i got this error
> message : "Server: Msg 7995, Level 16, State 1, Line 1
> Database 'WEBLOS' consistency errors in sysobjects, sysindexes,
syscolumns,
> or systypes prevent further CHECKDB processing.
> DBCC execution completed. If DBCC printed error messages, contact your
> system administrator."
> i really don't understant what is these error means. can somebody help me
on
> this?
> thanx... thanx... thanx...
|||because this is the development server, we didn't do backup for it. is there
any way to fix this problem?
"Uri Dimant" wrote:

> Hi
> Seems to me that your data is corrupted. Do you have a last backup of the
> database?
>
> "wlho" <wlho@.discussions.microsoft.com> wrote in message
> news:B84748D9-7ABA-4346-BB5F-1278A72B77A8@.microsoft.com...
> the
> explanation
> when
> Page(1:136654),
> syscolumns,
> on
>
>

No comments:

Post a Comment