• kenny 40254 (2/3/2016)


    Forgive my "greeness" on all of this...

    I'm sure that the originating vendor of the solution we are log shipping from (and the customer) have no coordinated backup strategy. The managed service provider appears to have set up weekly backup jobs (they refer to full backups). Will my switching the recovery model break that?

    No, t-log backups do not affect full backups.

    kenny 40254 (2/3/2016)


    What about bulk logged recovery model? Does that offer any benefits in terms of not forcing changes to backups?

    Bulk logged is a short term model used for log backups during load procedures.

    You need to be selecting full recovery model to support the log shipping plan, if not remove the LS plan.

    As gail has pointed out the t log backups will be handled by a specific sql server agent job on the primary server, if you check it's history you should see failures for this job at present.

    You'll need to find out how "out of sync" the primary and secondary are before just switching to full recovery model.

    kenny 40254 (2/3/2016)


    I'm trying to have as little impact on the primary server as possible. Backup or otherwise. I just want to set up log shipping and get out of there :Whistling:

    I do hope your client can't read this 😉

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