Post reply

log shipping

  • April 9, 2008 at 3:53 am

    #121236

    hello all,

    is it necessary to have the sqlserver as well as sqlagent services on all the servers involved in log shipping to run under the same account with same password. or there is another way to configure log shipping with different accounts.

    thank you.

  • April 9, 2008 at 7:39 am

    #800387

    It is not necessary that you same svc a/c and password for the both servers, but be note this point.....

    1) Svc a/c should be part of SA permission no login permission on the service a/c (It means with that svc a/c no one can login into the box or sql server).

    2) Svc a/c of both the servers needs to add in correspond server.

    Ex....

    Server1 Server2

    SVC1 SVC2

    Add SVC2 into server1 and add SVC1 in Server2.

    Hopefully you understand.

    Manoj

    Manoj

    MCP, MCTS (GDBA/EDA)

  • April 9, 2008 at 10:08 pm

    #800750

    Thanks for ur reply.

    i want to know that if the servers are on different domain then how can we configure log shipping.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply