Zieglers

Just little about C#, .NET, SQL Server, SharePoint and SAP

Logshipping

Posted by zieglers on May 10, 2006

I wanted to share my experiences just after configuring on a single server with two instances. I used to have problems with logshipping at the phase of restore job on the standby instance. The problem was service account of SQL Server Agent running on the standby server. In order to provide a good and clear demonstration, I set up two instances on a single server rather than setting up two distinct servers with one instance on each. Doing so, I was able to overcome the difficulties and problems due to permissions related with SQL Server Agent. Simply, both agent services were running with local system account. So, it worked! That way, I was also able to prevent the need of installing an additional server or a domain.

Advertisements

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: