Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-04-23 : 07:47:50
|
| Volkan writes "I've set up logshipping between two domain computers and it works without any problems. The destination server will be taken off site, removed from the domain and put into a workgroup. I tried this scenario but the copy job fails to reach the log files, so the logshipping is broken. How can I modify the copy job to reach to the network share folder and copy these log files?" |
|
|
efelito
Constraint Violating Yak Guru
478 Posts |
Posted - 2003-04-23 : 12:15:18
|
| I'm not sure what security context the log shipping process runs under. I believe its the MSSQLServer service account. You might be able to get it working by setting the user name and password to the same thing on both servers. Server1 MSSQLServer Login: SQLServerAccount Password: 123456Server2 MSSQLServer Login: SQLServerAccount Password: 123456You might get the copy job to work under these conditions. As long as the server doing the copy still has the ability to resolve the name of the other server to an IP address.HTHJeff Banschbach, MCDBA |
 |
|
|
|
|
|
logshipping between a domain and a wrkgrp computer