Home Forums SQL Server 2008 SQL Server 2008 High Availability Use the Mirror db for reporting RE: Use the Mirror db for reporting
SQLBuddy123
One Orange Chip
Points: 28294
More actions
March 19, 2014 at 2:57 pm
#1698528
That's not possible. Mirror DB is not accessible as it is. May be dummy test db was primary DB on Server B.
You can't use the Mirror DB directly for reporting. You need to use DB snapshot of the Mirror DB for reporting.
--
SQLBuddy