Log shipping issue

Hi,
I have tried to set up Log shipping on SQL Server 2000. After I had
successfully finished all the steps the log shipping ran well for about 45
minutes when it got out of sync.
I have deleted all the metadata about logshipping from primary,
secondary and from the monitoring server. (I had to do it from Query Analyze
r
as from EM it wasn`t possible - i suppose something was stucked).
Now all the info about the old log shipping plan is gone. The problem
that I have is that when I try to set up a new log shipping plan, when I
chose the database for which I want to ship logs -> the log shipping checkbo
x
grayes out. If i select first the log shipping checkbox and then the
database, the checkbox also grays out but checked and I`m able to go further
and to set the rest of the options -> at the step at which I am suppose to
chose the secondary server, although it appears in the list, when I select i
t
nothing happens (the selection remains like there is no server selected)
The primary server uses Full Recovery model
I have manually restored all the backups from the primary to the
secondary to bring the secondary db uptodate.
Any ideas?
Thank you
--
Razvan Dragomir,
MCSA / MCSE / MCDB / MCITPI managed to solve the thing with log shipping check box being grayed out -
there was still some info in the log_shipping_databases.
But I still have the problem with the secondary server - i`m not able to
select it in the log shipping wizard. I have also create another test
database and it`s the same. .. looks like I can`t ship on that secondary
server.
All servers are Enterprise edition, having for services same users and
passwords (domain user)
Any ideas?
Thank you
Razvan Dragomir,
MCSA / MCSE / MCDB / MCITP
"Razvan Dragomir" wrote:

> Hi,
> I have tried to set up Log shipping on SQL Server 2000. After I had
> successfully finished all the steps the log shipping ran well for about 45
> minutes when it got out of sync.
> I have deleted all the metadata about logshipping from primary,
> secondary and from the monitoring server. (I had to do it from Query Analy
zer
> as from EM it wasn`t possible - i suppose something was stucked).
> Now all the info about the old log shipping plan is gone. The problem
> that I have is that when I try to set up a new log shipping plan, when I
> chose the database for which I want to ship logs -> the log shipping check
box
> grayes out. If i select first the log shipping checkbox and then the
> database, the checkbox also grays out but checked and I`m able to go furth
er
> and to set the rest of the options -> at the step at which I am suppose to
> chose the secondary server, although it appears in the list, when I select
it
> nothing happens (the selection remains like there is no server selected)
> The primary server uses Full Recovery model
> I have manually restored all the backups from the primary to the
> secondary to bring the secondary db uptodate.
> Any ideas?
> Thank you
> --
> Razvan Dragomir,
> MCSA / MCSE / MCDB / MCITP
>