Data replication issues: Thanks Paul

Paul,
Thanks for your reply. My distribution agents schedule is
set to run at 7:00 am everyday (similar to my snapshot
agent). I found that the distribution agent gave me an
error and the details are as follows:
Error msg: The process could not access
database 'LETS30_Repl' on server 'FTANT001'
Error details: Could not locate entry in sysdatabases for
database 'LETS30_Repl'. No entry found with that name.
make sure that the name is entered correctly. [SOurce:
FTANT001(Data Source): Error Number:911]
One interesting thing to note is even though I had created
the database 'LETS30_Repl' it does not show up
under 'Databases' in the server. Why is it so? Thanks,
Cheers,
Sabuj

>Sabuj,
>what is the distribution agent's schedule? My guess is
>that it hasn't
>matched its schedule time yet. Try running it manually to
>check that
>everything is OK.
>HTH,
>Paul Ibison
Sabuj,
can you query the sysdatabases table on the subscriber (FTANT001) to verify
if it is there:
select * from master.dbo.sysdatabases
Or alternatively just run sp_helpdb.
If it is not there then recreating it should allow the distribution agent to
succeed.
Regards,
Paul Ibison