Click here to Skip to main content
13,259,771 members (48,221 online)
Rate this:
 
Please Sign up or sign in to vote.
Hi experts,
I made one mistake that,I have over written my existing database with some other database.
but i dont want overwritten database. I want my previous database.
Is there any way to go back to previous state, Please help me to solve this issue. am in big trouble.Can any one Please tell me how to restore the .sql file present in %temp% folder

thanks in advance
(Keerthi Kumar)
Posted 30-Jan-14 23:42pm
Updated 31-Jan-14 0:17am
v2
Comments
Shameel 31-Jan-14 4:48am
   
What database? What do you mean by overwrite? Did you overwrite the physical file or did you overwrite data in a table?
Vedat Ozan Oner 31-Jan-14 4:49am
   
if you don't have any backup, no. that is why you should back-up things.
King_Fisher 31-Jan-14 4:49am
   
http://social.msdn.microsoft.com/Forums/en-US/4fda274c-034a-4463-a748-47f096d8de41/urgent-how-can-i-recoverrestore-an-overwritten-database?forum=sqlazurelabssupport


open run command and excute %temp% .look for .Sql file by lucky you can get the excuted query window
Keerthi Kumar(Andar) 31-Jan-14 5:09am
   
thanks King_Fisher,
I have got .sql file in %temp% folder but Can you please tell me how to restore it??
King_Fisher 31-Jan-14 5:33am
   
try Recover the ldf and mdf files by use softwares

http://www.apexsql.com/sql_tools_recover.aspx

1 solution

Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 1

this is not solution .but you can avoid this
install it
  Permalink  

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month


Advertise | Privacy |
Web02 | 2.8.171114.1 | Last Updated 18 Aug 2015
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100