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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-05-13 : 01:49:56
|
| Rob writes "Is it possible to run a job on a linked server from another job?We currently backup all SQL databases once daily and copy the backup files to a remote server. The databases are then restored on the remote server and DBCC checks are run. We backup transaction logs at varying times depending on the database activity and it would be nice if we could then restore these logs to the previously restored databases. Log shipping would be suitable if we were not backing up and restoring the system db's as well i.e msdb!Do you guy's know if I can start jobs on the remote server from the jobs that complete the backups?Or would you have any other suggestions for completing the above process? Regards" |
|
|
|
|
|
SQL Jobs