| 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 1An internal error occurred in DBCC that prevented further processing. Contact Customer Support Services.Msg 7985, Level 16, State 2, Line 1System 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 1Table 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. |
 |
|
|
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 KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
|
|
|
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. |
|
|
|
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] |
|
|
|
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 KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
|
|
|
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 helpsRegardsShankyhttp://social.technet.microsoft.com/wiki/contents/articles/24253.list-of-articles-by-shanky.aspx |
|
|
|
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. |
|
|
|
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 |
|
|
|
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_infomsgsYou 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_USERYou 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 EMERGENCY5.2 Alter database 'database_name' set SINGLE_USER5.3 Dbcc checkdb ('database_name', REPAIR_ALLOW_DATA_LOSS) with no_infomsgs, all_errormsgs5.4 Alter database 'database_name' set ONLINE5.5 Alter database 'database_name' set MULTI_USERFor more info, you can visit :- http://repairandmanage.blogspot.in/2014/06/repair-mdf-file-sql-server.html |
|
|
|
|
Free SQL Database Tool Repair