SQL Server Performance Forum – Threads Archive

Restore of database to point-in-time

Hello,
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 changes.is 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, please refer BOL , and here is a nice article for Point-in-time recovery FYI : http://www.dbarecovery.com/fullrestorepitr.html</a> but if you wish to recover / undo / redo the changes in your sp you will find some other tools like : http://www.red-gate.com/products/sql_log_rescue/technical_papers/minimizing_risk.htm</a> please refer sponcer section for more. <img src=’/community/emoticons/emotion-1.gif’ alt=’

‘ /> HTH Regards Hemantgiri S. Goswami [email protected] "Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemantgiri S. Goswami

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
–Rajiv

]]>