Has anyone done Log Shipping with the Bulk Logged Recovery Model on the source database before?
The source DB receives a lot DTS jobs that delete the rows in the destination table and re-insert the data which logs in the Transaction Logs. The destination DB is supposed to get the database for a read-only report server, but I have been informed by my boss that the destination DB cannot have the tables deleted and re-inserted. Hence the reason I am going to make the Source DB Bulk-Logged.
Not sure if it'll work yet, but I'll find out shortly. In the meantime, wanted to check to see if anyone else has done this before and if it caused any problems that they are aware of.
Thanks!
Catadmin - MCDBA, MCSA
Remember, "Work" is a four letter word. And you know what your mother told you about using four letter words!
The source DB receives a lot DTS jobs that delete the rows in the destination table and re-insert the data which logs in the Transaction Logs. The destination DB is supposed to get the database for a read-only report server, but I have been informed by my boss that the destination DB cannot have the tables deleted and re-inserted. Hence the reason I am going to make the Source DB Bulk-Logged.
Not sure if it'll work yet, but I'll find out shortly. In the meantime, wanted to check to see if anyone else has done this before and if it caused any problems that they are aware of.
Thanks!
Catadmin - MCDBA, MCSA
Remember, "Work" is a four letter word. And you know what your mother told you about using four letter words!