Manual Log Shipping 2

[paul172]

I've been assigned to administer a SQL server 2000 database. I want to implement a log shipping routine, however I have just noticed that the server is installed with Standard edition. With a bit of digging about I have found that the log shipping wizard isn't available in this version.

Could someone be so kind to point me in the direction of an article/tuturial regarding the manual setup of log shipping.

Thanks in advance.

Paul

 

[nigelrivett]

Just backup the log files to a directory on the source server.
Have a job on the destination which copies the files across and moves the source to an archive directory.
Another step in the same job applies the log files in order and moves them to the archive directory.

Make sure the backups contain the datetime in the name and also that it is a log backup. You can then just put a full backup in the directory and code so that this is restored and any logs after it rather than just the logs.

For a similar thing with imports see

http://www.nigelrivett.net/ImportTextFiles.html

A lot of the file manipulation is done there.

======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

 

[paul172]

Cheers Nigel,

I also found this if anyone else has the same query!

http://www.sql-server-performance.com/sql_server_log_shipping.asp

 

[paul172]

Quick question, why do I need to copy over and restore the full database backup everytime? Why can't I just create the database on the stanby server, restore from full backup once, then start applying transaction logs from then on?