Recent update: 2008-3-21
990 byte By
exBK at 2008-3-7
Hi, I have successfully set-up a DB mirroring. When the pricipal goes down, the mirror picksup and the other way around too. So the mirroring part is working great. However, when I use my web applicaiton (dot net 2.0), it is not able to connect to Mirror server. I get the following error: An ...
I start with 3 servers, in High Safety mode with witness. I disconnect the network cable for the witness. Then I remove the witness from the mirroring session: ALTER DATABASE db1 SET WITNESS OFF I reconnect the witness network cable. Now I cannot add the witness back to the mirroring session ...
The database in Mirrored server is always in the state of restoring only. the database in mirrored server is restored with norecovery then we started mirroring. the status of mirroring is successfull and is synchronized. but the Mirrored server is always in the state of restoting not allowing ...
As stated in the subject I have a situation where if database mirroring is employed for either manual or automatic failover, all the client (including web connections) connections use ODBC not ADO, or OLEDB etc... so what methods are recommended? Client side redirect is not available so I could ...
1471 byte By
Rollin at 2008-3-1
My question is two fold. First, What is the best method for mirroring to a fail-over server? Replication has limits on tables that do not have key fields, and I am finding that Log Shipping is harder to work with. I have set it up several times, and conducted tests with test databases, but ...
Hello guys and gals,I've having some trouble getting DB mirroring set up in Sql Server 2005. Perhaps someone can help, as I've read everything I can find on the web and Google groups about this but still can't solve it.Here are the steps I have taken:1. Installed a fresh Windows 2003 on box ...
Hi there! Often discussed, but not really solved in my opinion - the connection between the partners and the witness causes problems. My case: Three Servers in the same domain, three endpoints on 5022 with windows negotiation, all endpoints can be reached by telnet from each server. Mirrorring ...
I am trying to enable database mirroring for 100 database. It goes error free till 59 databases (some times 60 databases) with the status (principal, synchronized) on principal. on the 60th or 61st database it gave the status (principal, disconnected). Also mirror starts acting abnormal. ...
1069 byte By
Micah at 2008-2-25
We currently use a split-mirror backup strategy for our Sybase database, which has a "quiesce database" command to suspend all transactions. By quiescing the database before splitting the mirror, we suspend all transactions to ensure we get a stable backup of the environment. It works very well ...
Hi there! There is still a problem with mirrored (mapped) SQL Users. If you mirror a database where an application connects with an sql user, the mapping (login / user) will be lost on the mirror server. After a failover occurs, it it not possible to log onto the new principal database because ...
300 byte By
Meher at 2008-2-23
Hi Mvps: Whats the major difference between Database mirroring and Log shipping?. I did read few differences but was told when it comes to applying the transaction logs on the secondary server , DB Mirroring has a diffferent methodology. Is that right?. Please clarify. Thanks ...
Hi, I encountered 2 problems when my application reconnects to the mirror database after the principle database is not available. My Connection String: Data Source=ServerA;Failover Partner=ServerB;Initial Catalog=TestFailover;Persist Security Info=True;User ID=sa;Connect Timeout=45 Firstly, the ...
I attempted to setup database mirroring using a High Availability scenario but when I installed SQL is chose to use local system accounts for all the services. Consequently, I stubled upon a microsoft article explaining how to setup mirroring using local system accounts and certificate ...
1239 byte By
jena at 2008-2-21
I need to connect to mirrored SQL servers (Developer Edition) using OLE DB, I tried both OLE DB and ODBC, but it doesn't work I used connection ODBC string: Driver={SQL Native Client};Server=10.0.1.161;Failover Partner=10.0.1.162;Uid=test;Pwd=test;Database=TestDB if server 161 is principal ...
Hi I am trying to configure Database Mirroring. I had do set dbcc traceon(1400,-1) manually using tsql as the server does not start when configring the startup parameter using the advanced properties of sql server configuration using -T 1400. After using the db-mirror properties and the wizard ...
Are there any good resources for data mirror in SQL 2005 SP1? I tried to search on microsoft.com, there is an article, but it is outdated, it only described data mirror in SQL 2005 RTM. appreciate any links or input. Owen
4417 byte By
MJian at 2008-2-20
II use the mirroring wizard to config all these three servers(windows authorization is used), the error logs in primary server and mirror server are showed as below a) On primary server: Error: 1474, Severity: 16, State: 1 Database mirroring connection error 4 'An error occurred while ...
Are there any good resources for data mirror in SQL 2005 SP1? I tried to search on microsoft.com, there is an article, but it is outdated, it only described data mirror in SQL 2005 RTM. appreciate any links or input. Owen
3516 byte By
ktmd at 2008-2-18
Hi, I set up DB mirror between a primary (SQL1) and a mirror (SQL2); no witness. I have a problem when I issue command: alter database DBmirrorTestSet Partner = N'TCP://SQL2.mycom.com:5022';go The error message is: The remote copy of database "DBmirrorTest" has not been rolled ...
836 byte By
Forch at 2008-2-17
Good morning all... I would like use the "Database Mirroring Monitor" to track what's going on. All three of my servers have SQL Server 2005 x64 edition installed with SP1. Server A is mirroring to Server C Server B is mirroring to Server C Following the instructions at ...
I have synchronous mirroring. Some times I loose connection to witness and mirror servers. These times primary server is down. Is there any way I can change mirroring to asynchronous when primary server is down due to communication break down between witness and mirrored servers? I can break ...
628 byte By
bmalla at 2008-2-15
When witness and mirror were down, mirroring was removed at primary. Now when I try to re-establish mirroring I get the following error Msg 1456, Level 16, State 3, Line 1The ALTER DATABASE command could not be sent to the remote server instance 'TCP://witness:5022'. The database mirroring ...
1093 byte By
Vl.K at 2008-2-15
command in principal server ALTER DATABASE database name SET PARTNER = 'TCP://<mirror_server_name>:5022' return: Msg 1413, Level 16, State 1, Line 1 Communications to the remote server instance 'TCP://<mirror_server_neme>:5022' failed before database mirroring was fully ...
I have synchronous mirroring. Some times I loose connection to witness and mirror servers. These times primary server is down. Is there any way I can change mirroring to asynchronous when primary server is down due to communication break down between witness and mirrored servers? I can break ...
1093 byte By
Vl.K at 2008-2-15
command in principal server ALTER DATABASE database name SET PARTNER = 'TCP://<mirror_server_name>:5022' return: Msg 1413, Level 16, State 1, Line 1 Communications to the remote server instance 'TCP://<mirror_server_neme>:5022' failed before database mirroring was fully ...
3516 byte By
ktmd at 2008-2-15
Hi, I set up DB mirror between a primary (SQL1) and a mirror (SQL2); no witness. I have a problem when I issue command: alter database DBmirrorTestSet Partner = N'TCP://SQL2.mycom.com:5022';go The error message is: The remote copy of database "DBmirrorTest" has not been rolled ...
1069 byte By
Micah at 2008-2-14
We currently use a split-mirror backup strategy for our Sybase database, which has a "quiesce database" command to suspend all transactions. By quiescing the database before splitting the mirror, we suspend all transactions to ensure we get a stable backup of the environment. It works very well ...
Hi.... I have sql server 2005 evaluation edition. And This version doesn't provides Mirroring option.Even after installation of service Pack1. Is there any other edition (Freeware or Evaluation) which provides the Database Mirroring. waiting for the prompt reply. Thanks ...
628 byte By
bmalla at 2008-2-13
When witness and mirror were down, mirroring was removed at primary. Now when I try to re-establish mirroring I get the following error Msg 1456, Level 16, State 3, Line 1The ALTER DATABASE command could not be sent to the remote server instance 'TCP://witness:5022'. The database mirroring ...
Hello, I tried this and it doesnt work, I just started up the service with -T flag on default instance but I havent been able to start it with -T flag 1400 on named instances. How can I Know that the directory MSSQL.4 is the MIRROR instance? C:\Archivos de programa\Microsoft SQL ...
314 byte By
Bogey1 at 2008-2-12
First of all, Great webcast today. My question is, I have everything up and running and would like to know what to do when the machine my primary is on quits or has a some type of disaster. Do I need to manually run recovery on each db that was mirrored? I'm not currently running a witness. ...
Here is my Question... I have 3 server hardware and the whole purpose is to make one as a web server and another one a SQL server. The purpose of the 3rd server is purely a backup server, what that means is, in case if my web server nor my database server fails, I should be able to use the 3rd ...
Has anyone tried mirroring any of the Dynamics GP databases yet? I am looking at using this and what to see if anyone has had any problems or even know if it can be done. Thanks
Attendee Registration URL: http://msevents.microsoft.com/CUI/EventDetail.aspx?EventID=1032290575&Culture=en-US I'll be talking about database mirroring starting @ 9:30 AM Pacific Daylight Time. Thanks, Mark ...
I'm using SQL Server 2005 SP1 Standard. On the Rebuild Index Task there is a checkbox at the bottom that says 'Keep index online while reindexing'. Great I thought, I'll check that. Later, when I tested the job, I got this error: 'Online index operations can only be performed in Enterprise ...
I am in the process of architecting SQL 2005 HA options and of course mirroring is at the top of the list. Does anybody know what the requirements are regarding upgrading mirrored databases, for example, applying hotfixes and service packs? Is it a requirement for the principal and mirror (and ...
Hi, I've a very basic doubt about database mirroring. I did setup a database mirroring session with the help of SQL Server Management Studio between the server A (db1) and B(db1). When is stop database mirroring by using the command button "Stop Mirroring" available in the mirroring ...
If your principal fails and your mirror assumes the main role and it is in Full recovery mode (which it has to be in Standard edition), then the log files will grow and grow until a transaction backup and shrink is executed. I have maintenance plans running daily (and hourly for transaction log ...
Hi! I have the following error during setting partner on mirror serverMsg 1431, Level 16, State 4, Line 1Neither the partner nor the witness server instance for database "masterserver" is available. Reissue the command when at least one of the instances becomes available. The partner ...
I have a problem that has happened a couple of times now. I'm in the process of testing our 2005 deployment - Standard edition on 2003 x64 servers for principal and mirror and 2005 express witness. All are pre SP1. Two databases are being mirrored. I have successfully set up mirroring which ...
Environment:SQL Server 2005 Enterprise in Win2k3 Enterprise on 32(x86) bit machine I am able to enable the Trace Flag 1400 using DBCC TRACEON (1400) GO. Only then we can able to configure for the ENDPOINTS. I successfully configured the ENDPOINTS for both the principal server and Mirror server ...
Download it here: <a title=" http://www.microsoft.com/sql/sp1.mspx" href=" http://www.microsoft.com/sql/sp1.mspx"> http://www.microsoft.com/sql/sp1.mspx</a> Thanks, Mark
how can i send a column of values to the stored procedure for filtering that stored procedure values...?
I am new to Microsoft SQL Server 2005 and i would like to make use of its database mirroring feature. My question though is: is database mirroring supported by the JDBC driver and if so how would you implement/code a connection to principal and mirror servers i.e. how would i implement a client ...
358 byte By
Bogey1 at 2008-2-4
Mark - You need to get the word out to get more people on this forum. I'm sure that there are alot of people who'd like to get this up and running and myself personally think this is a great step forward for sql server. I'm in charge of a few oracle databases and to get the Oracle Dataguard ...
560 byte By
Bogey1 at 2008-2-4
The mirror database, "UOP_PIMB", has insufficient transaction log data to preserve the log backup chain of the principal database. This may happen if a log backup from the principal database has not been taken or has not been restored on the mirror database. (Microsoft SQL Server, ...
490 byte By
Bogey1 at 2008-2-4
So I successfully got the mirroring to run and now I'd like to see what's going on between the two servers ( i'm not using a witness). I launch the Database Mirroring Monitor and its showing the two servers but when I go to the history column I'm not seeing any data movement. I've done a ...
Hi! I posted this on the adonet forum but didn't get any response so I might as well post it here. Hope anyone can help me. - I have set up mirroring and trying to get it to work from my .NET application. Mirroring seems to work ok. When I do a manual failover the witness is updated properly ...
Hi, for SQL 2005 - to set up database mirroring, is it required to have Active Directory installed or to be part of a domain? I am looking to use a workgroup with the SQL machines only and to not reference any domain and cannot find this information - is this possible?This is primarily because ...
Hi, We have a massive database that users run complex queries on. The queries are never the same so caching cannot be used too much effect. When many queries are run at one time by the various users the system slows down. What we are trying to achieve is maybe have a primary SQL Server 2005 ...