The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
0answers
16 views

SQL Server Witness Server Alternative Approach

I have the setup below: 3 Database Servers 1 DR Database Server 1 Domain Controller 1 DR Domain Controller Currently I have the DR domain controller acting as the mirroring witness for the 3 ...
6
votes
1answer
75 views

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 ...
0
votes
1answer
73 views

Migrate existing database to mirrored database on Azure

I have setup 3 Sql VM's on Azure for database mirroring as described in this link with the idea being that we move our current database, which is currently on a single VM outside of Azure. Everything ...
0
votes
1answer
47 views

Two SQL Failover Clusters in two-node failover servers

I need 2 SQL Failover clusters: Core Database Cluster: this contains all of my core application databases Analytic Database Cluster: this contains my web analytic database Now, I only have 2 ...
1
vote
1answer
33 views

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 ...
2
votes
2answers
495 views

Where does data go during a SQL mirroring failover?

I'm just about to setup a SQL mirror but there's one thing I haven't managed to work out yet. If I'm mirroring DBA (principal) to DBB (mirror), and DBA goes offline, it will automatically switch over ...
1
vote
1answer
1k views

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 ...
0
votes
1answer
174 views

SQL 2008 R2 Clustering AND DB Mirroring (Async)

I've got a MS SQL 2008 R2 Fail-Over Clustered Instance running between two Windows 2008 R2 servers using the inbuilt Windows Clustering features, that is working with a DTC and Quorum with a disk ...
0
votes
2answers
59 views

Azure Table Storage mirroring

I am proposing an Azure environment with the following: VM SQL Server for core relational data Table Storage for bulk data I want to mirror the SQL Server database to another server so that ...
0
votes
2answers
424 views

Synchronisation between MySQL databases on different hosts

I want to solve a data replication/data sync problem between two MySQL server instances. Both of them have the same database structure (databases, tables, columns, everyting ...) but each of them has ...
0
votes
1answer
152 views

SQL 2008 R2 Mirroring Issue

Windows 2008 R2 with SQL 2008 R2 - Using Mirroring of a Database across the WAN in a HA setup with one witness. One issue I am having is during a failure (ever so often) the system fails over or ...
2
votes
2answers
1k views

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 ...
0
votes
1answer
839 views

Restarting MSSQLSERVER service on the principal or on the mirror the database is set in “In Recovery” mode

I'm running MSSQL Server 11.0.2100 (SQL Server 2012) and every time I restart the MSSQLSERVER service on the principal or on the mirror, the database mirror breaks and the database is set into In ...
2
votes
1answer
714 views

SQL Server 2012 Mirroring / AlwaysOn - need for SAN?

There appears to be a great deal of conflicting information about whether or not SAN is required for a Sql Server 2012 Mirroring setup. I currently have an Active-Passive-Witness SQL 2008R2 setup ...
2
votes
1answer
1k views

What the best way to achieve RPO of zero and lowest possible RTO (less than 15 minutes) with SQL 2008 R2?

We are running a payments (EFT transaction processing) application which is processing high volumes of transactions 24/7 and are currently investigating a better way of doing DB replication to our ...
1
vote
4answers
185 views

MS Sql Server Mirroring

We are looking at mirroring a MS SQL database (for a web application) due to the unique way the application was developed, each user has a SQL server Login user account which has permissions to our ...
3
votes
2answers
945 views

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 ...
0
votes
1answer
239 views

Server mirroring strategy questions SQL Server replication, MySQL replication, file replication, etc

I'm working as an application developer for a company that I've been with for for some time. The business would like to mirror their existing windows server (server A) to a new server (server B) with ...
0
votes
1answer
481 views

What happens when Mirror times out with Principal, but Principal does not timeout with Witness or Mirror?

We have three SQL server 2008 r2 servers (principal, mirror and witness) setup for mirroring (with safety option). I see in the Mirror server logs that there was a "The mirroring connection to ...
1
vote
4answers
4k views

Cannot add witness to my mirroring setup

I'm trying to set up mirroring with a witness using my 3 dedicated servers running SQL Server 2008 R2. I've set up everything as described at this blog post Mirroring seems to work fine between the ...
0
votes
1answer
84 views

MS SQL Hardware Configuration

About to order a replacement mirrored database pair to drive our multi-user web applications and looking for some guidance on some aspects. I have read various feedback on other posts but finding it ...
0
votes
1answer
53 views

Two principals in a SQL Server 2005 Mirroring setup

We've recently changed our mirror setup to include a witness so we support automatic failovers, yesterday in our datacenter they had some planned maintenance to some of the network supplies (i believe ...
1
vote
2answers
220 views

SQL mirroring Error- SQL 2008

I am trying to configure SQL Server mirroring and I am getting the following error: The server network address "TCP://santosh-PC:5023" can not be reached or does not exist. Check the network address ...
2
votes
1answer
99 views

What options for Windows Server 2008/SQL Server 2008 replication/mirroring across data centres?

Our Microsoft web-application processes around 2000 orders per day. I need to support failover to a secondary data centre. What are the options and experience of implementing a replication/mirroring ...
2
votes
1answer
86 views

SQL Server Mirroring - Should Witness server be dedicated to mirroring?

Scenario - SQL Server 2008 R2 Mirrored environment - High Safety synchronous with automated failover. Witness Server is a SQL Server 2008 R2 Express Edition. Question: Can the Witness server be used ...
0
votes
1answer
186 views

