July 30, 2013 at 9:55 pm
Dear,
I have restored a database with an existing database. But there was some important information in my previous database. I forgot to backup the previous database.
Now I want to get previous database. But how to get it?
I am using SQL 2008 R2. Please help me.
Regards,
Akbar
July 30, 2013 at 9:59 pm
If you restored a backup over the database without having performed a backup to save that important data, you have lost the data.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 30, 2013 at 10:23 pm
SQLRNNR (7/30/2013)
If you restored a backup over the database without having performed a backup to save that important data, you have lost the data.
NO WAY TO GET BACK?
July 30, 2013 at 10:29 pm
shohelr2003 (7/30/2013)
SQLRNNR (7/30/2013)
If you restored a backup over the database without having performed a backup to save that important data, you have lost the data.NO WAY TO GET BACK?
You would need a backup of the database or to have saved that data somewhere in some fashion.
If you have overwritten it, it is gone.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 30, 2013 at 11:29 pm
A comprehensive discussion of the various options tried in the past can be found here:
http://www.sqlservercentral.com/Forums/Topic860953-61-1.aspx
...One of the symptoms of an approaching nervous breakdown is the belief that ones work is terribly important.... Bertrand Russell
July 30, 2013 at 11:34 pm
GPO (7/30/2013)
A comprehensive discussion of the various options tried in the past can be found here:http://www.sqlservercentral.com/Forums/Topic860953-61-1.aspx
:-D:hehe:
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply