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 - 2006-10-05 : 08:01:53
|
| Slayer writes "I have two SQL Jobs, one that backs up a database and one the transaction logs. The jobs include a second step that uses xp_cmdshell to call robocopy to copy the jobs to a remote server. What I want to do is create a third job step that will restore the database and logs on the remote server in Standby mode. I have no linked servers at present and am running SQL 2000 Standard edition.Can you offer any advise on how to go about this." |
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2006-10-05 : 08:29:39
|
| I have done something similar a while back and I had a separate job running on the standby-server that picked up the fresh transfers and did a restore. Pretty simple but I had a separate process running on the standby...the restore wasn't initiated from the prod-server.--Lumbago"Real programmers don't document, if it was hard to write it should be hard to understand" |
 |
|
|
|
|
|
Remote Restore