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

Article ID: 811890 - View products that this article applies to.
Expand all | Collapse all

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'
Back to the top | Give Feedback

RESOLUTION

To resolve this problem, follow these steps:
  1. 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.
  2. Grant access to the login used for the log shipping set up on the database. To do so,
    use these steps:

    1. Open SQL Server Enterprise Manager.
    2. Expand primary server.
    3. Expand Security.
    4. Click Logins.
    5. In the right-hand screen, right-click login_name.
    6. Click Properties.
    7. In the Properties dialog box, click the Database Access tab.
    8. Click to select the check boxes of the databases that must be log shipped.
    9. Click OK.
Back to the top | Give Feedback

REFERENCES

For more information about how to set up log shipping, visit the following Microsoft Web site:

http://download.microsoft.com/download/SQLSVR2000/Utility/2.0/WIN98/EN-US/log_shipping.exe
(http://download.microsoft.com/download/sqlsvr2000/utility/2.0/win98/en-us/log_shipping.exe)


For additional information, click the following article numbers to view the articles in the Microsoft Knowledge Base:
314515
(http://support.microsoft.com/kb/314515/EN-US/ )
INF: Frequently Asked Questions - SQL Server 2000 - Log Shipping
810969
(http://support.microsoft.com/kb/810969/EN-US/ )
FIX: Log Shipping with SQL Server Authentication Generates Backup and "Out of Sync" Threshold Alerts
Back to the top | Give Feedback

Properties

Article ID: 811890 - Last Review: April 30, 2003 - Revision: 1.4
APPLIES TO
  • Microsoft SQL Server 2000 Enterprise Edition
  • Microsoft Windows 2000 Advanced Server
Keywords: 
kberrmsg kbsysadmin kbprb KB811890
Back to the top | Give Feedback

Give Feedback

 
Back to the topBack to the top