Ok here is the mess...
I have a production server on the web that handles no more than 1500 transactions per day.
I have a mirror of that server at the office.
Without using replication....
Keep them in sync.
Here is what I have done so far.
webSQL -> SQL2000
offSQL -> SQL2000
webSQL create a transaction log backup and FTP it to offSQL
execute a stored proc on offSQL to restore the trn file
All is working up until I issue...
RESTORE LOG [db_office] FROM
DISK = N'E:\FTP_ROOT\DBBU\web_08022007_110743_LOG_bu.trn'
I get the following...
Server: Msg 4306, Level 16, State 1, Line 1
The preceding restore operation did not specify WITH NORECOVERY or WITH STANDBY. Restart the restore sequence, specifying WITH NORECOVERY or WITH STANDBY for all but the final step.
Server: Msg 3013, Level 16, State 1, Line 1
RESTORE LOG is terminating abnormally.
Now I have a migraine and a dent in the wall.
I would like to issue the command