SQL SERVER 2000 Log Shipping

[AndyLord]

I have download MS Whitepaper - How to Setup Log Shipping, which seems straight forward enough. However when my Log Shipping, created as outlined in the whitepaper using Database Maintenance Plan Wizard, I get the following error after a full backup has takeb place.

SQL Server Enterprise Manager
Unable to copy the initialization file to the secondary server 'PICARD'

I have made sure that both servers have network shares.

Can anyone help with this, as I'm not the world greatest SQL Admin, basically thrown in at the deep enda s it were.

Cheers in advance

 

[Corran007]

have you tried manually doing the restore but leaving it in able to have more logs appied mode. i know when i did it useing the built in log shipping i did that instead

 

[mrdenny]

Ditch the Microsoft log shipping. Write your own. It's much easier. See my FAQ faq962-5754.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

(My very old site)

 

[kishy]

Make sure you have the proper access and rights on the folders you are copying your backup files to.
It should make you to move forward.

--Kishore