Database mirroring a live database
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 if my database is live?
EDIT-1:
- I have a (one) database on premises that's our production database. A few hundreds transactions happens per second, and 99.999% are read operations. Our plan is to mirror this database (single database) to SQL Azure (IaaS) as a "backup" structure, if the on premises environment crash for any reason, we just point to the cloud.
- I would like a zero loss, but I settle for a 5 seconds loss
- Latency wont be a problem... slow running is better than no running...
- I have just one node and one database
Copyright License：
Author:「Leonardo」,Reproduced under the CC 4.0 BY-SA copyright license with link to original source & disclaimer.
Link to：https://stackoverflow.com/questions/16925971/database-mirroring-a-live-database
About “Database mirroring a live database” questions
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...
|
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'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...
|
Microsoft SQL Server 2005 principal is down (Database live server is down because of abruptly interrupted) and found that the mirror DB server is running and up. They are configured on different ip
|
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...
|
"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
|
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 ...
|
|
|