Showing posts with label Log shipping. Show all posts
Showing posts with label Log shipping. Show all posts

Tuesday, 28 March 2017

Justify the Remote access requirement for Biztalk Log Shipping


I have been in a situation where our Security compliance team requested to prove that remote access configuration is indeed mandatory to setup log shipping for a Biztalk database. As all we know this configuration option is used to execute remote stored procedures from local server or allow access from remote server to execute a local stored procedure. Of course this has to be accompanied with a linked server that provide RPC_OUT services.

Refer below my article for more details.

http://www.sqlservercentral.com/links/337157/360187