PRB: Error Message: "Unable to copy the initialization file..." Occurs When You Set Up Log Shipping Between Two Clustered SQL Server Servers (811890)
The information in this article applies to:
- Microsoft SQL Server 2000 Enterprise Edition
- Microsoft Windows 2000 Advanced Server
SYMPTOMSWhen 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'
RESOLUTIONTo 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.
- Expand Security.
- Click Logins.
- In the right-hand screen, right-click
login_name.
- Click Properties.
- In the Properties dialog box, click
the Database Access tab.
- Click to select the check boxes of the databases that
must be log shipped.
- Click OK.
REFERENCESFor more information about how to set up log shipping, visit
the following Microsoft Web site: http://support.microsoft.com/support/sql/content/2000papers/LogShippingFinal.asp For additional information, click the following article
numbers to view the articles in the Microsoft Knowledge Base: 314515
INF: Frequently Asked Questions - SQL Server 2000 - Log
Shipping
810969 FIX: Log Shipping with SQL Server Authentication Generates Backup and "Out of Sync" Threshold Alerts
Modification Type: | Minor | Last Reviewed: | 4/30/2003 |
---|
Keywords: | kberrmsg kbSysAdmin kbprb KB811890 kbAudDeveloper |
---|
|