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?
Copyright License：
Author:「Simon Novak」,Reproduced under the CC 4.0 BY-SA copyright license with link to original source & disclaimer.
Link to：https://stackoverflow.com/questions/30005932/database-mirroring-for-report-database
About “Database mirroring for report database” questions
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
|
I have created a SSRS report (SQL Server 2005), however on running it I receive an error that a view doesn't exist on the mirrored database (I haven't dealt with mirroring before). What happens is ...
|
We have ERP application that store the data to ORACLE database. And also we have a lot of another application that use the ERP database. Same database but different instances. We got the performance
|
I'm not a DBA but I hear that database mirroring is deprecated or about to be, I'm using SQL 2014, in my company they are using database mirroring, which is exactly the new version? it is something...
|
We are using ERP application that stores data to ORACLE database and also we have web applications that uses the same ERP database. We are getting the performance issues when ERP and another applic...
|
I have setup both mirroring and and log shipping on 8 databases of about 10 GB each size on same instance, but now when I want to mirror another database it very long to display the Database Proper...
|
I'm trying to set a database to single user mode that is currently in an availability group or in a mirroring session. But i'm getting the following error:
The operation cannot be performed on data...
|
I've been reading about database mirroring on SQL Server 2008 R2 / 2012 and I have a question: does it matter if the database being mirrored is live? Do I have to do anything special or different i...
|
"It is better to use UNIQUEIDENTIFIER type in tables when you use database mirroring" - is it myth?
What may be a reason to use unique primary key for mirroring purpose (single database mirroring ...
|
You have two servers when you perform a SQL Server database mirroring
You have 1 primary database and 1 mirror database
Do you need to make any changes to web application to tell it that your using
|
|
|