June 25, 2013 at 6:47 pm
Hi,
I have a database of 200 GB. I need to replicate this db to 5 different servers and make them online?
Is Transactional replication only my option? WIth such a huge DB, and replicating all the tables, I am not
sure how the performance would be. DO I have anyother option? LogShipping or DBMirroing would work?
June 25, 2013 at 9:14 pm
It depends what you plan to use the secondary instances for.
Selecting a High Availability Solution: http://msdn.microsoft.com/en-us/library/bb510414%28v=sql.105%29.aspx
Replication will work, performance depends on the number of transactions, but there are performance improvements that can be done like replicating stored procedure execution rather than individual statements and adjusting the batch threshold. The slowest part will be generating the snapshot and applying it to each subscriber, but you only do that once.
June 25, 2013 at 9:29 pm
Instead of generating a snapshot, you could use a database backup. You can initialise a subscription using a backup instead of a snapshot.
If you need to have the replicas online and useable, database mirroring is probably not going to work. The mirror not available for use until the primary goes off line. You could use a snapshot (subject to the edition of SQL you are using) but that is at a point in time and no new data will appear in the snapshot.
Log shipping might be an option. However, whenever a log is being restored, no one can have access to the database. So, this might not be a good option for you.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply