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 |
|
dewacorp.alliances
452 Posts |
 Posted - 2006-08-12 : 15:45:30
|
| Hi there. I am trying to run database shipping from one server to another through a normal backup and restore TSQL. So first of all, there is linked server between PRIMARY_SERVER to STANDBY_SERVER. Also, there is a restore stored procedure in the master database in the STANDBY_SERVER. And for the job itself, there is a job that run from MASTER_SERVER that containing following steps: 1. BACKUP_to_local_disk 2. RESTORE_REMOTE_STORED_PROCEDURE_STEP (this will execute a remote stored procedure in master db on STANDBY_SERVER). The backup step is fine butthe restore is not. I realise what wrong with it. So My question is actually, on the STANDBY_SERVER, the database that needs to be restored is in "LOADING" state. I check the Process Info both MASTER_SERVER and SECONDARY_SERVER and nothing is related on this process. ?!?!Correct if I am wrong if you execute a remote call for RESTORE for instance. The process should kick in the remote server (STANDYBY_SERVER), shouldn't it? I believe this will be under msdb .. or master database (running the process under)?Thanks |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-08-13 : 21:16:43
|
| post the restore script, check the recovery option--------------------keeping it simple... |
 |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
|
|
|
|
|
Restoring and Process Info activity - SQL2000 SP3a