July 12, 2012 at 2:31 pm
My Sql server 2005 Database get corrupted coz of some virus infection. No tables are showing now. My database folder contains .mdf, .ldf and file (3 files) can I retrieve my tables using one of this. Any solution please? I don't have any other backups.
Please get a solution.
July 13, 2012 at 2:29 am
No backups? Why not?
What is the output from the following command
DBCC CHECKDB <Database Name> WITH NO_INFOMSGS, ALL_ERRORMSGS
July 13, 2012 at 3:02 am
If you have no backups then you very likely have lost any data that was in those tables. There are no magic recovery tricks, if the tables are gone, they're gone and the only way to get them back would be to restore a backup.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 14, 2012 at 12:10 am
This was removed by the editor as SPAM
July 17, 2012 at 12:12 pm
Before you spend money on repair software, be aware that if the data is gone, no software program may be able to recover it. It can't recover what's not there. There is a very limited use case where these programs are actually effective. If you're desparate, it may be worth trying, but you should be aware ahead of time that it probably won't work.
Also, all tables not showing up sounds a lot like a permissions issue. Are you sure the tables are gone and that it's not a case of you don't ahve sufficient privileges?
July 17, 2012 at 12:23 pm
What are the names of the files you have left? Does the SQL Server start? What error messages are you getting? Are all the logins still intact? Can you see the database and the tables aren't there or can you not see the database at all?
July 20, 2012 at 5:54 am
Reasons like server crashing, system software malfunction, hardware failure and virus infection can easily cause corruption in SQL Server database. When SQL database corrupts, vital data get lost and important business work stops. To handle such situation, database needs to be recovered by some special methods as manual recovery is not possible in severe database corruption issues. There are several third party SQL recovery tools available that can easily repair SQL database and retrieve the data. Don't go for buying the software instantly download the demo version first and check if the software works as intended or not. I have searche one tool for you download it and check if it works http://www.nucleustechnologies.com/sql-recovery.html . I have used other products from the same vendor.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply