Hi

We have got a SQL server and I need to create a duplicate server with data not older than 30min from the prod server. We need to use this mirror server for backup purposes and reporting purposes. We have only got licences for SQL std edition and not entiprise. I believe I could only use log shipping on Entiprise Edition.

Could anyone give me any ideas on how to go about this? I was thinking of doing a VB app that will mave and restore data on this mirror from the prod server as the log and db backup finish.

Any ideas/advice appreciated.

Regards
Marnus

If your using 2 SQL servers, you need two licences..

You could set up the second one to be a mirror of the primary server, using a number of methods.


Hal Levy
Web Developer, PDI Inc.

NOT a Wiley/Wrox Employee

Hey,

Maybe a Third Party Product? Are you looking to backup the data, or host a web site with two SQL servers, or something like that?

Brian

Sorry i want to comment on Auto Incrementing of Primary Key Select that Category for help

If u don't have a large number of transaction tables in database, would u like to use triggers to update the remote server database.

Log Shipping is best suitable here infact. I am not sure if Replication is available on Std edition.

B. Anant