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
 Software to repair database

Author  Topic 

dk
Starting Member

35 Posts

Posted - 2011-05-15 : 15:53:38
Hi all,

I have to repair MS Navison database, 3 GB. The database contains MDF, NDF and log files. I tried a few demo programs, but I didn't manage to get a look at the data, as is usual with these demo programs. I just got a list of all tables.
It would be very nice if somebody can suggest something...

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2011-05-15 : 17:44:21
Most of the data recovery tools don't work well or at all.

Why are you looking for one? What's wrong with the database?

--
Gail Shaw
SQL Server MVP
Go to Top of Page

dk
Starting Member

35 Posts

Posted - 2011-05-16 : 00:35:43
We have SBS 2003 with RAID 5 destroyed. We managed to save all data, but database need to be repaired, because system crushed and database didn't closed.
Go to Top of Page

prett
Posting Yak Master

212 Posts

Posted - 2011-05-16 : 01:36:34
Which version you uesd in MS SQL Server..
Go to Top of Page

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2011-05-16 : 01:43:25
Specific details please. I help a lot of people recover databases using CheckDB. Can't help without details though

Is the DB attached to a database server?
If not, what error do you get attaching?
If it is, what state is it in?

--
Gail Shaw
SQL Server MVP
Go to Top of Page

dk
Starting Member

35 Posts

Posted - 2011-05-16 : 11:13:09
It is SQL 2005.

No, we didn't manage to get SBS 2003 back. We will probably install SBS 2011. We tried to attach DB to another server with this error:
DBCC CHECKDB ('NAV500');GO

Msg 7985, Level 16, State 2, Line 1System table pre-checks: Object ID 4. Could not read and latch page (1:2303) with latch type SH. Check statement terminated due to unrepairable error.DBCC results for 'NAV500'.Msg 5233, Level 16, State 98, Line 1Table error: alloc unit ID 262144, page (1:2303). The test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. The values are 12716041 and -4.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 'NAV500'.

This message we got after created similar DB, closed SQL server, copied NAV files instead similar DB, open SQL again. Then we got DB in SUSPECT mode, and transfered DB to EMERGENCY mode. Then we could get some data from tables with SELECT, from some nothing.

I'll try to get message when we tried to attach DB.

Thanks...
Go to Top of Page

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2011-05-16 : 11:16:14
Yeah, that's pretty fatal, system tables are damaged. Restore from a backup.

--
Gail Shaw
SQL Server MVP
Go to Top of Page

dk
Starting Member

35 Posts

Posted - 2011-05-16 : 11:24:41
This message we got after REPAIR_ALLOW_DATA_LOSS...
Go to Top of Page

dk
Starting Member

35 Posts

Posted - 2011-05-16 : 11:26:17
we have backup from 26.1.2011. only... :-(((
Go to Top of Page

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2011-05-16 : 11:38:09
That may well be the best you can do. One of the critical system tables is damaged, without that there will be problems cracking the rows into columns.

Restore the backup, then use the emergency mode to extract what data you can, merge the two as best as possible.

Critical database, no backups?

--
Gail Shaw
SQL Server MVP
Go to Top of Page

dk
Starting Member

35 Posts

Posted - 2011-05-16 : 14:15:20
We had tape drive which broke down a few months ago. We couldn't manage to fix it. Finance...
Go to Top of Page

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2011-05-16 : 15:32:17
And backups couldn't be done to disk because .... ?

--
Gail Shaw
SQL Server MVP
Go to Top of Page

prett
Posting Yak Master

212 Posts

Posted - 2011-05-17 : 00:06:53
Hello dk,

If you dont have backup then you should try SQL Recovery Software but first I will suggest you to try its demo version because you dont know this software recover your database or not. Check this software, it supports SQL Server 2005: unspammed
Go to Top of Page

dk
Starting Member

35 Posts

Posted - 2011-05-17 : 00:53:03
I tried that program. I got all of the tables, but I can't preview data. So, I am not sure what to do.
Go to Top of Page

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2011-05-17 : 01:41:32
They want you to buy it, that's why it doesn't show much. If you want to take a chance, go ahead, but there's no guarantee it'll do what is advertised. Bear in mind that with the critical system tables damaged, the tables' definitions may have been lost.

Last time I used one of those type of tools on a seriously corrupt DB (file header was damaged) it showed all the tables so we bought it. It then recovered a portion of the columns for a portion of the tables, not enough for us to even begin to put the DB back together. Complete waste of money

Try first a combination of restoring your last backup and extracting what data you can from suspect DB and combining those. Then see what you have lost and make a call as to whether you will risk buying a data recovery tool.

--
Gail Shaw
SQL Server MVP
Go to Top of Page

prett
Posting Yak Master

212 Posts

Posted - 2011-05-17 : 02:20:20
quote:
Originally posted by dk

I tried that program. I got all of the tables, but I can't preview data. So, I am not sure what to do.



Hello dk,

I am not trying to sell any software here. It's your wish to purchase it or not. Only i will suggest you to try its demo version. Demo version shows the preview of all your recovered data. You can also contact the support by this toll free number: +1-877-778-6087 & find the solution of your problem.

Note:If your database is not recovered by the software then they refund your money within one month check this link to know more about refund policy: http://www.stellarinfo.com/pdf/refund-policy.pdf
Go to Top of Page

dk
Starting Member

35 Posts

Posted - 2011-05-17 : 03:25:51
This message we got after tried to attasch DB:

An exception occurred while executing a Transact-SQL statement or batch.
(Microsoft.SqlServer.ConnectionInfo)

------------------------------

Could not redo log record (1720:5374:4), for transaction ID (0:0), on page
(3:137496), database 'NAV500' (database ID 11). Page: LSN = (1709:1343:63), type =
11. Log: OpCode = 7, context 11, PrevPageLSN: (1718:553:48). Restore from a backup of
the database, or repair the database.
During redoing of a logged operation in database 'NAV500', an error occurred at log
record ID (1720:5374:4). Typically, the specific failure is previously logged as an
error in the Windows Event Log service. Restore the database from a full backup, or
repair the database.
Could not open new database 'NAV500'. CREATE DATABASE is aborted. (Microsoft SQL
Server, Error: 3456)


Any idea?
Go to Top of Page

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2011-05-17 : 04:30:00
That would require a hack-attach and repair, but as you've already seen, checkDB can't run due to the system table damage. I don't think this is repairable.

--
Gail Shaw
SQL Server MVP
Go to Top of Page

prett
Posting Yak Master

212 Posts

Posted - 2011-05-17 : 04:35:09
Hello dk,

You know when data get overwrite, no one can repair it. If you want to back your data, I will suggest you to try SQL Recovery Software.
Go to Top of Page

3magic
Starting Member

14 Posts

Posted - 2011-08-05 : 02:10:36
Stellar Macintosh Data Recovery helps you recover deleted files, formatted partitions, undelete empty trash, recover documents, those were lost long back.
Go to Top of Page

scarlet123
Starting Member

1 Post

Posted - 2011-09-07 : 07:28:00
Stellar Phoenix SQL repair is one of the best software which can easily repair sql database. Also it recovers the deleted or missing SQL files within few clicks only. So just try it once.
unspammed
Go to Top of Page
  Previous Page&nsp;  Next Page

- Advertisement -