Poor mans Log shipping over the internet?

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'
 WITH  NORECOVERY

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.

Any suggestions?

I would like to issue the command

WITH RECOVERY
LVL 2
cpctechAsked:
Who is Participating?
 
mastooConnect With a Mentor Commented:
When you do the initial full backup restore, you use norecovery (or standby).  Then subsequent log backups get shipped and applied by restoring them with norecovery (or standby).  It isn't until you need to start using the log shipping destination database for real that you issue the "with recovery" at which point you can't ship any more logs to it without starting over from the initial backup.
0
 
ptjcbConnect With a Mentor Commented:
Is db_office in Full recovery model?

0
 
cpctechAuthor Commented:
Breakdown of the points awarded and why

ptjcb
  No it was not, thanks for reminding me

mastoo
 What you stated
"with recovery" at which point you can't ship any more logs to it without starting over from the initial backup.

will kill the though process

The database is 36 gig and would take far too long

So I went with triggers behind the tables that create SQL scripts (insert, update, delete) and placed the SQL statements in another table in the DB. then I have a .NET command line tool that will open the list of sql statments and execute them against the remote server in the order they where executed on the local server.

Kind of a poor mans one way transactional replication...
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.