db error: Server: Msg 2511, Level 16, State 1, Lin

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

Data Corruption Issues

db error: Server: Msg 2511, Level 16, State 1, Lin

Author

Topic

greegy08
Starting Member

19 Posts

Posted - 2009-07-15 : 20:48:46

hi good day,

I have a problem in my database.I don't know if i can recover it because all of my previous backup have the same error occurred.

I run:

DBCC CHECKTABLE ([SYSDEPENDS],REPAIR_REBUILD)

Error Msg:

Server: Msg 2594, Level 16, State 1, Line 1
Invalid index ID (0) specified.
Server: Msg 2511, Level 16, State 1, Line 1
Table error: Object ID 12, Index ID 0. Keys out of order on page (1:5867), slots 52 and 53.
DBCC results for 'sysdepends'.
Could not repair this error.
There are 18454 rows in 98 pages for object 'sysdepends'.
CHECKTABLE found 0 allocation errors and 1 consistency errors in table 'sysdepends' (object ID 12).
repair_rebuild is the minimum repair level for the errors found by DBCC CHECKTABLE (098.dbo.sysdepends repair_rebuild).

I refer this problem in this link but it seems i cant execute this script. So now, the problem still exist.

Forums link:
http://www.pcreview.co.uk/forums/thread-2298932.php

solution link:
http://support.microsoft.com/kb/106122/en-us

So I try to run this script sp_fixindex

original script:

sp_fixindex dbname, tablename, indid

My script:

sp_fixindex 098, sysdepends, 1

then I got this error: It cant execute in the database.

=
The database name provided '98' must be the current database when executing this stored procedure.

Any help is highly appreciated. I need to recover this database a lot.

greegy08
SQLnoob

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2009-07-15 : 23:28:06

'098' not 098

greegy08
Starting Member

19 Posts

Posted - 2009-07-16 : 00:01:59

OK THANKS russell, But anyone can tell me if this script can damage my database specially the system tables? any effect on this the sp_fixindex script?

greegy08
SQLnoob

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2009-07-16 : 03:08:53

should be ok. what version SQL Server are you using?

greegy08
Starting Member

19 Posts

Posted - 2009-07-16 : 23:49:00

I am using SQl Server 2000, sp3

greegy08
SQLnoob

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2009-07-17 : 00:20:22

I'll make another backup 1st, then run it.

greegy08
Starting Member

19 Posts

Posted - 2009-07-17 : 02:17:01

ok I will wait for your response.

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2009-07-17 : 12:19:15

i mean you should make a backup. not me lol. then go ahead and let it fly

greegy08
Starting Member

19 Posts

Posted - 2009-08-19 : 04:39:05

:bz

jasonliambert
Starting Member

1 Post

Posted - 2012-08-31 : 03:36:28

First, make a backup of the data. Then, run DBCC CHECKDB command without the use of repair clause.

After when you are done with all these, again run the same command mentioned above but this time it should accompany the repair clause within. This should help you...

If the problem still remain intact even after this, then chances of data deletion are always possible and that is why a backup is necessary for the same.

http://www.sqldatabase-recovery.com

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources