SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 Data Corruption Issues
 db error: Server: Msg 2511, Level 16, State 1, Lin
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

greegy08
Starting Member

Philippines
19 Posts

Posted - 07/15/2009 :  20:48:46  Show Profile  Reply with Quote
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








Edited by - greegy08 on 07/15/2009 21:59:24

russell
Pyro-ma-ni-yak

USA
5071 Posts

Posted - 07/15/2009 :  23:28:06  Show Profile  Visit russell's Homepage  Reply with Quote
'098' not 098
Go to Top of Page

greegy08
Starting Member

Philippines
19 Posts

Posted - 07/16/2009 :  00:01:59  Show Profile  Reply with Quote
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

Edited by - greegy08 on 07/16/2009 00:12:26
Go to Top of Page

russell
Pyro-ma-ni-yak

USA
5071 Posts

Posted - 07/16/2009 :  03:08:53  Show Profile  Visit russell's Homepage  Reply with Quote
should be ok. what version SQL Server are you using?
Go to Top of Page

greegy08
Starting Member

Philippines
19 Posts

Posted - 07/16/2009 :  23:49:00  Show Profile  Reply with Quote
I am using SQl Server 2000, sp3



greegy08
SQLnoob
Go to Top of Page

russell
Pyro-ma-ni-yak

USA
5071 Posts

Posted - 07/17/2009 :  00:20:22  Show Profile  Visit russell's Homepage  Reply with Quote
I'll make another backup 1st, then run it.
Go to Top of Page

greegy08
Starting Member

Philippines
19 Posts

Posted - 07/17/2009 :  02:17:01  Show Profile  Reply with Quote
ok I will wait for your response.
Go to Top of Page

russell
Pyro-ma-ni-yak

USA
5071 Posts

Posted - 07/17/2009 :  12:19:15  Show Profile  Visit russell's Homepage  Reply with Quote
i mean you should make a backup. not me lol. then go ahead and let it fly
Go to Top of Page

greegy08
Starting Member

Philippines
19 Posts

Posted - 08/19/2009 :  04:39:05  Show Profile  Reply with Quote
:bz
Go to Top of Page

jasonliambert
Starting Member

1 Posts

Posted - 08/31/2012 :  03:36:28  Show Profile  Reply with Quote
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
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.14 seconds. Powered By: Snitz Forums 2000