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 |
|
kid_on_the_block
Posting Yak Master
172 Posts |
 Posted - 2006-03-17 : 04:59:59
|
| hi I just created a DB , & ran sp_dboption , it showed me that the trunc. log on chkpt. is true .....What if i set the recovery model of this DB to full , would I be able to recover the DB to a specific point in time , or since trunc. log on chkpt. is true.. I would not be able to collec the transaction log backups ???Cant understand this concept , need some link to read this stuff ....Thanks |
|
|
mwjdavidson
Aged Yak Warrior
735 Posts |
Posted - 2006-03-17 : 05:47:36
|
| Using the full recovery model permits point in time recovery (in Enterprise Edition at least). If you're using the simple model (i.e. trunc. log on chkpt. is true), your exposure to lost data is the time between db backups. Have a look at BOL in the first instance. Googling 'Full Recovery Model' will get you plenty of reading material.Mark |
 |
|
|
|
|
|
trunc. log on chkpt. is true