SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 recover deleted tables
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

chander_2580
Yak Posting Veteran

76 Posts

Posted - 04/26/2007 :  18:52:08  Show Profile  Reply with Quote
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

USA
36782 Posts

Posted - 04/26/2007 :  18:58:58  Show Profile  Visit tkizer's Homepage  Reply with Quote
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 - 04/26/2007 :  19:28:29  Show Profile  Reply with Quote
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

USA
36782 Posts

Posted - 04/26/2007 :  19:30:45  Show Profile  Visit tkizer's Homepage  Reply with Quote
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 - 04/26/2007 :  19:37:35  Show Profile  Reply with Quote
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

USA
36782 Posts

Posted - 04/26/2007 :  19:42:46  Show Profile  Visit tkizer's Homepage  Reply with Quote
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 - 04/26/2007 :  19:48:50  Show Profile  Reply with Quote
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 - 04/26/2007 :  19:51:46  Show Profile  Reply with Quote
can we do something with the help of profiler ???
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
36782 Posts

Posted - 04/26/2007 :  20:07:43  Show Profile  Visit tkizer's Homepage  Reply with Quote
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 - 04/26/2007 :  20:12:23  Show Profile  Reply with Quote
Hi Tara

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

Thanks
Chander
Go to Top of Page

rmiao
Flowing Fount of Yak Knowledge

USA
7266 Posts

Posted - 04/26/2007 :  22:54:17  Show Profile  Reply with Quote
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)

USA
7020 Posts

Posted - 04/27/2007 :  00:28:32  Show Profile  Reply with Quote
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
Flowing Fount of Yak Knowledge

USA
3564 Posts

Posted - 04/27/2007 :  11:33:47  Show Profile  Visit jhermiz's Homepage  Reply with Quote
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 -- http://jhermiz.googlepages.com
Go to Top of Page

Kristen
Test

United Kingdom
22403 Posts

Posted - 04/29/2007 :  12:46:47  Show Profile  Reply with Quote
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

Pakistan
2 Posts

Posted - 01/27/2009 :  05:58:40  Show Profile  Reply with Quote
how recover sql2005 tables, i have not .bak file

please rply me soon......

Dawood
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
36782 Posts

Posted - 01/27/2009 :  12:57:33  Show Profile  Visit tkizer's Homepage  Reply with Quote
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
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.14 seconds. Powered By: Snitz Forums 2000