Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Richard101
Starting Member
30 Posts |
 Posted - 2008-12-05 : 09:07:44
|
| Hi All, I'm trying to setup log-shipping between a primary-cluster and a newly built secondary for DR.I'm following a white paper and beleive I've done all the preperation. However I'm stuck in the wizard where I click the 'Add' button to add a secondary. the secondary-server dialog-box top field in called 'server name', however, on expansion the only name I can pick is the primary.I have registered the secondary in EM on the primary. I can ping both ways between the primary and secondary. And both use the same domain account to run their sql-services.Primary is sql2000 sp4 enterpriseSecondary is sql2000 sp4 standard... and just when I was beginning to think I knew this stuff :-) |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-12-05 : 09:37:38
|
| Use secondary servername in add destination database in 2000 |
 |
|
|
Richard101
Starting Member
30 Posts |
Posted - 2008-12-05 : 16:32:09
|
| Thanks again, so deep, I found I cannot use the wizard with a std edition secondary. I need to read-up on 'simple log shipping'. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-12-05 : 16:50:00
|
| SQl 2000 supports only Enterprise edition for Log shiping but 2005 supports in Std edition too. |
|
|
|
|
|
|
log-ship cannot name secondary