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 |
|
chetan_dba
Starting Member
21 Posts |
 Posted - 2008-03-25 : 03:49:22
|
| Hi,If i have enabled truncate log on checkpoint option then -- 1. Can i take transaction log backup?2. Can i use point-in-time recovery for the Datbase.can somebody help me on this. please explain the concept also.Thanks in advance.-- Chetan |
|
|
CShaw
Yak Posting Veteran
65 Posts |
Posted - 2008-03-25 : 11:57:03
|
| If you have enabled truncate log on checkpoint by selecting the recovery mode, any transactions that have made it to the MDF since the last full backup will not be restoreable. So you will not be able to do a point in time recovery, and you will not be able to backup the T-Log.What this option does is every time a checkpoint happens (Data written from the log to the mdf) that it will delete the data from the log when the write to the mdf is complete. In the other scenario lets say a full recovery model then when a checkpoint happens the data will stay in the log after it has been written to the mdf and will not be removed until the T-Log has been backed up.I hope this is what you are looking for.Chris Shawwww.SQLonCall.com |
 |
|
|
stephe40
Posting Yak Master
218 Posts |
Posted - 2008-03-25 : 15:45:30
|
| Posting test questions on this forum is frowned upon.- Eric |
|
|
|
|
|
|
Transaction Log Backup