SQL Server Performance Forum – Threads Archive
Restore of database to point-in-timeHello,
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,<br />please refer BOL , and here is a nice article for Point-in-time recovery FYI :<br /><br /<a target="_blank" href=http://www.dbarecovery.com/fullrestorepitr.html>http://www.dbarecovery.com/fullrestorepitr.html</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=http://www.red-gate.com/products/sql_log_rescue/technical_papers/minimizing_risk.htm>http://www.red-gate.com/products/sql_log_rescue/technical_papers/minimizing_risk.htm</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