Distributed Database Services?

I'm working on a database-driven web service with clients in the US and Australia. We're currently hosted in the US, however our Australian clients are experiencing lag. The lag is primarily due to ...
2
votes
2answers
3k views

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 ...
2
votes
2answers
185 views

More than one MySQL server

I have a growing website which now uses a single and ordinary MySQL server for its tasks. I wonder how and when should I migrate to more powerful servers or in other words when is the best time to use ...
2
votes
3answers
205 views

Replication or?

Recently, we have been hammered by Google Bots and all kinds of other bots( 60% of the website traffic that we experience on an average are from Bots. We are trying to segment out the Google Bot ...
1
vote
3answers
584 views

SQL Server mirroring - how many sql mirrored servers can you have?

I want to setup SQL Server mirror on amazon EC2 but I always have to add additional storage and worried when i do this my data might get erased? 1) how many principal servers and mirror servers can ...
2
votes
1answer
257 views

Sql Server 2008 high availability in EC2

I'm currently evaluating a strategy that will enable high availability with SQL Server 2008 and redundant servers to limit DB downtime. My thought right now is to setup SQL server 2008 mirroring in ...
2
votes
1answer
257 views

How do you setup mirroring in SQL 2005 with IP addresses for server names? (EC2 / no AD)

I am setting up a mirror in Amazon EC2 and I have all servers with dedicated IPs. When i try to connect my mirror to my principal with the following command alter database DB_NAME set partner = ...
2
votes
1answer
2k views

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 ...
1
vote
3answers
908 views

MSSQL Mirroring Failover: Login failed for user

When MSSQL DB Mirroring fails over, our script won't login, fails on: Cannot open database requested by the login. The login failed. Login failed for user ... The way I can fix this is by running: ...
0
votes
1answer
847 views

SQL Server 2008: Mirroring: Threshold Alerts at Database-Level

Testing I have completed to date seems to indicate that the following Threshold Alerts need to be defined for the <all databases> Database Name rather than a single named database: Unsent Log ...
0
votes
1answer
135 views

Can't Mirror Database on Sql-Server 2008

I'm running two MS-SQL instances to create a mirrored-database environment, I have an instance in a Virtual Machine and another instance, alongside the witness, in the physical machine. I know this ...
0
votes
2answers
246 views

How to keep Ms-SQL database always UP: mirroring or replicationg?

I have several Tb databases in the Windows Server 2008. I would like to keep alive the service when the server is failing or the raids are needs to be rebuild. Which model to choose Replication or ...
0
votes
1answer
445 views

F5 LTM 10.2 and MSSQL 08R2

We have a mirrored SQL server setup with a pair of LTM's holding the mirror VIP. We're trying to setup a health monitor that runs a query against both servers in the mirror and directs traffic to the ...
0
votes
2answers
909 views

Database mirroring login failure attempts on mirror server

I have configured database mirroring between two servers at a distance 40 miles away from each other. Server specifications: SQL Server 2008,Standard Edition 64-bit This is same for principal,mirror ...
0
votes
1answer
115 views

Unusual CPU usage on SQL 2005 Mirror

We are running a mirror on SQL Server 2005 SP2 Enterprise edition for a few databases. These are running on VMWare with Server 2008 R2. On the mirror server, I see the CPU go up to 50% for about a ...
3
votes
1answer
98 views

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 ...
2
votes
2answers
177 views

MSSQL database mirroring

Reading over (and then testing out on a test database) the setup for mirroring it appears that one is supposed to leave the mirror database in restoration mode for normal operations. is this correct? ...
0
votes
2answers
1k views

Index rebuilding on mirrored database sql server 2008

I have a mirrored database in full safety mode on sql server 2008 R2 Standard Edition. I want to create a maintenance plan to rebuild and reorganize the indexes on a weekly basis. Maintenance plans ...
1
vote
2answers
153 views

Database Snapshots of Mirrored databases affect performance of Principal database?

I have 2 servers set in Mirroring High-safety. One is Principal and another in Mirror. Currently I have 2 snapshots of a Production database (100 GB size) created on Principal server (for no_lock ...
2
votes
3answers
83 views

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 ...
0
votes
1answer
342 views

Best solution for High Availability and SSRS on SQL Server 2008 R2?

I have 2 Physical Servers with SQL Server 2008 R2. – SQL Server 1(Active) & SQL Server 2 (Passive) Web Application is developed using .Net 4.0 Framework. I want to know the best solution to have ...
1
vote
2answers
89 views

SQL Server Mirroring — mirror data only?

Does anyone know if it's possible to mirror only data changes with SQL Server 2008's database mirror functionality. I suspect the answer is that it isn't possible, but wanted to see if I've missed ...
0
votes
1answer
99 views

database mirroring and 10 Mbps

I was doing some tests with my two instance's of SQL Server 2008 R2 and 10 Mbps limited LAN. I setup synchronous database mirroring. Database log file is 25000 MB and 99% free before the test. I ...
2
votes
1answer
64 views

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 ...
0
votes
1answer
168 views

SQL Server 2008 One-Way Mirroring

I'm new to DB admin but learning fast. We have a large SQL Server 2008 setup and I've just implemented a three-stage testing system - Alpha, Beta and Live servers. All three run the same version of ...