Author |
Topic |
chander_2580
Yak Posting Veteran
76 Posts |
Posted - 2007-04-26 : 18:52:08
|
Hi gurusIs 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.thankschander |
|
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 Kizerhttp://weblogs.sqlteam.com/tarad/ |
|
|
chander_2580
Yak Posting Veteran
76 Posts |
Posted - 2007-04-26 : 19:28:29
|
HiRecovery model is full but unfortunatly backups are taken on tape drive and i dnt have the facility to get that at this time.Thankschander |
|
|
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 Kizerhttp://weblogs.sqlteam.com/tarad/ |
|
|
chander_2580
Yak Posting Veteran
76 Posts |
Posted - 2007-04-26 : 19:37:35
|
Hi TaraI 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...thankschander |
|
|
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 Kizerhttp://weblogs.sqlteam.com/tarad/ |
|
|
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 |
|
|
chander_2580
Yak Posting Veteran
76 Posts |
Posted - 2007-04-26 : 19:51:46
|
can we do something with the help of profiler ??? |
|
|
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 Kizerhttp://weblogs.sqlteam.com/tarad/ |
|
|
chander_2580
Yak Posting Veteran
76 Posts |
Posted - 2007-04-26 : 20:12:23
|
Hi TaraMeans we wont recover data in any case without the help of this tool ? ThanksChander |
|
|
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. |
|
|
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 |
|
|
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] |
|
|
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 |
|
|
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 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|