Hello
I was brought in on a project where the plan was to take transaction logs from a vendors SQL database, FTP them to our server and apply the logs on our database on a daily basis.
When testing, I was using the vendors BAK then applying the vendors logs - which worked - we thought we could back up our database then apply the vendors logs but this does not work because the LSNs become out of sync.
Is it possible to do what we are trying to do? I suggested setting up log shipping but was told that wouldn't work because the 2 servers needed to be on the same network - is this true? Security was the big concern and there was a big push from management to follow their initial plan.
Could someone with more experience please respond with my options so that I can explain to management?
Thanks
Dave
I was brought in on a project where the plan was to take transaction logs from a vendors SQL database, FTP them to our server and apply the logs on our database on a daily basis.
When testing, I was using the vendors BAK then applying the vendors logs - which worked - we thought we could back up our database then apply the vendors logs but this does not work because the LSNs become out of sync.
Is it possible to do what we are trying to do? I suggested setting up log shipping but was told that wouldn't work because the 2 servers needed to be on the same network - is this true? Security was the big concern and there was a big push from management to follow their initial plan.
Could someone with more experience please respond with my options so that I can explain to management?
Thanks
Dave