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 |
|
sql2005dba
Starting Member
8 Posts |
 Posted - 2011-06-08 : 13:40:53
|
| Hello All,I need to set up sql server 2000 log shipping between two servers. I just set up the maintenence plan from scratch. All the jobs were created on source and destination servers. Copy job on Destination shows successful but is not copying the new transaction files.I see same question asked many times online but cannot find appropriate solution. Can someone pls help ?!! |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
sql2005dba
Starting Member
8 Posts |
Posted - 2011-06-08 : 15:44:12
|
| Thank you Tara. The sql server service account has admin rights on both servers.Can you please suggest me a way to test if SQL Server service account can read/write to a path ? Also , I need to do this check on log shipping destination sql server right? |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
sql2005dba
Starting Member
8 Posts |
Posted - 2011-06-08 : 16:16:21
|
| Here is the whole scenario:There are 3 servers in picture A, B, C . These are in same domain.B used to be a Log Shipping source for C. Both sql servers run under same service account lets say sa1. Now we have a new server A . We want A to be the Log Shipping source for destinations B and C . Sql server on A runs under different service account sa2. Log Shipping is established between A and B successfully with A as source . Now I want to add C as a destination to the already established Log Shipping . I added C as destination but copy job didn’t work on C . It shows successful but doesn’t copy . Now I deleted everything from all three servers related to this maintenence plan and created a new maintenence plan for Log Shipping from A to C . Copy job still don’t work. So there must be something missing between server A and C.I don’t have password for service accounts so cannot test them personally for file read write .But the windows administrator says that these accounts have admin rights on both servers. Is there anything else that I can do in this situation??It is very thoughtful of you to read and analyze my problem. Thanks for that! |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Log Shipping Copy Job successful but does not copy