October 16, 2012 at 12:18 pm
Hello, I am looking for a third party solution that can provide me with a replicated database for reporting. The main database is currently running SQL Server 2005, soon to be 2012. It is about 1.5 TB in size and heavily transaction based. SQL Server snapshot and Transaction log replication will not work for us mainly due to the size, volume of data inserts and updates and many of the tables do not have primary keys on them. This is not something we can change. Are there any third party tools that can replicate a large data base on a nightly bases in a very short time frame. SAN snapshot cloning is also not an option with our current SAN. Thank you,
David
October 16, 2012 at 1:06 pm
Depending on your goals for the replication, there are a couple of products you can look at.
If you are looking at almost instance recovery from disaster then Red Gate (red-gate.com) has SQL Virtual Restore and Quest Software (quest.com, now owned by Dell) has NetVault FastRecover.
If you are looking for continuous, real-time replication with failover then Quest Software offers NetVault Replicator. Not positive if Red Gate has anything similar.
These may not be exactly what you are looking for, but all are worth checking out if you are having trouble finding a solution.
October 16, 2012 at 2:52 pm
Litespeed is a good backup tool
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply