473,397 Members | 1,950 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,397 software developers and data experts.

Need help in log shipping

I am attempting to set up log shipping from my primary dell clustered 2
node sql server to a backup quad xeon server in case of a failure. When I
follow the information given from Microsoft regarding this and I get to
the point where I am at "Add Destination Database" I am being prompted
for my server name, which shows the primary one ONLY. I dont seem to find
any documentation on where I add in the secondary server name...
Searching online has yielded no responses for me and MS only says to
register the servers... but where? and do I need to restart? I am only
trying to be extra cautious as this is a live database.

Thank you in advance for your help...

Jul 23 '05 #1
5 1220
I'm not familiar with that screen myself, but based on the description
in Books Online, I would guess it means that the server must be
registered in Enterprise Manager. If it is registered already, then is
it also Enterprise Edition (that's the other requirement mentioned in
the docs)?

Simon

Jul 23 '05 #2
I am not following that exact part... it mentions to register the server, I
am not picking up on WHERE to register it...

Jul 23 '05 #3
I am not following that exact part... it mentions to register the server, I
am not picking up on WHERE to register it...

Jul 23 '05 #4
Sorry for the accidental double post but I almost forgot -- yes it is the
enterprise edition :)

Jul 23 '05 #5
smyers1972 (sm****@nospam.tuscanylasvegas.com) writes:
I am not following that exact part... it mentions to register the
server, I am not picking up on WHERE to register it...


I have never used the dialog in question, but I would read it as
"register in Enterprise Manager". Right-click in the left-hand side
of the tree in EM.
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp
Jul 23 '05 #6

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Tim Groulx | last post by:
Hello, I am setting up log shipping between two SQL servers. Everything in the setup seems to work fine. The problem I am having is that the "Log Shipping Alert Job - Backup" job is failing,...
4
by: Jason Huang | last post by:
Hi, In the MS SQL 2000 Server, if the log shipping is set up right, does that mean data in primary server changed will mapped to secondary server later on? Thanks. Jason
10
by: Howard Martin | last post by:
I have a form at http://www.develop.check.com.au/hh/order.html where an extended sub-total and then a grand total is calculated as soon as a quantity is input by a user. I would like to be able to...
2
by: Outlaw | last post by:
The Fast Freight Shipping Company charges the rates listed in the following table: Weight of the Package (in kilograms) / Shipping rate per Mile 2kg or less / $0.01 over 2kg, but not more than...
2
by: webspinster | last post by:
Okay, guys, if it seems I don't know a whole lot it's because I don't. I create and edit websites using Hot Dog Pro and have done very rudamentary HTML language on my own. Here's my challenge. I...
4
by: wellscrambled | last post by:
Folks, Probably don't have the right forum here, but this is all a bit new to me. I have a web site that sends me a daily email with an excel spreadsheet attachment that contains some customer...
3
by: Yonih | last post by:
Hey Everyone, I was hoping someone could help me here. I need a way to have a drop down that when selected it can keep a value and display it below here is an example. A drop down list of...
4
by: aprillynn82 | last post by:
I can not seem to get the code correct to calculate shipping charges based on weight and distance. The info is: Weight of the Package (in kilograms) / Shipping rate per Mile 2kg or less / $0.01...
12
by: brossyg | last post by:
I have a very simple price times quantity calculation. The input is STWCORQuant: <input name="STWCORQuant" class="contactitalicbold" id="STWCORQuant" onChange="javascript:STWCORPrice();"...
3
by: brossyg | last post by:
I have a function that calculates price when the user inputs a quantity that works perfectly. Here it is: function STWCORPrice() { var price = 0; var shipping = 0; var total=0; var...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.