Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [database-mirroring]

103 questions
2
votes
3 answers

Set up a temporary reliable database server on a budget of $0.00

I am helping run a Model United Nations conference for high school students. The conference is completely organized and staffed by university students. I am writing an application that will keep track of UN Resolutions passed by the students, print…
Brennan Vincent
  • 123
  • 3
2
votes
1 answer

Installing two versions of MSSQL on a production server?

We've just provisioned a second dedicated server so we can use database mirroring for high availability. The existing server uses MSSQL Express 2005. We have MSSQL Web 2008 and want to minimise the downtime to get mirroring set up. Can I install…
user59135
2
votes
1 answer

What method of MySQL mirroring should I use for this?

I'm running an web application hosting service (basically hosting forums for free), and I have two remote servers at my disposal. The code for the application is stored on both servers and isn't a problem, but I'm wondering how to deal with the…
Matt
  • 625
  • 1
  • 7
  • 14
2
votes
1 answer

SQL Server Database In Single User Mode after Failover

Here is a weird situation we experienced with a SQL Server 2008 Database Mirroring Failover. We have a pair of mirrored databases running in high-availability mode and both the principal and mirror showed as synchronized. As part of some maintenance…
jlichauc
2
votes
2 answers

Service or software to auto-sync one server to another so they are identical?

We have a main node in a DC data center and want to setup a back-up node in Seattle. The back-up node will only be used if the DC node goes down and we switch it over while DC node is repaired. The question is, what kind of services out there allow…
MetaGuru
  • 856
  • 5
  • 22
  • 35
2
votes
1 answer

Database Mirroring of SQL server

I have two databases that are mirrored to another server using database mirroring. The mirror server has to be down for some reason for few days. Now the production server is having principal databases in (PRINCIPAL/DISCONNECTED) State. Clients can…
user23996
  • 191
  • 1
  • 2
  • 4
2
votes
4 answers

Is it possible to mirror the SQL Reporting Services databases?

Is it possible to mirror the SQL Server (2005 or 2008) Reporting Services databases (ReportServer, ReportServerTemp)? I have a web site that uses a database that is already mirrored, and it also makes use of the Reporting Services. I want to be…
Anthony K
  • 354
  • 6
  • 12
2
votes
2 answers

How do I get an SQL Database in "Mirrored, Disconnected / In Recovery" into service?

I have an SQL Server 2005 mirrored database, with just the primary and secondary servers, no witness. Tonight the primary has gone down and will not be back on-line for some time yet. The secondary server is still running, but is "Mirrored,…
Anthony K
  • 354
  • 6
  • 12
2
votes
5 answers

How can I synchronize MS SQL Server databases?

How can I synchronize MS SQL Server databases? Is there any tool, preferably open source?
Rajesh
  • 137
  • 1
  • 1
  • 4
2
votes
3 answers

How to measure the time needed to switch a database mirroring role?

I want to measure the time needed for SQL Server to switch server roles. Is there a way to know how long does it take the mirror to become the principal and ready for new updates? Thank you very much!
Vimvq1987
  • 475
  • 7
  • 18
1
vote
1 answer

How to make SQL mirroring endpoint on clustered SQL 2012 instance listen to all IPs?

I have a clustered SQL 2012 standard instance and I want to set up database mirroring. I also need to route the mirroring traffic through a separate NIC. We added the secondary IP to the SQL server cluster role as an "IP address" resource, on…
StepCZ
  • 153
  • 1
  • 8
1
vote
0 answers

SQL mirror server doesn't connect after reboot with Windows Firewall enabled

I am trying to get database mirroring working properly in high safety mode with automatic failover. I have named instances of SQL Server 2014 installed on Windows Server 2012 R2 for my principal and mirror. I have another named instance of SQL…
Joel Kolb
  • 11
  • 1
1
vote
4 answers

SQL Server 2005 mirror database still in (restoring...) state

I just successfully mirrored the same database on two of our servers. The principal database state in Management Studio is: (databasename, Principal, Syncronized). The mirror database state is (databasename, Mirror / Restoring...). What is our next…
Rick
  • 45
  • 3
  • 7
1
vote
1 answer

SQL server many to one mirroring

I have two SQL servers, server A and server B running SQL Server 2008 R2 Standard. Can I setup a third server that will be a mirror for both server A and server B? I can't seem to find any documentation stating that a many-to-one mirroring is…
Alex
  • 38
  • 3
1
vote
1 answer

MS SQL Start Mirroring Error

Helo, I'm trying to mirror a db using a Principal, Mirror, and a Witness server. Each computer that has it's own local ip address (v4) and I made them static so they would not change. Then I did some reading and followed the steps on how to backup…
compcobalt
  • 89
  • 2
  • 10
1 2
3
4 5 6 7