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
 Free SQL Database Tool Repair

Author  Topic 

carder
Starting Member

2 Posts

Posted - 2014-07-15 : 01:52:44
I have a problem with one of my SQL Server 2008 damaged database:

When I run DBCC checkdb (<my database name>)

DBCC CHECKDB Result:
Msg 8967, Level 16, State 218, Line 1
An internal error occurred in DBCC that prevented further processing. Contact Customer Support Services.
Msg 7985, Level 16, State 2, Line 1
System table pre-checks: Object ID 7. Could not read and latch page (1:3523) with latch type SH. Check statement terminated due to unrepairable error.
DBCC results for 'Mydatabase'.
Msg 8944, Level 16, State 12, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 458752 (type Unknown), page (1:3523), row 13. Test (ColumnOffsets <= (nextRec - pRec)) failed. Values are 43240 and 539.
CHECKDB found 0 allocation errors and 1 consistency errors not associated with any single object.
CHECKDB found 0 allocation errors and 1 consistency errors in database 'Mydatabase'.
repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (SboBettiniBAD).

I tried with dbcc checkdb with repair_allow_data_loss but I got same error.

Is there any free SQL repair tool that I can try to repair my corrupt database?

prett
Posting Yak Master

212 Posts

Posted - 2014-07-15 : 03:08:07
Just need to restore from clean & updated backup.
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2014-07-15 : 12:39:53
quote:
Originally posted by prett

Just need to restore from clean & updated backup.



I like the "just" included in that response.

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

carder
Starting Member

2 Posts

Posted - 2014-07-15 : 23:47:16
quote:
Originally posted by prett

Just need to restore from clean & updated backup.



Backup is very old.

I have tried some software but all are paid.They are offering free demo version only.
Go to Top of Page

prett
Posting Yak Master

212 Posts

Posted - 2014-07-16 : 07:05:04
quote:
Originally posted by carder

quote:
Originally posted by prett

Just need to restore from clean & updated backup.



Backup is very old.

I have tried some software but all are paid.They are offering free demo version only.



You can try Stellar Phoenix SQL database repair software. It is not a free software and you can't expect all good things to come free. You need to pay a bit for it.

http://www.stellarinfo.com/sql-recovery.htm[url][/url]
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2014-07-16 : 12:28:09
quote:
Originally posted by carder

quote:
Originally posted by prett

Just need to restore from clean & updated backup.



Backup is very old.

I have tried some software but all are paid.They are offering free demo version only.



Why is the backup old? If this database is so important, then why aren't there backups? I just don't understand this mentality. This is the 3rd or so thread this week like this. Backups are number one priority.

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

Shanky
Yak Posting Veteran

84 Posts

Posted - 2014-07-21 : 04:55:56
quote:
Originally posted by carder

quote:
Originally posted by prett

Just need to restore from clean & updated backup.



Backup is very old.

I have tried some software but all are paid.They are offering free demo version only.



And please note that there is no guarantee that recovery tool will completely recover your database. You might buy a tool which would ultimately either not be able to recover database or may be recover after deleting huge amount of data. So risk is with you. Since repair allow data loss did not worked problem is grave and recovery tool will delete data( dont know how much) to recover database.
So why not try restoring from previous backup and see hiow much data loss is there leave corrupted database as it is.
Is it possible for you to extract as much data from database as possible or is database not allowing any access. I guess later is true.

Hope this helps

Regards
Shanky
http://social.technet.microsoft.com/wiki/contents/articles/24253.list-of-articles-by-shanky.aspx
Go to Top of Page

alva114
Starting Member

3 Posts

Posted - 2014-08-08 : 05:20:07
Rather than using nay repair tool the best way is to have the backup file. Backup file is the most important solution in recovering any data from any sort of corruption issue. But if you still need a repair tool you can use unspammed to repair and recover the corrupt data base from any sort of corruption issue.
Go to Top of Page

Lincolnburrows
Yak Posting Veteran

52 Posts

Posted - 2014-08-21 : 05:57:12
Well you must read this post :- http://social.msdn.microsoft.com/Forums/en-US/3cd5d48b-0f39-47f9-9023-820ade7c6d03/was-third-party-tool-better-to-use-for-sql-recovery-if-yes-then-which-one?forum=ssdt
Go to Top of Page

bakk
Starting Member

12 Posts

Posted - 2014-09-19 : 02:38:08
DBCC statements allows you to scan and repair SQL database is to execute DBCC CHECKDB statements:

1. Dbcc checkdb ('database_name') with no_infomsgs
You do not need to repair file if the above statement is executed without any errors. Before executing the repair operation, you need to set the database in single user mode by executing:

2. Alter database 'database_name' set SINGLE_USER
You can now start repairing process by using Repair_Rebuild model by executing:

3. Dbcc checkdb('database_name', REPAIR_REBUILD)
If this statement executes successfully, then execute 5.5 else execute:

4. Dbcc checkdb('database_name', REPAIR_ALLOW_DATA_LOSS)
This statement may lead to data loss. If it is executed properly then execute 5.5 else execute:

5. 5.1 Alter database 'database_name' set EMERGENCY
5.2 Alter database 'database_name' set SINGLE_USER
5.3 Dbcc checkdb ('database_name', REPAIR_ALLOW_DATA_LOSS) with no_infomsgs, all_errormsgs
5.4 Alter database 'database_name' set ONLINE
5.5 Alter database 'database_name' set MULTI_USER

For more info, you can visit :- http://repairandmanage.blogspot.in/2014/06/repair-mdf-file-sql-server.html
Go to Top of Page
   

- Advertisement -