April 9, 2014 at 12:01 am
Hi,
I restored my database with the old backup without backing up the latest database.
Can i rollback this restoration.
Actually I have write a stored procedure with large code in latest database.
Now it is replaced with old database.
Is there any technique to get that latest procedure code.
I had run this procedure several times before.
Plz help me.
-----
Thanks
Thanks.......
-----------------------------------
My Blog[/url] | Articles
April 9, 2014 at 1:16 am
No. If you've overwritten a database without backing it up first then that database is lost. I assume you are not using source control and you didn't save a copy of your stored procedure to the file system anywhere?
Regards
Lempster
April 9, 2014 at 2:54 am
It is not possible to recover database without backup.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 9, 2014 at 5:48 am
The entire idea behind backups is to have a complete copy of the database. A restore operation also is a complete copy of the database. This is not an import/export operation, but a page by page copy of the entire database. With your restore complete, you're just stuck. Sorry.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply