The tag has no wiki summary.

learn more… | top users | synonyms

14
votes
3answers
600 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 ...
6
votes
1answer
63 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 ...
5
votes
4answers
609 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 ...
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
5answers
836 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 ...
3
votes
2answers
875 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 ...
3
votes
2answers
3k 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 ...
3
votes
5answers
255 views

SQL Server 2005 dropping objects from DB on recovery?

SQL Server 2005 dropped a user from one of our mirrored databases after we recovered from a simple Windows-update induced restart of the machine. I checked and the login is not in the mirror server ...
3
votes
2answers
312 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 ...
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 ...
3
votes
1answer
90 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
5answers
19k 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
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. ...
2
votes
3answers
203 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 ...
2
votes
1answer
408 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
2answers
408 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 ...
2
votes
2answers
757 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 ...
2
votes
4answers
4k 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
3answers
147 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 ...
2
votes
1answer
289 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 ...
2
votes
1answer
906 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 ...
2
votes
2answers
181 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
1answer
231 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
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? ...
2
votes
1answer
961 views

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

Limit on number of databases to mirror (MS SQL 2k8)?

I am implementing an SQL failover strategy for ms-sql 2k8, and am thinking of going with database mirroring. I've read that it's not intended for a large number of databases - however the article did ...
2
votes
3answers
80 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 ...
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 ...
2
votes
1answer
569 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
81 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 ...
2
votes
1answer
249 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
98 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
1k 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 ...
2
votes
1answer
335 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 ...
1
vote
4answers
1k views

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 ...
1
vote
3answers
424 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 ...
1
vote
2answers
135 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 ...
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
3answers
104 views

Back-end SQL Server 2005 databases for website

We're migrating an existing IIS website + MS SQL 2005 database (on the same server) to a new test set-up. The existing set-up is too slow. I want one ISS server and 2 X MS SQL server 2005. One live ...
1
vote
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 ...
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?
1
vote
3answers
137 views

Best way to duplicate databases nightly?

We just got two new servers, that are running Windows Server 2008. The intent is to make the machines pretty much identical, copying the content of the master to the slave on a nightly basis, so that ...
1
vote
1answer
28 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 ...
1
vote
1answer
755 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 ...
1
vote
3answers
762 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: ...
1
vote
2answers
86 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 ...
1
vote
2answers
169 views

Sql Server 2008 Database Mirroring

I'm at the early stages of implementing a high availibilty solution using SQL 2008. With regard to database mirroring I believe that under the syncronous model, transactions are not committed on the ...
1
vote
1answer
191 views

How to mirror 1000 databases on SQL 2008?

We are implementing a mirroring for ms-sql 64bit 2008 database. Are there are limits to how many databases can be mirrored? We are going to mirror 1000 small databases with a total size of 2TB. ...
1
vote
2answers
269 views

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