Data Recovery - After Drop a table and creating the same table
-
Hi All, i did a serious mistake, and loss all the data of one financial year in sql server. I create the script of all tables of a database, and i was inteneded to execute this script on a new database, but unfortunately i executed on the same database, now all my tables are blank (no data). One more thing, i did not planned any backup model for this now i only have .mdf & .ldf files. HOw i can recover it, is there any way, please suggest. Many Thanks & Best Regards, adnan
Many Thanks, Adnan Rafiq muhammadadnanrafiq@gmail.com
-
Hi All, i did a serious mistake, and loss all the data of one financial year in sql server. I create the script of all tables of a database, and i was inteneded to execute this script on a new database, but unfortunately i executed on the same database, now all my tables are blank (no data). One more thing, i did not planned any backup model for this now i only have .mdf & .ldf files. HOw i can recover it, is there any way, please suggest. Many Thanks & Best Regards, adnan
Many Thanks, Adnan Rafiq muhammadadnanrafiq@gmail.com
-
If transaction log is enabled, then you can try restoring from transaction log. however i've never tried this. you have to refer to some articles on how to do.
Regards KP
Thanks for Repley. I tried google a lot, but dont find any suitable solution, actually i did blunder, becuase script also have drop database, and create databse with the same name, please reffer me to some article. Many Thanks & Best Regards, adnan
Many Thanks, Adnan Rafiq muhammadadnanrafiq@gmail.com
-
Thanks for Repley. I tried google a lot, but dont find any suitable solution, actually i did blunder, becuase script also have drop database, and create databse with the same name, please reffer me to some article. Many Thanks & Best Regards, adnan
Many Thanks, Adnan Rafiq muhammadadnanrafiq@gmail.com
Sorry to say, but you are stuffed here.
Deja View - the feeling that you've seen this post before.
-
Sorry to say, but you are stuffed here.
Deja View - the feeling that you've seen this post before.
Is there any option to recover, if i tried to recover old files by using data recovery software like easyrecovery.......
Many Thanks, Adnan Rafiq muhammadadnanrafiq@gmail.com
-
Thanks for Repley. I tried google a lot, but dont find any suitable solution, actually i did blunder, becuase script also have drop database, and create databse with the same name, please reffer me to some article. Many Thanks & Best Regards, adnan
Many Thanks, Adnan Rafiq muhammadadnanrafiq@gmail.com
-
Is there any option to recover, if i tried to recover old files by using data recovery software like easyrecovery.......
Many Thanks, Adnan Rafiq muhammadadnanrafiq@gmail.com
-
As long transaction log is present, it is possible to recover. once is truncated or deleted, i don't think is possible.
Regards KP
Thanks for Helping to forget about it .
Many Thanks, Adnan Rafiq muhammadadnanrafiq@gmail.com