| Author |
Topic |
|
AdiI
Starting Member
31 Posts |
 Posted - 2009-07-01 : 06:31:07
|
| Hello to alli have been facing a very serious problem. i'm oracle DBA i never work with SQL SERVER. i have deleted a database unintentionally. i have full backup 2 week ago. i did RND on net than i came to know transaction log. before going to actually corrupted database and restore it i have created a test database. create a table in it 2 or three record now i take backup and than create 2 more table and insert some record and delete db by right click management studio explorer. now i restore db with option Leave the database non-operational, and do not roll back the uncommitted transactions. Additional transaction logs can be restored. (RESTORE WITH NORECOVERY) my question is how to apply transaction log From previous backups of database it show blank From file or tape what file i select what is the backup log plz help if u need more information i will explain moreadeel |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-07-01 : 06:52:27
|
The real question is how the database was deleted.Did you do a simple "DROP DATABASE"?
N 56°04'39.26"E 12°55'05.63" |
 |
|
|
AdiI
Starting Member
31 Posts |
Posted - 2009-07-01 : 07:09:28
|
i have right click on management studio and delete databasequote:
Originally posted by Peso
The real question is how the database was deleted.Did you do a simple "DROP DATABASE"?
N 56°04'39.26"E 12°55'05.63"
adeel |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-07-01 : 07:14:22
|
Ok. Then the database is physically deleted from disks too.Hve you tried using a 3rd party undelete application?
N 56°04'39.26"E 12°55'05.63" |
|
|
|
AdiI
Starting Member
31 Posts |
Posted - 2009-07-01 : 07:22:05
|
no i have no idea about 3rd software in SQL server. but sir i have read on net if you have full backup then transaction log can be used be recover. but how to apply transaction i have found a Microsoft link http://msdn.microsoft.com/en-us/library/ms177446.aspxbut option From previous backups of database stuck me. here nothing is display plz help me how to apply transaction log or any other solution to recover i will great full to u quote:
Originally posted by Peso
Ok. Then the database is physically deleted from disks too.Hve you tried using a 3rd party undelete application?
N 56°04'39.26"E 12°55'05.63"
adeel |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-07-01 : 07:29:00
|
Since you deleted the database, the log file is deleted too.You can use the latest full backup (and trailing incremental) to restore your database.But data will be lost.Here is one application of many to undelete files.http://www.officerecovery.com/freeundelete/Just remember you don't want to install this on same drive as your database files were.If you succceed to install the undelete application, you can locate your deleted database files and undelete them.When undeleted, you can try attach the files from disk.If you succeed this far, now is the time to check your database and discuss some serious backup strategies...
N 56°04'39.26"E 12°55'05.63" |
|
|
|
AdiI
Starting Member
31 Posts |
Posted - 2009-07-02 : 00:57:54
|
| hello i have posted this problem yesterday. im still finding solution. kindly help. i have backup or database two week ago one user of this forum told me in last post that transaction log also delete when u delete database. my question is what is the benefit of transaction log? i tried third party tool to recover but in vain. how can it possible a database u deleted very easily but to recover it is impossible. all of u sql experts plz help how can i recover database waiting for your replyadeel |
|
|
|
dbalearner
Constraint Violating Yak Guru
272 Posts |
Posted - 2009-07-02 : 01:14:25
|
| if you maintain the backup copy with extension .BAK then that would be the most latest backup, and followed by if you have the .TRN files which you allowed to generate then they would be applied for Point-in-Time Recovery purpose.Otherwise as dictated by 3rd party undelete application tool which invokes the lost file can be applied as above steps. |
|
|
|
AdiI
Starting Member
31 Posts |
Posted - 2009-07-02 : 01:27:17
|
| the 3rd party tool recover only those file which we deleted by shift+delete. i have created a new database from management explorer window two file created in sql server data file and log file now i delete database from management studio now run the 3rd party tool it does not recover. i could not understand what u said in first line plz explain it more i'm sorry i 'm new SQL SERVERadeel |
|
|
|
|
how to recover deleted database