Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
pearsont74
Starting Member
27 Posts |
 Posted - 2009-05-11 : 14:01:35
|
| ok...we have a production db that we backup. we have the recovery set to full also.i want to know what is the diference? if we ahve a situation where we ahve to restore the db from say an hr ago, can we do this from the transaction log?basically we are wanting to have a good disastor recovery and want to know more on this recovery option. |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-05-11 : 22:43:03
|
| Set Fullbackup,Differential,and Transactional log backup to apply point in time of restore. Read Booksonline for Backups. |
 |
|
|
|
|
|
difference between recovery model vs sql backup