April 18, 2008 at 3:24 am
hai!
I faced a problem while doing log shipping with maintenance plan wizard in sql server 2000.I could create maintenance plan. In log_shipping_monitor table i found an entry of the monitor server.but there are no entries in log_shipping_primaries and log_shipping_secondaries tables.Full backup and transaction log backups are being created but copying of backup to secondary server is not done.
In the monitor server,under management->log ship monitor ,log ship monitor pair is out of synchronisation.
what could be the reason?
please help me in this regard.
April 21, 2008 at 6:40 am
[font="Courier New"]I hope SQLService account doesn't have privilege to the shared folder. Make sure SQLService account has necessary privilege to the shared folder and make sure sqlagent is running!![/font]
Regards..Vidhya Sagar
SQL-Articles
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply