Wednesday, March 7, 2012

Log Shipping between 2 Clusters

Hi
I'm trying to setup log shipping between two 2-node Active/Passive clusters and I keep getting an error "Unable to copy the initialization file to the secondary server".
I've search KB, to find an article KB/811890, but both clusters are in the same domain, and thus this article shouldn't apply. However, I'll try anything, so I have re-registered the second (log ship recipient) cluster as per the recommendations (SERVERN
AME.DOMAIN), but still get the same message.
I know its probably me that doing something wrong, but I'm stuck at what.
I have tried registering the instances in the following ways.
- Using the Cluster name (as opened within Cluster Administrator)
- Using the Virtual Server Name (as provided within the SQL Install)
- Using the Cluster IP Address
- Using the Virtual SQL Server IP Address
In all cases, I either get the same error, or don't get that far.
Can you please assist?
Thanks, in advance for your assistance.
Bev
Try the following to see if it helps
1)Run the stored procs (http://support.microsoft.com/default...&Product=sql2k) to clean up log shipping.
2)Verify that the SQL Server and SQL Server Agent services on primary and secondary SQL Servers are running under a domain account
3)Verify with your NT Administrator that there is a two way trust between the domains.
4)Log on to primary server using the domain account used to start SQL Server services on primary server.
a)Open Query Analyzer and use xp_cmdshell command to copy a file (any file will do) from the share on primary server (i.e. the share on primary server where you
want the transaction log backups to be stored) to the share on the secondary server. If you get error like access denied then we will need to fix this first.
b)Open Enterprise Manager and verify that you can register the primary and secondary SQL Servers.
c)Verify that the database you want to use for log shipping does not have SIMPLE Recovery model.
d)Verify that that the domain account that is used to start SQL Server services has access permission to the database that you want to use for log shipping.
e)Configure Log Shipping.
Best Regards,
Uttam Parui
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit http://www.microsoft.com/security.
Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against viruses and security vulnerabilities. The easiest way to do this is to visit the following websites:
http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx

No comments:

Post a Comment