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
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 recover deleted tables

Author  Topic 

chander_2580
Yak Posting Veteran

76 Posts

Posted - 2007-04-26 : 18:52:08
Hi gurus

Is it possible to recover deleted tables of the database ???

actually the senario is this ... i have delete the tables from the database and then import the same tables from the very old backup set. but unfortunatly the required data is missing in new imported tables ... now i want to recover the tables that i have deleted before the import operation.... please help me to overcome this problem.

thanks
chander

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-04-26 : 18:58:58
Don't you have a daily backup? Do you have transaction log backups? What is your recovery model set to for this database?

Tara Kizer
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

chander_2580
Yak Posting Veteran

76 Posts

Posted - 2007-04-26 : 19:28:29
Hi

Recovery model is full but unfortunatly backups are taken on tape drive and i dnt have the facility to get that at this time.

Thanks
chander
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-04-26 : 19:30:45
When was the last time you took a transaction log backup, a full backup, and when did the delete occur? We need all of this information to see if we can reconstruct the data.

Tara Kizer
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

chander_2580
Yak Posting Veteran

76 Posts

Posted - 2007-04-26 : 19:37:35
Hi Tara

I dnt have the access of the tape drive that is used for backups... can we recover tables without useing transaction and fullbackups... i know this task is very much complex but on the same i belive on gurus of sqlteam... please help me to come out from this situation...

thanks
chander
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-04-26 : 19:42:46
If you can't get to your backups, then you will need a third party tool such as Lumigent's Log Explorer. I believe they can read the current transaction log file. But that's assuming you haven't backed it up yet and put it on tape.

It'll probably be cheaper to recover your data from tape though.

Why are your tape backups so inaccessible? What's the point of having them if you can't use them?

Tara Kizer
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

chander_2580
Yak Posting Veteran

76 Posts

Posted - 2007-04-26 : 19:48:50
Tara actually i am the junior one in the team and backups are taken by senior DBA and i dnt wanna disclose this issue in fornt of him .. :( ... so, by useing this tool what procedure i have to follow ?? can u please breif me the steps ...

thanks
chander
Go to Top of Page

chander_2580
Yak Posting Veteran

76 Posts

Posted - 2007-04-26 : 19:51:46
can we do something with the help of profiler ???
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-04-26 : 20:07:43
The tools cost about $300. Do you want to spend that in order to retrieve the data you deleted?

Profiler will not help you here.

You can install a trial version of these tools to see what it does. The trial version won't allow you to retrieve your lost data as they coded it so that it doesn't work on your database. Once you know the trial works fine, that's when you'd purchase it and use it on your actual database.

Tara Kizer
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

chander_2580
Yak Posting Veteran

76 Posts

Posted - 2007-04-26 : 20:12:23
Hi Tara

Means we wont recover data in any case without the help of this tool ?

Thanks
Chander
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-04-26 : 22:54:17
Or with good backup. Anyone makes mistake, try to cover it without proper option may make it worse.
Go to Top of Page

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

7020 Posts

Posted - 2007-04-27 : 00:28:32
quote:
Originally posted by chander_2580

Tara actually i am the junior one in the team and backups are taken by senior DBA and i dnt wanna disclose this issue in fornt of him .. :( ... so, by useing this tool what procedure i have to follow ?? can u please breif me the steps ...

thanks
chander


I think you are making a big mistake by failing to disclose this issue. Anyone can make a mistake and need help to fix it. That's why they have a senior DBA and tape backups.

If you try to conceal this, you are making the situation worse and giving them reason to not trust you in the future.









CODO ERGO SUM
Go to Top of Page

jhermiz

3564 Posts

Posted - 2007-04-27 : 11:33:47
Only time will tell...the senior dba should find out soon enough. I'd take MVJ's suggestion and let the guy / gal know what you did. This will then give you access to the tape backups...

Programmers HowTo's -- [url]http://jhermiz.googlepages.com[/url]
Go to Top of Page

Kristen
Test

22859 Posts

Posted - 2007-04-29 : 12:46:47
Tell the Senior DBA that you though it would be a good idea to test the company's disaster recovery policy before deciding to extend your contract ....

Kristen
Go to Top of Page

dsmvayani
Starting Member

2 Posts

Posted - 2009-01-27 : 05:58:40
how recover sql2005 tables, i have not .bak file

please rply me soon......

Dawood
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-01-27 : 12:57:33
Wave your magic wand?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
   

- Advertisement -