SQL 2K Log Shipping

Last Post 04 May 2010 06:31 AM by mddba. 3 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages Not Resolved
mddba
New Member
New Member

--
03 May 2010 01: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 04: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 06: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 06:31 AM
SQL Agent wasn't started on the target was the problem. The service accounts did have proper permissions. Again, thanks.
You are not authorized to post a reply.

Acceptable Use Policy