Making Custom Apps Both Cluster And Mirror Aware
Nov 9, 2007
if an app sits in an environment where both clustering and mirroring are available for HA, are there some simplified best practices, perhaps patterns or .net classes suggested by MS for making the app aware of both clustering and mirroring?
If the mirror db is also contained in the original connection string as a retry partner and SQL failed over automatically, the app wouldnt have a say in first retrying against the cluster. It might prefer cluster first because the mirroring is asynchronous and therefore a bit less up to date than the cluster. This of course assumes the app is ok with the longer failover time. If the partner isnt included, the app needs to be aware of two connection strings.
Is there some feature in SQL for having the best of all worlds, ie one connection string but having a "say" or "rule" in exactly what sql does and doesnt do for you and in what order?
View 1 Replies
ADVERTISEMENT
Nov 8, 2007
what proactive steps can we take to make our app (ado, stored procs etc) cluster aware, in the event that we someday use clustering? For instance, I read things about retry strategies etc but dont even know if retry is on a different connection or what appears to be the same connection. We already make our trans as small as possible.
View 7 Replies
View Related
Nov 9, 2007
most articles I read suggest that apps need to retry upon failure in a mirrored environment, using a different connection string, not worrying a whole lot about waiting for the retry. But I heard somewhere that the original connection string can also contain info about the mirrored db, thus eliminating the need to use two different connection strings, and perhaps not even needing to retry programatically. Which is correct? I also heard that programatic retry could be required anyway because of some bug involving the "first" failure and disappearance of a connection pool. Can someone just provide the 50,000 foot view of what it takes to make an app "mirror aware"?
View 1 Replies
View Related
Nov 12, 2007
one MS forum MVP seemed to be saying that a connection retry strategy is the key to making an app "cluster aware". Another MVP on sql server forums at sqlteam.com seems to be saying that this isnt how one makes an app cluster aware from a sql perspective, eventhough she seems to agree that a 15 second double retry strategy is a good thing. Am I missing what "cluster aware" really means?
View 1 Replies
View Related
Oct 2, 2006
Hello,
We currently have one instance of SQL2k5 SP1. We have a couple of publications, and 30 subscribers, on the instance and are considering going to either a cluster environment or db mirroring. Currently our instance seems to be busy and I am wondering if clustering really gives it a performance boost. What are your thoughts/suggestions on going to a cluster environment versus just db mirroring? Can mirroring be used for real-time failover as we need to add that as well? Thanks in advance.
John
View 2 Replies
View Related
Dec 28, 2007
Greetings Team,
please see my post in the previous thread;
http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=2606008&SiteID=17&mode=1
We are making our final decission of using either transaction log replicant or a database mirror replicant and which solution would provide the biggest ease of provisioning as well as the fastest turn around in recovery.
"Good Morning Team,
I have a client whom has a 2 node SQL 2005 cluster with over 100 databases, their schema design is that they create a new database for every customer that signs to their services.
The problem I am encountering is that for every new database created in the cluster we like to setup a SQL2005 mirror replicant at a remote site for disaster recovery should the cluster ever fail.
i'm looking at the SQL professionals to help me with 2 questions.
#1 Upon creation of a new database in the cluster is there an easily scripted method that could be used to automatically create the mirror replicant, what about if not being aware of the new databases having been created? since we do not know when the customer creates databases or perhaps a SQL job that could be done based on new databases created that would automatically script the procedure of a database mirror.
#2 understanding the procedures required in a mirror replicant from a cluster primary involving, database backup, database restore to mirror replicant, transaction log backup and then transaction log restore with both points of the restore leaving the mirror replicant in NO RECOVERY mode and lastly creating the connection end points.
has anyone encountered such a situation with a database cluster with a mirror replicant consisting of such a wide span of individual smaller databases and would anyone have suggestions on how to make this highly available with a mirror replicant?
i look forward to hearing back, happy holidays."
View 2 Replies
View Related
Jun 1, 2015
I have configured active passive cluster in production environment. And we also have a dr which we have configured with asynchronous mirroring with no witness. Currently active node(node
a) is in sync with dr. When failover happens and the second node(node
b) becomes active, the mirror is broken and goes to disconnected mode.
But when we failback again to node a mirror is connected again and is in sync again. In our setup we have active passive cluster and a standalone server as dr.
View 11 Replies
View Related
May 12, 2015
OS Windows Server 2012
SQL 2012
I have a software that presents a drive to a 2 node cluster.
Not sure how I would go about presenting this newly presented drive as a Cluster Resource and make SQL depend on this resource.
View 5 Replies
View Related
Aug 18, 2015
We have a SQL 2014 AlwaysOn availability group running on two Windows 2012 R2 servers that are in the same subnet. We created a new server in a second subnet, installed SQL, joined the server to the Windows cluster, added a new IP resource for the new cluster, and performed the other remaining steps to add a new AG replica to the SQL instance on this new server. When we try to move the core cluster resources to the new node to test failover, we get an error. Here's the command we've been using:
Move-ClusterGroup "Cluster Group" -Node node3
and it returns the error: The operation failed because either the specified cluster node is not the owner of the group, or the node is not a possible owner of the group...I've checked the ownership of the cluster groups and the cluster resources and it looks like they are set appropriately:
>Get-ClusterGroup | Get-ClusterOwnerNode
Cluster Object Owner Nodes
---------------- ---------------
Available Storage {}
Cluster Group {node1,node2,node3}
SQLAG {node1,node2,node3}
[code]....
We've double-checked that all IP resources are in the right subnets and that the dependencies for the Cluster Name resource and the Listener Name resource are set appropriately. I'm not sure what else to check since the PowerShell commands seem to indicate that node3 is an owner of the appropriate resources. What other things need to be checked or if the ownership being checked isn't the same as what PowerShell is checking?
View 3 Replies
View Related
Nov 30, 2006
Hi folks,
We are going thru the process of scoping an active/active cluster at one site.
I was wondering whether there will be any issues with mirroring (DB by DB) off the cluster into non clustered server at an alternate DRP site.
Regards, Brian
Sutherland
View 1 Replies
View Related
Jun 14, 2015
I am using SQl Server 2012 Database Mirroring with around 40 gb as mdf and 1 gb as ldf. Now my ldf size increased . How to reduce ldf size while mirror enabled with mirror server and witness server. Can shrink the ldf with mirror enables.
View 4 Replies
View Related
Jan 31, 2008
After adding the Witness Server to the Mirror session, the Witness Connection state between the Mirror and Witness Connection is Disconnected and the state between Principal and Witness Connection is Connected.
The procedures defined in Books Online was used to setup Database Mirroring...when the Witness server was added to the Mirror session, only the alter database T-SQL statement was executed on the Principal server.
ALTER DATABASE <db_name> SET WITNESS = 'TCP://<servername>:<port>'
After executing the above statement, a few seconds later the state between Principal and Witness Connection changed to Connected and the state between Mirror and Witness Connection remains Disconnected.
The Mirror session is not using Certificates, every server is on the same domain, using the same domain login account, and all servers have SP2 installed running Enterprise Edition.
Any idea's why the state between Mirror and Witness Connection remains Disconnected?
Thanks,
View 9 Replies
View Related
Dec 27, 2006
I was trying to test mirroring and now would like to delete the mirror database but it says I need to remove database mirroring first. I deleted the endpoint and cannot figure out how to remove the mirroring. Can someone please help.
View 1 Replies
View Related
Aug 22, 2001
Hi Guys,
This message is posted to alert everyone.
Be Aware !!!!! (Job seekers)
Convey this message to all of your friends.
Nowadays, a new Bad Virus (Trend) is affecting the IT industry throughout United States in the name of interviews.
It is shame for the Company who do this.
Persons are called for interviews and were asked to solve a problem spending like 3 to 4 hours in the name of testing their ability.
(which they really need solution for the problem they are facing in the company)
This guy who attends the interview shows his talents and solve the major problem within a couple of hours (even faster than they expect)
hoping that he will get a job.
As soon as the problem is solved, the person was told that, " Let we think about that, We will inform you later "
But after that there won't be any calls or feedback from the Company.
So some of the Companies utilitize the skills of the people and get their job done without paying which seems to clever.
So Guys Be Aware !!!!!
-Anu
View 2 Replies
View Related
Feb 12, 2004
That targets SQL Server. It deletes all data in random tables, and then truncates the transaction log.
Anyone heard of something like this?
Shaulie
View 3 Replies
View Related
Aug 21, 2001
Hi Guys,
This message is posted to alert everyone.
Be Aware !!!!! (Job seekers)
Convey this message to all of your friends.
Nowadays, a new Bad Virus (Trend) is affecting the IT industry throughout United States in the name of interviews.
It is shame for the Company who do this.
Persons are called for interviews and were asked to solve a problem spending like 3 to 4 hours in the name of testing their ability.
(which they really need solution for the problem they are facing in the company)
This guy who attends the interview shows his talents and solve the major problem within a couple of hours (even faster than they expect)
hoping that he will get a job.
As soon as the problem is solved, the person was told that, " Let we think about that, We will inform you later "
But after that there won't be any calls or feedback from the Company.
So some of the Companies utilitize the skills of the people and get their job done without paying which seems to clever.
So Guys Be Aware !!!!!
-Anu
View 1 Replies
View Related
Aug 21, 2001
Hi Guys,
This message is posted to alert everyone.
Be Aware !!!!! (Job seekers)
Convey this message to all of your friends.
Nowadays, a new Bad Virus (Trend) is affecting the IT industry throughout United States in the name of interviews.
It is shame for the Company who do this.
Persons are called for interviews and were asked to solve a problem spending like 3 to 4 hours in the name of testing their ability.
(which they really need solution for the problem they are facing in the company)
This guy who attends the interview shows his talents and solve the major problem within a couple of hours (even faster than they expect)
hoping that he will get a job.
As soon as the problem is solved, the person was told that, " Let we think about that, We will inform you later "
But after that there won't be any calls or feedback from the Company.
So some of the Companies utilitize the skills of the people and get their job done without paying which seems to clever.
So Guys Be Aware !!!!!
-Anu
View 1 Replies
View Related
Apr 18, 2007
Hi Folks,
I developed my ssis package against my local database and i would like to test it against remote server database.For that i have modified all of my connection manager settings still i am getting error on oledb destination and Execute T-Sql task.The below is the error.
[OLE DB Destination [11665]] Error: An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "The statement has been terminated.". An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Violation of PRIMARY KEY constraint 'PK__tblPr__532FC765'. Cannot insert duplicate key in object 'dbo.tblPr'.".
Can anyone suggest me what would be the problem and how to resolve this.
Thanks in Advance.
View 3 Replies
View Related
Jul 19, 2007
My goal is be able to compare the total number of rows of a plain file with the total number of rows inserted in a table (with that same file, of course) and then, send an email.
How can I do such thing?
TIA again
View 3 Replies
View Related
Mar 7, 2006
Hi, all:My VC6 MFC application is recognized as a Unicode application by the drivermanager, so when I read nchar fileds in MS SQL Server database, theSQL_WCHAR does not convert to SQL_CHAR, and the application ASSERT failureat CRecordset::GetDefaultFieldType function.But I don't have "_UNICODE" defined, and have no "W" suffix functionscalled, and my old version program compiled on Feb 2004 just work fine.(source code lost unfortunatally)I read docs like:http://msdn.microsoft.com/library/d...ver_manager.asphttp://msdn.microsoft.com/library/d...ode_drivers.aspbut can't find the right answer.Could any one tell me how dow the driver manager judge the application to beUnicode aware?Best Regards,Qiang He(remove the "nospam." to email me, thanks)
View 1 Replies
View Related
Mar 8, 2007
Hi,
I am creating a custom transformation component, and a custom user interface for that component.
In
my custom UI, I want to show the custom properties, and allow users to
edit these properties similar to how the advanced editor shows the
properties.
I know in my UI I need to create a "Property Grid".
In
the properties of this grid, I can select the object I want to display
data for, however, the only objects that appear are the objects that I
have already created within this UI, and not the actual component
object with the custom properties.
How do I go about getting the properties for my transformation component listed in this property grid?
I am writing in C#.
View 5 Replies
View Related
Sep 9, 1999
How many "applications" can be loaded onto Microsoft SQL Server 6.5?
Additional Information:
The OS platform is Windows NT Server 4.0 (SP5) on a Compaq ProLiant 1600 (PII 450) with 256Mb RAM
Proposed applications, although this probably will mean little, are Dataview (club membership) Peterborough (payroll) and Positive (HR).
Any assistance would be appreciated.
Thanks
Robert
robert@whiteley.com
View 1 Replies
View Related
Oct 21, 2006
Hey guys, my first post so here goes...
I'm wondering if anyone here knows how to write a program (or download a program) that pretends its a sql server and listens for connections, so that when an app thinks its sending its connection string to a server, its sending it to the locally installed program, so that you can get the UID and password from the connection string.
I'm working at a company where we need to write an extension to the software we use but we don't know the login to use for it. These programs are horribly designed. If you run it with the net card disabled it dumps the connection string to the screen but of course it has the UID and pass starred out. Any thoughts?
View 1 Replies
View Related
Jun 21, 2007
I'm struggling to connect to my SQL server whilst running a dot net application which is located on a network drive.
the program will run perfectly from my c drive, but as soon as i move the program file on to the network, it no longer recognises my windows permissions, and does not connect to the database.
can someone help?
is there some code that i need to add to my dot net code?
View 2 Replies
View Related
Jun 7, 2007
I have SQL Server 2000 with databases on the NetApps filer CIFS share.For example, the datafiles are located at \network shareserversharemicrosoftsqlservermssqldata...Whenever there is a filer failover, some of the databases go in suspectmode. Is there a setting on SQL Server like a time out setting from thenet apps that can be modified so that the databases will wait for awhile before going into the suspect mode?Raziq.*** Sent via Developersdex http://www.developersdex.com ***
View 1 Replies
View Related
Jan 4, 2007
Help!
Does anyone know where can i find some windows or web applications using ssis for manipulations?
View 4 Replies
View Related
Sep 8, 1999
If a user's pc needs to run 2 different applications (sold by 2 different vendors) and one must be 6.5 and the other must be 7.0, are there any problems with the client machine?
My understanding is that each of the apps comes with the pieces it needs to connect. I'm trying now to reach the tech types at the vendors and ask what kind of custom setup (if any) is needed on a user workstation or if the install does everything. If they come with their own dlls and odbc data sources, might all be well?
Does anyone have apps loaded on a desktop that connects to both a 6.5 and a 7.0?
Thanx,
Dick Scherrer
View 1 Replies
View Related
Dec 8, 2006
Hello,
i am planning to build Pocket Pc App and i would like to know if i can use Sql Mobile as my data store. The data base design is quite complex.
I wont be using any recplication/synchronization in my app since its a standalone app.
pls suggest.
Thanks
Karthik
View 3 Replies
View Related
Sep 27, 2006
Hi guys,I've got two apps that are going to have pretty much the same users and i wanted them to have the same ASPNET.MDF user database. Is it possible to store the ASPNET.MDF in a different location and then have the two apps access it from there or alternatively have it in the App_Data folder of one of the apps and then have the second app access it from there?Thanx
View 2 Replies
View Related
May 31, 2006
Hi
My console applications work for SA and no other user. I can run the Stored procedures used in the console application from Query analyser when logged in with username/password that I am attempting to use for console applications. I am using SQL server authenication. User access permissions look ok in Enterprise Manager. Access is permit for my user.
Any suggestions?
Thanks
View 1 Replies
View Related
Dec 17, 2005
A few years ago I wrote an active-X server to maintain a singleconnection to a file .mdb from multiple apps on same PC because I washaving to many database curptions.Should I use the same Active-X server for the same in a MS SQL ServerDSN connection or is it ok to have multiple apps from the same pc usingthe DSN?
View 1 Replies
View Related
Aug 31, 2006
I have an application that was developed under Visual Basic .NET 2005 Standard that I keep continuously running to monitor and gather data and store that data in a SQL Server Express database. This is all done on a single computer that's not networked to anything. The trouble is, I'd like to look at the data in the database from time to time without shutting down the application, but I'm not able to do so. If I try to copy the database files, named lamination.mdf and lamination.ldf, to another location, I get the following error message;
"Cannot copy lamination: There has been a sharing violation. The source or destination file may be in use."
I would like to be able to copy the file to my office computer where it would be convenient to use Management Studio Express to look at the database tables. I can't even use Management Studio Express on the computer where the application is running, as I get the following message when I try to attach the database:
"CREATE FILE encountered operating system error 32(The process cannot access the file because it is being used by another process.) while attempting to open or create the physical file 'C:Documents and Settings barnardMy DocumentsVisual Studio 2005ProjectsLamination Phase ILamDataBaseLamination.mdf'. (Microsoft SQL Server, Error: 5123)"
Here is the connection string in the VB application:
"Data Source=.SQLEXPRESS;AttachDbFilename="C:Documents and Settings barnardMy DocumentsVisual Studio 2005ProjectsLamination Phase ILamDataBaseLamination.mdf";Integrated Security=True;User Instance=True"
In the VB app, connections to the database are made only every few minutes, and the connections are immediately closed.
Is there anyway I can either copy the database files, or at least look at the database tables with Management Studio Express without stopping the VB application?
Thanks,
Tim
View 7 Replies
View Related
