July 7, 2016 at 7:36 pm
You can go in and directly modify all of the log shipping tables and jobs if you want. But personally in this situation I simply use scripts and windows scheduled tasks to move the files around and simple backup/restore jobs to do my own log shipping. Easy-peasy, lemon-squeezy!! 😎
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
July 8, 2016 at 6:09 am
Are you able to connect the Primary SQL Server of Logshipping from Secondary SQL Server of Log Shipping from Management Studio of Secondary SQL Server.
July 8, 2016 at 9:36 am
SQL 2005, but it still applies:
https://support.microsoft.com/en-us/kb/321247
"Configure the network share that is configured to hold the transaction log backups to have read/change permissions for the account under which SQL Server services (on the secondary server that is configured for log shipping) are starting.
The network share that is configured to hold the transaction log backups, should be configured to have read/change permissions for the account under which SQL Server services, on the secondary server configured for log-shipping, are starting. This share is accessed by the Copy job on the secondary server to copy the transaction log backups to the local folder on the respective secondary server. The Load job then loads these backups from the local folder.
Cross Domain Log Shipping
If computers that are running SQL Server are placed in a multi-domain environment, Microsoft recommends that you set up two-way trusts between all domains that are involved in log shipping. However, if you cannot establish trusts between domains, you can use network pass-through security for log shipping. Refer to the section of this article that discusses the LocalSystem network account startup option for SQL Server-related services. "
Viewing 3 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply