Questions tagged [mirroring]
For questions about database mirroring - a technology used to create and maintain an exact copy of a database, synchronously or asynchronously.
37
questions
12
votes
2
answers
11k
views
How to create an Event Notification that runs a Job/procedure when mirroring state changes
I'm asking this question in the sequence of this one Can I send a string over TCP using T-SQL?
Remus Rusanu exposes what it seems to be an optimal solution for my problem, but... I'm too immature to ...
- 781
26
votes
2
answers
21k
views
Best way to migrate a huge SQL Server database with low downtime over network
Problem definition
Our database server needs to be transferred to an other datacenter. It runs on Microsoft SQL Server 2012 Enterprise (64-bit) and contains two databases of about 2TB and 1TB.
...
- 363
23
votes
2
answers
24k
views
What can cause a mirroring session to timeout then failover?
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 (...
- 70k
11
votes
2
answers
2k
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 ...
- 8,477
10
votes
2
answers
12k
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 ...
- 175
9
votes
1
answer
17k
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 ...
- 8,477
6
votes
1
answer
2k
views
Transaction log growing on a mirrored principal
I have a pair of SQL Server 2008 R2 servers hosting a synchronously mirrored database with no witness. This weekend, we had to do some network maintenance so I paused the mirroring. Upon resuming, the ...
- 609
4
votes
2
answers
672
views
Impact of deleting 100GB table on Mirroring
I'm about to delete a large table which is approximately 100GB in size. I'd like to understand the impact on the mirroring that's in place on this db. Can anyone confirm?
- 43
4
votes
2
answers
2k
views
Replicate single table from SQL Express to SQL Enterprise 2014
We have a small branch app that stores some data in a SQL Express Database.
We want to have an almost real time copy of this table in our headquarters, were we have SQL Enterprise 2014. I say almost, ...
- 203
3
votes
1
answer
572
views
Can you restore log file backups to a mirror database after failure?
Purely a theoretical question as I've been considering possible DR scenarios...
In this scenario:
The link between a principle and a mirror server becomes unavailable for a period of time (e.g. ...
- 1,444
1
vote
1
answer
121
views
many Servers of SQL server 2012 needs mirroring
I have two SQL server 2012 instances and I want to configure mirroring between the 2 servers with database.
My questions are:
How can it automatically change host of one if the other one was dropped ...
- 33
1
vote
3
answers
8k
views
Why are my SQL Server 2008R2 databases not mirroring?
I'm trying to set up database mirroring in SQL Server 2008R2. I've taken a full backup and a transactional backup from my principal database and I've restored both WITH NORECOVERY.
However, my mirror ...
- 949
13
votes
1
answer
30k
views
Mirroring - Server network address cannot be reached
I have SQL Server 2008 R2 Installed. It contains three instances.
Default (MSSQLServer)
First Instance
Second Instance
All these are Log On as Network Service..
Default Instance is Principal ...
- 271
11
votes
1
answer
6k
views
Database Mirroring with TDE
I have the requirement of mirroring a few databases and also using transparent data encryption (TDE) on them as our data must be encrypted while 'at rest'.
I have setup TDE on both the principal and ...
- 881
10
votes
2
answers
1k
views
Mirroring the Distributor
Has anyone had success with mirroring the distribution database? We have a dedicated server as a Distributor. It handles all our push replication from prod to reporting. We'd like to build an ...
- 342
9
votes
1
answer
15k
views
Breaking and Restoring a mirror
I have to do some maintenance on a secondary node of a mirror. Since this is the result of the site becoming slow while the mirror re-established after a brief network outage I want to be safe and ...
- 193
9
votes
1
answer
1k
views
Why my database mirror break down after changing file group settings from RESTRICTED_USER to MULTI_USER?
My environment is the following:
VMWare 5.5 vitalized server MS Windows Server 2008R2 Enterprise domain and SQL Server 2008 R2 Enterprise.
Centralized storage with fibre-channel connection.
I have ...
- 1,163
8
votes
2
answers
6k
views
How do I shrink the physical Transaction Log file when it's the principal in a mirror?
We setup database mirroring over the weekend, and forgot to re-enable the job that backs up the transaction logs. When I came in this morning, the transaction log had ballooned to 58GB, and was taking ...
- 8,477
6
votes
3
answers
18k
views
Mirroring Databases in MySQL
Is there a way to mirror databases in MySQL? In SQL Server, you have the ability to link 2 databases in a master to master relationship. One DB will accept transactions and the transactions will be ...
- 972
6
votes
1
answer
5k
views
The definition of object '[sp_name]' has changed since it was compiled on fail-over to mirror database
We have two SQL 2012 database servers configured in a mirror with a witness for automatic fail-over.
Yesterday the primary server suffered a HDD degradation which triggered the fail-over, however ...
- 789
5
votes
1
answer
4k
views
SQL Server Mirroring vs 3rd party replication products such as DoubleTake
I'm charged with looking after several SQL Server instances, most of which use SQL Server mirroring to replicate data for DR purposes.
I automatically script logins, roles & jobs to the mirror, ...
- 786
4
votes
1
answer
8k
views
Setting up Mirroring in SQL Express Edition
I know doing something like mirroring in SQL Server express edition is not possible, but can we do real-time db backup and restore and setup some automated task which acts like mirroring and keep them ...
4
votes
3
answers
3k
views
How to sync the data between two identical DB
The thing is I've two identical databases, one is in my localhostserver at my laptop and the other one is on the office main server. Is there any automatic way or software that can synchronize the ...
- 281
4
votes
2
answers
8k
views
Should I pause Mirroring and stop SQL Server services before running windows updates?
I am running Windows update on my SQL Servers (which are in a Principal-Mirror partnership, in High Safety mode).
I am starting with updating the mirror and I was wondering, to increase safety, ...
- 1,487
4
votes
1
answer
733
views
SQL Server DR, mirroring or virtualise and mirror
I have a client with a small business server 2008 Premium installation. This obviously includes SQL Server 2008 standard on a separate 2008 server. On the SQL we run several line of business ...
3
votes
1
answer
719
views
Change Data Capture not running when Mirror is Suspended
We have 2 SQL 2012 SP2 Enterprise servers that have some mirrored databases. One of these databases also has CDC enabled on a number of tables so that we can run some business logic when there are ...
- 3,252
2
votes
1
answer
9k
views
SQL Server Mirroring can't connect to mirror database
I am at my wits end with this. I am trying to set up mirroring between a development server and my local machine.
The error that keeps coming up is:
Msg 1418, Level 16, State 1, Line 1
The ...
- 121
2
votes
1
answer
27k
views
Mirroring SQL error log - Error: 8474, State: 11
I'm getting these errors in SQL error logs:
An error occurred in a Service Broker/Database Mirroring transport connection endpoint,
Error: 8474, State: 11. (Near endpoint role: Target, far ...
- 35
2
votes
2
answers
2k
views
migrate db's - best way to mirror or replicate a full database
I would like to mirror/replicate my databases to the cloud. The cloud is setup using VPN to my actual machine.
I am a bit confused by the options I have and would like to get some light into it.
My ...
- 1,353
1
vote
1
answer
94
views
many Servers of SQL server 2012 needs mirroring [duplicate]
I have now simply 2 SQL Server 2012.
I want to configure database mirroring between the 2 servers.
My questions are:
How can it automatically change host of one if the other one was dropped ?
Is the ...
- 33
1
vote
2
answers
990
views
Deciding on a replication strategy
We have several dozen small-medium (<1Gb) databases on our SQL Server 2008R2 (Standard Edition) server, with one or two more being created every month. The server itself is a fairly well spec'd box ...
- 303
1
vote
0
answers
396
views
Oracle Database Gateway for SQL Server - Connect to a SQL Server Mirroring Session
An Oracle Database server is using Oracle Database Gateway for SQL Server to define a Link Server to a Microsoft SQL Server. For the database on Microsoft SQL Server, Mirroring has been configured. So ...
- 121
1
vote
2
answers
1k
views
Can I send a string over TCP using T-SQL?
I've set up some alerts, based on this article
Now I would like the Job that is triggered by the alert to send some information to a c# application (this application, can be running in the same ...
- 781
1
vote
1
answer
441
views
Database Mirroring error, but everything looks OK
I'm setting up a Mirroring study session in separated servers.
Everything looks ok, the firewall in my machine is disabled and in the another server it has an inbound\outbound rule to accept port ...
- 7,386
1
vote
1
answer
3k
views
Running queries on a mirrored database
I have a Web forms asp.net site running with a database on a VM (VM1). I also have a MVC 5 Web app that has its own membership database on another VM (VM2). I want to retrieve customer information ...
- 33
0
votes
0
answers
1k
views
SQL Mirroring synchronize logins and agent jobs
We have just started using SQL Server mirroring for several clients on SQL Server 2008 R2 Standard.
We've got the SQL Server mirroring working fine however now we run into the issue of replicating ...
- 9
0
votes
1
answer
389
views
SQLAgent executing command on Mirror database
I have a mirrored database DB1, ServerA as primary and ServerB is mirror.
I have a job running on ServerB (mirror), configured to run against DB1 database.
I was expecting the job to fail but the ...
- 447