September 19, 2006 at 3:10 pm
Hi All,
I am pretty sure this is a very dumb question, but I will ask any way. I am currently using log shipping for a passive standby server. The main sql2k5 is at the branch office being log shipped back to corporate. Company wants to bring up another sql2k5 server for the development environment. I know I can log ship to multiple servers.
Is there anything special I need to do for the dev sql2k5 server? They need to be able to make changes and run queries, and anything else they might want to do. They can trash the database as far as I am concerned, but they need access to fairly realtime data.
The dev sql2k5 will be at the corp office. The live server is in a branch office connected via a T1. Is there a better solution to what I am doing?
Thank you, for your help in advance.
September 19, 2006 at 7:50 pm
Firstly, no question is considered 'dumb' in this forum - we are all here to learn, and asking questions is the best way to do it!
Secondly, it depends on your developers - how current should the database be and also the number and size(s) of the databases. In my environment, I have a weekly full-backup, daily diff-backups and transaction log backups every 15 minutes. Since everything is automated, it is quite easy for me to simply restore the required databases each morning (as close to the diff backups as possible). This strategy would mean that the developers would have to re-execute their scripts (eg. stored procs) each morning since the database would be overwritten daily!
Another approach would be to use transactional replication to replicate the databases to the development server. This would mean that the data would always be current and the users can continue their work without worrying about the databases being overwritten! However, this also introduces replication complexity into your production server - not a nice setup!
As I understand it, using Log Shipping will put your databases in 'restoring' mode, which means that users won't be able to use it until the databases are fully recovered!
There are alternative approaches that others might share with you. Good luck!
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply