December 25, 2006 at 7:54 pm
Hi I miss recover one database by using backup file of this database and restore to another database (the problem is:I have not backup file of target DB that I miss recover and have not any 3rd application)
So how can I recovery the database that was miss recover
Any help :thanks so much !
December 25, 2006 at 9:42 pm
I didn't get what you asked but..
I think you want to recover restored db...
with the following...
RESTOER DATABASE <DB NAME> WITH RECOVERY
MohammedU
Microsoft SQL Server MVP
December 28, 2006 at 9:42 am
If you mean you overwrote a database with a backup of another my mistake and don't have a backup of the overwritten database, then I'm afraid there's nothing you can do, sorry.
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply