| Author |
sigh...log shipping frustrations
|
|
| Tim Greenwood 2006-11-29, 7:13 pm |
| Not sure why I'm not getting this. Everytime I attempt to setup a log
shipping scenario it gives me an error.
My primary servername is gimli.
Secondary is stryder.
Everytime I get an error from msdb.dbo.sp_add_jobserver
'The specified @server_name ('STRYDER2') does not exist.'
What is up with this? It insists on adding a '2' to whatever I specify as
my servername.
This truly must be a bug no?
| |
| Tim Greenwood 2006-11-30, 12:12 am |
| OK and now playing with replication I was setting up STRYDER as a
distributor. It failed saying that STRYDER is already configured as a
distributor. So I started at the beginning of the wizard and told it to use
an existing server and specified STRYDER. ARRGGHH!!
Then it says STRYDER is not configured as a distributor.....is this sounding
like my install is hosed or something? I'm not sure it knows what its own
name is.
@@servername returns STRYDER
Good thing this is my test bed. :)
"Tim Greenwood" <tim_greenwood AT yahoo DOT com> wrote in message
news:uPWhSeBFHHA.4432@TK2MSFTNGP03.phx.gbl...
> Not sure why I'm not getting this. Everytime I attempt to setup a log
> shipping scenario it gives me an error.
>
> My primary servername is gimli.
> Secondary is stryder.
>
> Everytime I get an error from msdb.dbo.sp_add_jobserver
> 'The specified @server_name ('STRYDER2') does not exist.'
>
>
> What is up with this? It insists on adding a '2' to whatever I specify as
> my servername.
> This truly must be a bug no?
>
| |
| Kevin3NF 2006-11-30, 12:12 am |
| reinstall.
:-)
Kevin3NF
"Tim Greenwood" <tim_greenwood AT yahoo DOT com> wrote in message
news:eqS7HzBFHHA.2468@TK2MSFTNGP06.phx.gbl...
> OK and now playing with replication I was setting up STRYDER as a
> distributor. It failed saying that STRYDER is already configured as a
> distributor. So I started at the beginning of the wizard and told it to
> use an existing server and specified STRYDER. ARRGGHH!!
> Then it says STRYDER is not configured as a distributor.....is this
> sounding like my install is hosed or something? I'm not sure it knows
> what its own name is.
>
> @@servername returns STRYDER
>
> Good thing this is my test bed. :)
>
>
>
>
> "Tim Greenwood" <tim_greenwood AT yahoo DOT com> wrote in message
> news:uPWhSeBFHHA.4432@TK2MSFTNGP03.phx.gbl...
>
>
| |
| Tim Greenwood 2006-11-30, 12:12 am |
| Yeah thanks :( :) not the answer I wanted! But that fixed it. Really
freaked me out...I don't get where that came from.
"Kevin3NF" <Kevin@DontSpamMe3NF-inc.com> wrote in message
news:uSv93gCFHHA.5004@TK2MSFTNGP03.phx.gbl...
> reinstall.
>
> :-)
>
> Kevin3NF
>
>
> "Tim Greenwood" <tim_greenwood AT yahoo DOT com> wrote in message
> news:eqS7HzBFHHA.2468@TK2MSFTNGP06.phx.gbl...
>
>
|
|
|
|