I'm new to DB admin but learning fast. We have a large SQL Server 2008 setup and I've just implemented a three-stage testing system - Alpha, Beta and Live servers. All three run the same version of SQL Server (though Alpha is x86 while the others are x64).
As Alpha is our it'll-probably-break test machine the data doesn't have to be up-to-date, but I'd like to set up Beta to be as close to Live as possible for obvious reasons, for example pulling new data from Live every hour or similar. I've investigated Replication and set up Transactional from Beta to Alpha (I will not touch Live until I know it works), but performing transactions (selects and inserts) on Beta didn't filter back to Alpha, so I'm not sure if I've set it up properly. It goes without saying that data should only be flowing one way, Live -> Beta (and ideally Beta -> Alpha, something like daily at midnight).
Can someone point me to a tutorial on setting up such a system, or help me set the system up?
Any help much appreciated!
Cheers,
Gargravarr
Here is the Microsoft up to date MSDN article on Log Shipping. http://msdn.microsoft.com/en-us/library/ms187103.aspx
Read over the Secondary Server section of the article I think that will help point you in the right direction.
You have mentioned you don't want all of the data to be exact replicas? Because if that is not the case then I would recommend using Database Mirroring from within SQL rather then transactional replication.