Hi All,
I’m hoping somebody can help me out. I’ve got a reservation system in 15 stores, each with its own database and server, and a master database in our corporate office, all running Sql Server 2000, sp3. The master database is used mainly as a replication source for guest info. Replication between the master and all store server is working correctly.
There are maintenance plans running on each server to back up the database and transaction logs. I’d like to get them writing to the Maintenance Plan History tables on the master server so I can run one daily report off it to see if there are any problems. The Sql Server Agent is running as a Domain Power User set up as as a SQL system admin. The plans are running fine locally. My problem is that only 3 of the 15 servers are writing to the master database. The plan setups are identical except for the local backup folder, and they’re all running as the same domain user. The plan histories on each server have no errors, and the Sql Server Agent and Error logs don’t show any problems.
Does anyone have an idea on a next step for troubleshooting this? At first I thought it may be a permission problem, but don’t understand why would it work from a few stores and not others.
Thanks,
Pat
I’m hoping somebody can help me out. I’ve got a reservation system in 15 stores, each with its own database and server, and a master database in our corporate office, all running Sql Server 2000, sp3. The master database is used mainly as a replication source for guest info. Replication between the master and all store server is working correctly.
There are maintenance plans running on each server to back up the database and transaction logs. I’d like to get them writing to the Maintenance Plan History tables on the master server so I can run one daily report off it to see if there are any problems. The Sql Server Agent is running as a Domain Power User set up as as a SQL system admin. The plans are running fine locally. My problem is that only 3 of the 15 servers are writing to the master database. The plan setups are identical except for the local backup folder, and they’re all running as the same domain user. The plan histories on each server have no errors, and the Sql Server Agent and Error logs don’t show any problems.
Does anyone have an idea on a next step for troubleshooting this? At first I thought it may be a permission problem, but don’t understand why would it work from a few stores and not others.
Thanks,
Pat
