April 30th, 2007
Since Peer Software released their latest product, Peer DRS, in mid-April we’ve had numerous questions asking what DRS is all about and what it can do to help protect a company’s SQL Servers. After all, SQL Server has its own replication so why would you want Peer DRS. In this respect the answer is very simple; if you want SQL Server replication you need enterprise licenses and these don’t come cheap. If you’re a large firm then the extra cost may not be a issue, but for smaller firms the higher initial and on-going costs hurt budgets, and year on year.
We’re asked almost every week; I need a solution so I can have two databases at two locations. From the remote site users only need to read their local copy of the database, no updates. Prior to Peer DRS the only solution was get yourself some enterprise licenses. Not now. One way of running Peer DRS allows you to distribute your data and make it available read only. How up to date would you like that other copy? Up to the last minute be OK? Now you can run your reports against the copy and save network bandwidth.
The number of different ways that you can use Peer DRS is quite stunning:
- One-to-One Standby Replication
- Many-to-One Standby Replication
- One-to-Many Standby Replication
- One-to-One File Copy
- One-to-One File Copy Multiple Location
- Clone to same server