Microsoft KB Archive/811890

= PRB: Error Message: &quot;Unable to copy the initialization file...&quot; Occurs When You Set Up Log Shipping Between Two Clustered SQL Server Servers =

Article ID: 811890

Article Last Modified on 4/30/2003

-

APPLIES TO


 * Microsoft SQL Server 2000 Enterprise Edition
 * Microsoft Windows 2000 Advanced Server

-



SYMPTOMS
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'



RESOLUTION
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 . Expand Security. Click Logins. In the right-hand screen, right-click .</li> Click Properties.</li> In the Properties dialog box, click the Database Access tab.</li> Click to select the check boxes of the databases that must be log shipped.</li> Click OK.</li></ol> </li></ol>

<div class="references_section">