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 |
|
dlee1964
Starting Member
1 Post |
 Posted - 2012-03-22 : 13:31:55
|
| Hi all:I'm trying to test my understanding of log shipping here. I'm currently trying to get it working on 2 servers for now. After going through the setup, all steps indicate a success. I can see the backup and alerts jobs successfully created on the primary server, but I do not see the copy and restore jobs on the secondary server. Oddly enough, I do see the Adventureworks data files on the secondary server and in SSMS I see it in "(restoring...)" mode on the secondary.I have both instances' sql server service & agent service running under the domain account we have set up for this. I have this domain account set up in the sql user and sql agent groups on both servers. The domain account has sysadmin rights on both servers. The domain account has modify permissions in the copy folder that I've set up on the secondary.What have I overlooked? Again, the problem seems to be with the secondary and specifically the jobs not getting created there.Thanks, |
|
|
alishaali
Starting Member
8 Posts |
Posted - 2012-03-26 : 10:31:52
|
| Hi,What exactly the error message your getting in "activity monitor" on secondary server ....check weather secondary server is registered with the primary server..Check the backup folder is shared completely with all rights on primary server...Make sure you had given correct path to the folder in copy job..... |
 |
|
|
|
|
|
Log Shipping problem setting up secondary jobs