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 |
|
socaltenor
Starting Member
3 Posts |
 Posted - 2009-08-05 : 22:57:23
|
| I have been able to set up log shipping from the designated primary server and been able to successfully initialize the maintenance plan on the secondary. There is a read-only version of the db on the secondary server. The log is backed up locally, but it is never copied to the destination server. The sql server agent service uses the administrator account, which is not an AD account (non-AD environment) but the administrator password is the same on the destination server as on the primary server. Why wouldn't the copy be happening?The servers in the plan both have SQL Server 2000 installed with same SP. |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-08-07 : 22:23:48
|
| What Error is it giving? |
 |
|
|
socaltenor
Starting Member
3 Posts |
Posted - 2009-08-07 : 22:28:58
|
| I am just seeing the standard out-of-sync error. Those errors don't give any info. I even ran a packet capture on both servers to see what dialogue I could see. I see standard SMB/NetBIOS traffic between the two but no attempt to copy the .trn. It's as if the primary isn't even trying to offload the log file to the secondary. Why would that be? Is there additional set up required on secondary server? |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-08-07 : 22:30:53
|
| Did you create FileShare with All Permission in secondary server? |
|
|
|
socaltenor
Starting Member
3 Posts |
Posted - 2009-08-07 : 22:43:39
|
| Absolutely...and I basically have pass through authentication where sqlserveragent service runs on the same non-domain user account with same password on both servers. Permissions are set to allow everyone full access. So...it's wide open. Basically, sqlserveragent is logging on as local administrator...and it has been verified that when I log in via RDP, and from same directory where .trn's are copied locally, I can copy files to the secondary destination directory. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-08-07 : 22:54:25
|
| Check the owner of jobs for replications. |
|
|
|
|
|
|
log shipping woes