This article has been archived. It is offered "as is" and will no longer be updated.
When you set up log shipping between two clustered SQL Server servers that are running Microsoft Windows 2000 Advanced Server in separate domains with trusted relationships, you may receive the following error message:
Unable to copy the initialization file to the secondary server '%s'
To resolve this problem, follow these steps:
When you register the SQL Server name in SQL Server Enterprise Manager, append the domain name to the secondary server name. For example, if your secondary server name is LOGSERVER2 and the domain name is DOMAIN2, the registering server name must be LOGSERVER2.DOMAIN2.
Grant access to the login used for the log shipping set up on the database. To do so, use these steps:
Open SQL Server Enterprise Manager.
Expand primary server.
In the right-hand screen, right-click login_name.
In the Properties dialog box, click the Database Access tab.
Click to select the check boxes of the databases that must be log shipped.
For more information about how to set up log shipping, visit the following Microsoft Web site: