The database-mirroring tag has no wiki summary.
0
votes
2answers
61 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
46 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
36 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
57 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
57 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
88 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
194 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 ...
3
votes
1answer
85 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
87 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
101 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
61 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
267 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 ...
2
votes
1answer
91 views
tempdb thrashing and mirroring permissions (SQL Server)
We have a client site that uses SQL Server. The site this morning was slow, and we realised that the primary database server was responsible for a lot of disk activity on tempdb (Server 2008, SQL ...
6
votes
3answers
594 views
SQL Server 2008 mirrored Database with manual failover, need reporting database
Our current setup is a principal database used in production with a manual failover mirrored database for HA.
I need to setup a reporting database as well. What would be the best approach? Shall I ...
2
votes
1answer
61 views
Response On Database Failover
Let say, that I have principal server named P, and mirror server named M. I've got 7 databases that are in server P, and 7 mirror databases on server M. Whole engine works fine when we are talking ...
4
votes
1answer
101 views
SQL Server Mirroring kicks in before cluster has time to fail over
I have two clusters each with two nodes configured in active/passive; the two clusters take part in a high-availability mirroring session using a separate server as the witness.
When a node fails in ...
9
votes
3answers
3k views
What can cause a mirroring session to timeout then failover? SQL Server 2005
We have two production SQL Servers running SQL Server 2005 SP4 with cumulative update 3. Both servers run on physical machines that are identical. DELL PowerEdge R815 with 4 x 12 core CPUs and 512GB ...
3
votes
1answer
484 views
Version of Witness Server for mirroring SQL 2012
Can I use SQL 2008 R2 as a Witness Server for 2 instances of SQL 2012 Servers being mirrored?
