The database-mirroring tag has no wiki summary.
6
votes
2answers
127 views
If I fail over one database, do the others that share the same mirror endpoint fail over as well?
We have two databases setup for mirroring on a single SQL Server instance: a test database and a production database. Both get mirrored to another server using the exact same endpoints.
If I go into ...
3
votes
0answers
30 views
Database mirroring - worked once?
I setup SQL Server 2012 Standard on 2 different servers and installed SQL Server 2012 Express on a Witness server. All 3 servers are running Server Enterprise 2008 R2.
I'm using these instructions:
...
6
votes
1answer
77 views
Can I shrink the transaction log file on a mirror database?
This is a followup question to a previous question about why I couldn't shrink the log file on the principal database.
To make a long story short, I setup database mirroring but forgot to make sure ...
0
votes
2answers
67 views
which sql server edition is good for practice [closed]
Which SQL Server (free/trail) would be good to install, which requires minimum resource and have maximum features. I mean, I can practice mirroring,logshipping and replication. I found this link, but ...
0
votes
2answers
50 views
Can I use replication/mirroring to have a “Current” database and a “Full History” copy?
I have a database that is used for current operations. The amount of data is starting to get a bit to much for the applications using it.
Most of the data is older and is very rarely needed.
I am ...
5
votes
2answers
44 views
Retrieving cached plans fails due to cached objects of database Mirror
I'm trying to retrieve cached execution plans for a specific database object, but this fails because of cached plans which belong to a mirrored database in MIRROR state.
The below query, without any ...
1
vote
1answer
90 views
SQL Server 2008 R2 database mirroring - is it possible to have a slave server for multiple master servers?
Scenario is that I have two servers running SQL Server 2008 R2 (64-bit), let's call them DB1 and DB2. I have set up database mirroring for all the databases on these servers so that DB1 is the ...
0
votes
3answers
77 views
How to check if database is in mirrored mode?
I have two database servers A and B where I have databases set up in mirroring namely X. There is another database on server A named Y which is only present on database server A. Y database has a ...
2
votes
0answers
105 views
SQL Server Database Hot Backups: Which Technique(s) to Use for Multi-Level Replication?
I'm reading the many other posts here about mirroring vs. replication, but I'd still appreciate it if someone with some experience would weigh in.
My small development team needs to have local ...
4
votes
2answers
290 views
Manually moving SQL instance to another node causes immediate database mirror failover
I have a two-node SQL cluster (2008 R2).
Some of the databases within that SQL instance are mirrored to another server on a remote site, using the High safety with automatic failover. The mirroring ...
4
votes
1answer
107 views
Transaction Log maintenance on Mirror database
SQL Server Version: 2008 R2 Enterprise SP2
I am trying to get a handle on our SQL Server maintenance and I came across something I think is incorrect. We have a single production instance with 3 ...
2
votes
2answers
118 views
Database mirroring - link failure between principal and witness
I am using synchronous database mirroring with a witness and am testing the various failure scenarios and the impact on the mirroring session, such as whether failover occurs.
Starting with the ...
3
votes
3answers
107 views
SQL Server Database Synchronization
I have a database in a server in Africa, and need a daily sync\restore to a server in Europe.
My first idea was to sync the data between the 2 databases, but the database has more than 1000 tables, ...
2
votes
1answer
64 views
can you run sql server 2005 and sql server 2008 r2 in mirror mode?
Must all db servers be running the exact same version to enable mirroring without a witness server? How about with a witness server in place?
4
votes
3answers
341 views
How can I inspect the security settings of a SQL Server Endpoint?
I am in the process of creating a TEST environment for our SQL Server development staff.
In production we have 3 SQL Servers, SQL01 contains several databases that are mirrored to SQL02. SQL03 ...
