I am working on a problem of replication from Spain to UK and this article makes interesting reading...thanks go to the author

Derek: If you want a perfect copy of the database you should try "Log-Shipping".

Pro: perfect copy of your database is maintained on your archive server, including all schema changes + data.

Con: the archive database must be in ReadOnly mode (but isn't that the idea of an archive anyway?)

If you don;t want to pay for the Enterprise version of SQL2k then there is a DIY solution contained in MS Back Office Resource Kit v4.5...I have been using this to maintain a DR copy of our DB's here in the UK for over 6 months now without a glitch.

😉