May 13, 2009 at 3:34 am
Bulk logged operation will not be recorded in the log. So how do the copying of the bulk transactions in the log shipping.Please Help
May 13, 2009 at 5:00 am
Need to change the recovery model to FULL if you need logging to happen for all transactions and later propagated by log shipping
Refer BOL on operations which are not logged by BULK recovery model to get some further understanding.
-:-)
Cheer Satish 🙂
May 13, 2009 at 5:57 am
Mallikharjuna Raju (5/13/2009)
Bulk logged operation will not be recorded in the log. So how do the copying of the bulk transactions in the log shipping.Please Help
In bulk logged recovery model, the bulk transactions are minimally logged it't not that they are not logged at all. It only records what extents have changed. So, when the server ships the log the standy server would have the same information as what extents have changed.
May 13, 2009 at 6:05 am
In bulk logged recovery model, the bulk transactions are minimally logged it't not that they are not logged at all. It only records what extents have changed. So, when the server ships the log the standy server would have the same information as what extents have changed. 🙂
May 13, 2009 at 11:38 am
Sundar K. Urs (5/13/2009)
In bulk logged recovery model, the bulk transactions are minimally logged it't not that they are not logged at all. It only records what extents have changed. So, when the server ships the log the standy server would have the same information as what extents have changed. 🙂
??? Why is this....
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply