Click here to Skip to main content
13,772,645 members
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
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

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

1 solution

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

Solution 1

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

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 | Cookies | Terms of Service
Web05 | 2.8.181119.1 | Last Updated 18 Aug 2015
Copyright © CodeProject, 1999-2018
All Rights Reserved.
Layout: fixed | fluid

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