0
votes
1answer
41 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
42 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 ...
2
votes
2answers
377 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
675 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
132 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
50 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
1answer
102 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 ...
0
votes
1answer
589 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 ...
1
vote
4answers
177 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 ...
1
vote
4answers
3k 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 ...
2
votes
1answer
79 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
2answers
2k 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
3answers
201 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
357 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
246 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 ...
1
vote
3answers
722 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
2answers
240 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
108 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 ...
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
890 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
130 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 ...
0
votes
1answer
93 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
154 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 ...
0
votes
1answer
151 views

Verify SQL Server Mirroring failover is successful

We have database mirroring configured as "high safety without automatic failover" on 23 databases. Both partners contain principal and mirror databases. I created two scripts that would failover ...
0
votes
2answers
378 views

Tools to manage sql 2008 database mirroring?

We are going to be moving about 20 databases that live on a single instance of sql 2000 to a sql 2008 r2 environment with database mirroring. What I'm looking for is a tool or scripts that will help ...
-1
votes
1answer
158 views

Database Mirroring in SQL Server 2008

I have the Principal server and mirrored server placed on one VLAN and the witness server on another vlan. The port assigend to all these servers is 5022. The problem we are facing is that the ...
3
votes
2answers
2k views

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 ...
2
votes
1answer
329 views

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 ...
2
votes
1answer
407 views

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 ...
2
votes
4answers
3k views

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 ...
2
votes
1answer
2k views

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 ...
2
votes
5answers
18k views

How can I synchronize MS SQL Server databases?

How can I synchronize MS SQL Server databases? Is there any tool, preferably open source?
2
votes
3answers
140 views

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 ...
1
vote
1answer
1k views

SQL 2008 Database mirroring over WAN link with certificates

I am configuring database mirroring over a WAN link between two SQL 2008 named instances who's host servers are not domain members, using certificates for authentication. After many attempts to get ...
0
votes
2answers
319 views

Send Email on failover in Sql Server 2005

I have two instances of Sql Server 2005 running two copies of a database in a Principal and Mirror configuration. I want to send an email to someone whenever there is a failover, by which I mean the ...
0
votes
2answers
210 views

SQL Server 2005 Standard Mirror / replicate w/2008 Standard?

We're in the process of planning our upgrade from SQL Server 2005 to 2008. Our 3rd party app is certified against 2008 so we do not expect any major problems, but we thought it would be best to ...
3
votes
2answers
310 views

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 ...
2
votes
1answer
4k views

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

How can I improve SQL server mirroring performance

(reposted from stackoverflow) I've setup SQL server mirroring, using 2 SQL server 2005 standard editions. When the application is being stressed, response times increase 10-fold. I've pinpointed this ...
3
votes
5answers
826 views

Licensing a SQL DR box [duplicate]

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 ...
2
votes
1answer
285 views

Database Mirroring Questions

I recently set up SQL 2005 database mirroring (synchronous with witness) on a couple of environments and enjoyed the experience but have a few questions: Does the transaction log chain get broken ...
1
vote
2answers
254 views

Programmatically Monitoring SQL Server 2005 mirror

Does SQL Server 2005 provide an interface that can be programmatically addressed to determine the health of a mirrored database? If so, does anyone have examples of how to do so?
4
votes
9answers
9k views

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

Combining failover clustering and database mirroring

When you combine failover clustering and database mirroring in SQL Server, you need to change the mirroring partner timeout value so that the local cluster gets a chance to fail over before database ...
0
votes
4answers
244 views

Slow loss of connectivity to SQL Server 2005

Client has a dangerously open instance of SQL Server 2005. VB.NET 1.1 connects to this from another server without problem. Turning on Windows firewall with port 1433 open to subnets only seems like ...
5
votes
4answers
597 views

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 ...
14
votes
3answers
599 views

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 ...