Troubleshooting guide

isql –Usa –Psa_pass –Smyra
7.
If your resource file has initialize_instance set to no, initialize the primary data server and
the Replication Agent instance:
a) Open a command window, and log in to the Replication Agent instance.
b) Issue this command to create server xlog objects:
server_xlog init
c) Issue this command to shutdown Replication Agent:
shutdown
8.
Stop the Microsoft SQL Server in single-user mode:
a) Log in to the server:
"C:\Program Files\Microsoft SQL Server\90\Tools\Binn
\SQLCMD.EXE" -U username -P password -S serverName
where
username , password , and serverName are your user ID, password, and
Microsoft SQL Server name.
b) Issue the
shutdown
command.
9.
Restart Microsoft SQL Server in multiuser mode (normal start):
a)
In Control Panel > Administrative Tools > Services, find the service named
Microsoft SQL Server (
SERVER ), where SERVER is the name of your Microsoft SQL
Server data server. For example:
Microsoft SQL Server(TEAMSTER)
b) Start the service.
10.
Restart Replication Agent.
a) Change to the SYBASE directory and start the Replication Agent instance:
cd %SYBASE%\RAX-15_5\myra
b) Execute the RUN file, for example:
RUN_myra
11.
Initialize Replication Agent.
a) Log in to Replication Agent using isql:
isql –Usa –P –Smyra
where myra is the name of Replication Agent.
b) Issue:
ra_admin init
The Replication Agent instance is now running, and the primary data server and the
Replication Agent instance have been initialized.
CHAPTER 5: Microsoft SQL Server-to-SAP HANA Database Replication Setup
Quick Start Guide for SAP HANA Database 71