SQL 2K Log Shipping

Last Post 04 May 2010 05:31 AM by mddba. 3 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages Not Resolved
mddba
New Member
New Member

--
03 May 2010 12:55 PM

Hello,

I am trying to set up log shipping from a SQL 2K EE cluster to a stand alone EE instance.  I run through the Maint. Plan and the job is created without error.  I am having the wizard take a new full to restore on the target server. 

I'm experiencing two odd issues.  The first is that I select No Recovery but the target is restored as Read Only.  The second issue is that log backups are created but never copied to the target server.  No errors are thrown.

I've set up log shipping in SQL 2K before without issue.

Any assistance is appreciated.

thanks,

rm
New Member
New Member

--
04 May 2010 03:48 AM
What's sql agent service account? Does it have permission to access log backup files on remote site?
mddba
New Member
New Member

--
04 May 2010 05:30 AM
I'm an idiot.  I realized last night when I laid down that I didn't check the SQL Agent on the target server.  You nailed it!  Good work and thanks.
mddba
New Member
New Member

--
04 May 2010 05:31 AM
SQL Agent wasn't started on the target was the problem. The service accounts did have proper permissions. Again, thanks.


Acceptable Use Policy
---