CODEWITHSUNDEEP
sql-serverdatabase-mirroring
Simon Novak
Simon Novak

Reputation: 95

Database mirroring for report database

I have a problem that our production database is under heavy load. So we have decide that we setup a second SQL server running copy of production database that doesn't need to be 100% uptodate with production database.

After searching I have found that asynchronous mirroring of production database might do the trick. Mirror database would be only read-only for reports and stuff. So I managed to set it up, but have found out that I can't read any data from mirror database because it is in recovery mode.

No I would like to know if my problem is solvable with mirroring or we should use alternative?

Upvotes: 1

Views: 926

Answers (1)

Simon Novak
Simon Novak

Reputation: 95

Thanks to Blim, we have decided for transaction replication. It works great on our development database (so it should in production too).

Step by step article: http://www.sql-server-performance.com/2010/transactional-replication-2008-r2/

Upvotes: 2

Related Questions