Friday, March 30, 2012

log shipping will NOT work

I am trying to set up log shipping between some servers. They are in different domain, but there is a two way trust. And I couldn't get it to run inside one domain as well. The SQL agent and SQL server services are running under a domain account that has access to the shares. The jobs actually run but the "last run outcome" remains unknown and the "last run" says never. The error log for these jobs have nothing logged.

Am I missing something here? I have setup and torn this down a million times, and the same thing every time...nothing.

I can also manually backup a log to the Backup share across domains.

Does anyone have a clue what the heck is going on here?

All server are on 9.0.2047.

Thanks,
jason
do you mean to say theres no information in job history ? ? ?.....if the job has run then the sql server agent in either primary or secondary might have been in hanged state........just try to restart the sql server agent and try........anywasys you cud verify if it has run or not by manually logging into the shared folder in primary and see if the tran logs are present........and similarly in secondary check if the tran log files are copied in the secondary servers folder..........else you can check the same in the monitor server which states the recently restored log files in the secondary and the ones which were copied recently and last log file to be backed up in primary|||oh jeez, just a simple restart of the agent did the trick. Thanks for your time.
sql

No comments:

Post a Comment