Restore of database to point-in-time | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Restore of database to point-in-time

Before asking the actual question I would like to describe the scenario. I took full backup of my databases with log backup at 1:00 Pm. At 1:15 one of my procedures got deleted by mistake. I was working on that and
after taking my last backup i.e.1;00 Pm I had mad a lot of changes in that sp.
after deleted this sp I again took the whole backupd of databse.
I was trying to retrive that sp with the last it possibel to
recover that with all the changes. I have heard abt point-in-time recovery.
Can anybody tell me abt this and how can I retrive this sp with all the latest
changes?? Need response urgently.. Thanks & Regards Niladri saha Niladri
Hi,<br />please refer BOL , and here is a nice article for Point-in-time recovery FYI :<br /><br /<a target="_blank" href=></a><br /><br />but if you wish to recover / undo / redo the changes in your sp you will find some other tools like :<br /><br /<a target="_blank" href=></a><br /><br />please refer sponcer section for more.<br /><br /><img src=’/community/emoticons/emotion-1.gif’ alt=’:)‘ /><br />HTH<br />Regards<br /><br />Hemantgiri S. Goswami<br />[email protected]<br />"Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemantgiri S. Goswami<br />
If you dont have much exposure to SQL queries.You can make use of Enterprise manager. Right click Database > Restore >
this will list all list of backups available(full and T Log backups)
Just select the full backup taken before 1:00PM ,This will automatically
select the Tlog backups taken after that .
Just click restore button . But you will lose all changes made after 1:15PM ,but ur sp will be intact