Questions tagged [database-mirroring]
The database-mirroring tag has no usage guidance.
105
questions
1
vote
3
answers
3k
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:
...
- 400
0
votes
1
answer
2k
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 ...
- 275
0
votes
1
answer
201
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 ...
- 131
0
votes
2
answers
320
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 ...
- 595
0
votes
2
answers
712
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 ...
- 1
1
vote
2
answers
4k
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 ...
- 11
0
votes
1
answer
226
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,260
3
votes
1
answer
173
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 ...
- 91
2
votes
2
answers
203
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? ...
- 951
0
votes
2
answers
3k
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 ...
- 882
1
vote
2
answers
611
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 ...
- 600
2
votes
3
answers
101
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 ...
- 123
0
votes
1
answer
406
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
1
vote
2
answers
189
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,218
0
votes
1
answer
148
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 ...
Geo
2
votes
1
answer
77
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 ...
user59135
0
votes
1
answer
456
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 ...
- 513
0
votes
1
answer
709
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 ...
- 165
0
votes
2
answers
1k
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 ...
- 175
1
vote
2
answers
203
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 ...
- 121
-1
votes
1
answer
194
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 ...
Divya Kapoor
1
vote
1
answer
311
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. ...
- 137
4
votes
2
answers
22k
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 ...
- 307
2
votes
1
answer
2k
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 ...
- 655
0
votes
1
answer
760
views
IIS/MSSQL HA on two servers? NLB + Mirroring
We currently have the one server doing MSSQL/IIS. Can use NLB with two servers running IIS for HA and can use database mirroring and put the failover partner in the connection string for HA.
Can we ...
Igor K
0
votes
1
answer
210
views
Mesh Networked servers via vpn
I got a design idea and I would like to have some advice from SF about It. I have 5 customers with small real-estate databases. I've built for them a desktop app and now they would like to merge their ...
- 434
2
votes
1
answer
950
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 ...
jlichauc
1
vote
3
answers
110
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 ...
Datapimp23
2
votes
2
answers
308
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 ...
- 916
2
votes
1
answer
564
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 ...
- 191
2
votes
4
answers
8k
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 ...
- 374
1
vote
3
answers
239
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 ...
- 231
2
votes
2
answers
11k
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 ...
- 374
2
votes
5
answers
27k
views
How can I synchronize MS SQL Server databases?
How can I synchronize MS SQL Server databases? Is there any tool, preferably open source?
- 137
2
votes
3
answers
194
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 much!...
- 485
1
vote
1
answer
2k
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 ...
- 432
0
votes
2
answers
921
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 ...
- 307
0
votes
2
answers
246
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 ...
- 1,512
0
votes
1
answer
475
views
Changing from database mirroring to transaction log shipping
I'm considering dumping database mirroring and go with transaction log shipping on our SQL Server 2008 Standard server instead, because there's a noticeable performance hit due to the principal being ...
- 133
1
vote
4
answers
3k
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 (...
- 45
2
votes
5
answers
288
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 (...
- 1,512
4
votes
2
answers
819
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 ...
- 10.8k
0
votes
3
answers
1k
views
MySQl, Postgresql replication comparison
One main issue with MySQL replication is that the slave is single threaded. This can cause replication lag.
How does Postgresql handle replication? Does it (or add-on such as slony-I) allow multi-...
- 3,130
3
votes
1
answer
6k
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. ...
- 179
0
votes
1
answer
803
views
SQL 2008 Datawarehouse Collection Agent Fails with Mirrored Databases on instance
I have a data collection job that fails when a Database on the instance is in Recovery Mode. The database in recovery is the MIRROR partner in the database mirror.
The Job that fails is as follows.
...
- 91
0
votes
2
answers
4k
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 ...
- 183
2
votes
3
answers
2k
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 ...
MCW
3
votes
5
answers
1k
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 ...
- 1,262
2
votes
1
answer
354
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,262
1
vote
2
answers
300
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?
- 417