Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [database-mirroring]

105 questions
14
votes
3 answers

Combining SharePoint and Database Mirroring

This isn't a how-should-I-do-this question, just to set the stage. It's a what has your experience been? Please read through the whole question before quickly replying. I spent the day yesterday teaching the current round of SharePoint MCM…
Paul Randal
  • 7,194
  • 1
  • 36
  • 45
6
votes
1 answer

Copy SQL Server Databases

I am looking to "move" databases to different servers with minimal disruption to data and service. These databases vary in size from 5GB to 140 GB. I've seen and even used some of the various data transfer tools of SQL Server but I'm unsure of what…
Black Dynamite
  • 523
  • 2
  • 5
  • 16
5
votes
4 answers

Geographical DB synchronus mirroring

An architect in our company has designed a solution based on 64 bit SQL2005 Standard edition synchronous mirroring between a physical (4 quad core, 32GB RAM) server and a virtual DR server (4 virtual CPUs with 16GB RAM) in two geographically remote…
SuperCoolMoss
  • 1,262
  • 11
  • 20
4
votes
2 answers

How long can a mirrored fail-over partner be offline before a full backup is required to re-synchronize?

Running a db mirroring in sql server 2005 sp2. There is SAN maintenance that needs to occur and i want to know if I stop SQL Server on the fail-over partner (mirror) and the principal keeps doing log backups, will i need to re-initialize database…
Nick Kavadias
  • 10,796
  • 7
  • 37
  • 47
4
votes
2 answers

How to slave real-time data from two MySQL sources merging in to one MySQL destination?

I have two different MySQL instances that I would like to 'slave' to a third instance. (so I can do easy joins on the third instance) eg. mysql1> show databases db1 db2 mysql2> show databases db3 db4 mysql3> show databases db1 db2 db3 db4 I've…
Joel K
  • 5,853
  • 2
  • 30
  • 34
4
votes
9 answers

SQL Server 2008 failover strategy - Log shipping or replication?

We just moved from SQL Server 2000 to SQL Server 2008. We were using our own log shipping on 2000 for failover. For 2008, we need to decide to use our own log shipping, built in log shipping, or replication. We have many databases on our server…
Peter
  • 43
  • 1
  • 1
  • 4
4
votes
2 answers

When successfully configured SQL Server for database mirroring, got an error saying it's not configured for database mirroring

I need to replace the old database in our test environment with a fresh copy of the production database. The test environment is actually comprised of two instances of the test database, on 2 different servers, in a mirroring configuration (it's got…
MGOwen
  • 307
  • 2
  • 4
  • 11
3
votes
1 answer

Error configuring witness server for failover in SQL Server

I'm lost here, I am configuring a SQL Server for failover and have three servers. Principal server > SQL 2008 R2 Witness server > SQL 2014 Mirror server > SQL 2008 R2 All three servers can ping the other via IP and FQDN. The endpoints configure…
Tom
  • 419
  • 3
  • 10
  • 20
3
votes
1 answer

Is SQL Server Mirroring Reliable (high availability)?

I'm evaluating SQL Server 2008 Mirroring (async) in order to provide better availability. I'd like to know, based on your experience, if SQL Server Mirroring is a reliable and mature technology. Automatic failover is not mandatory but is a…
Sly
  • 179
  • 2
  • 6
3
votes
3 answers

Simplest way to shrink transaction log files on a mirrored production database

What's the simplest way to shrink transaction log file on a mirrored production database? I have to, as my disk space is running out. I will make a full database backup before I do this, so I don't need to keep anything from the transaction log…
MGOwen
  • 307
  • 2
  • 4
  • 11
3
votes
5 answers

Licensing a SQL DR box

Possible Duplicate: Can you help me with my software licensing question? I'm tempted to use a DR server which holds a mirrored copy of a database to also perform test restores and integrity checks of the principle database. There maybe issues…
SuperCoolMoss
  • 1,262
  • 11
  • 20
3
votes
3 answers

Which ports to open for DB Mirroring

We have two physical servers on the different area protected by firewalls. We need to use DB Mirroring for our purpose. So which ports we need to open between two area for using MS SQL 2008 DB Mirroring?
Sasha
  • 229
  • 2
  • 5
  • 12
3
votes
1 answer

SQL Server mirroring refuses to work. Tearing my hair out

I'm trying to attempt what I thought would be a very simple process - the mirroring of a database between two MSSQL 2008 R2 servers within the same domain. Both servers are configured similarly, and I have a database called 'archive' that I'd like…
growse
  • 8,020
  • 13
  • 74
  • 115
3
votes
1 answer

Script to mirror MS SQL Server databases between 2 servers

I have about 200 sites each of which have 2 servers running MSSQL (2k5 at some sites, 2k8 at others) One server is production and the other is primarily there as a backup. We're rebuilding all of these servers this year and as part of that we will…
David W
  • 91
  • 1
  • 7
2
votes
1 answer

SQL Mirror failing on setup

I've got two SQL servers, I need to mirror a database from one to the other. Should be straight forward, two servers no witness. Both servers are running the same edition of MS SQL Std 2014 The SQL services are all running under the same domain…
Patrick
  • 1,280
  • 1
  • 15
  • 36
1
2 3 4 5 6 7