Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Applying Tran Logs / Server outside of network

Status
Not open for further replies.

R7Dave

Programmer
Oct 31, 2007
181
US
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top