Showkatdar
asked on
SQL Server 2005 Redudancy
Dear,
I need help. I am working on a site where we have Live SQL Server 2005. What i need is Redudancy of this SQL Server. We have no domain controller out there. It is stand alone SQL Server.
I dont know much about this. So please help me to solve this issue. I want to know Pre-Requirenments for doing the same, and also please help me to know how to do this.
Waiting for Some body to Reply
Thank you and Regards
I need help. I am working on a site where we have Live SQL Server 2005. What i need is Redudancy of this SQL Server. We have no domain controller out there. It is stand alone SQL Server.
I dont know much about this. So please help me to solve this issue. I want to know Pre-Requirenments for doing the same, and also please help me to know how to do this.
Waiting for Some body to Reply
Thank you and Regards
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
bcsql
While Mirroring is cool you may not have the bandwith to support it to or from a remote site. you should also look at logshipping.
ASKER
Dear all
Thankx for your comments.
Well i dont know much about SQL, so i m worried about it. So please if any body can help me find a better solution.
Just give me quick Steps to achieve this task.
With Regards
Thankx for your comments.
Well i dont know much about SQL, so i m worried about it. So please if any body can help me find a better solution.
Just give me quick Steps to achieve this task.
With Regards
When you say redundancy; how quickly do you need the standby server to be available?
ASKER
Dear St3veMax,
Well Actually i m working on a live System, where we have SQL Server 2005 running. What i need is to add one more SQL Server 2005 for Redundancy. By Redundancy i mean if My Primary SQL Server Fails, this second SQL Server should take care of all the things automatically.
So either we say it can be done through SQL Redundancy, Log Shipping or Mirroring, That i want to know. Which is the best way to do it, how to do it, what hardware Requirenments are there.
Please help
With Regards
Well Actually i m working on a live System, where we have SQL Server 2005 running. What i need is to add one more SQL Server 2005 for Redundancy. By Redundancy i mean if My Primary SQL Server Fails, this second SQL Server should take care of all the things automatically.
So either we say it can be done through SQL Redundancy, Log Shipping or Mirroring, That i want to know. Which is the best way to do it, how to do it, what hardware Requirenments are there.
Please help
With Regards
OK;As i see it; You have two options for automatic failover. One depends on your application; if it can use the SQL Native Access Client (SNAC); If so, Database Mirroring would work for you in High Availability mode. It's hardware independant; so you dont require identical servers, disk sub-system, etc.
If the SNAC is not an option; for automatic failover you would be better with an Active/Passive SQL Cluster however this required identical hardware and a shared storage array (HP MSA, EVA, etc).
With the cluster; you have two nodes; one active, one passive. Should the active fail, it will fall over to the passive node and resume processing.
It terms of hardware requirements; what ever works for your existing SQL Server will be good enough for either options; you may require additional hardware for a cluster (such as SCSI/Fibre HBA's, etc)
One final though is that if you need your servers to be geographically apart (i.e. DR/BCP); then Mirroring would be your best bet; but would need to be made to work with teh SNAC and you need to calculate how quickly your application writes to the transaction log; as you would need a WAN link big enough to cope in order to give you the high availability due to the nature in which transactions are committed.
HTH
If the SNAC is not an option; for automatic failover you would be better with an Active/Passive SQL Cluster however this required identical hardware and a shared storage array (HP MSA, EVA, etc).
With the cluster; you have two nodes; one active, one passive. Should the active fail, it will fall over to the passive node and resume processing.
It terms of hardware requirements; what ever works for your existing SQL Server will be good enough for either options; you may require additional hardware for a cluster (such as SCSI/Fibre HBA's, etc)
One final though is that if you need your servers to be geographically apart (i.e. DR/BCP); then Mirroring would be your best bet; but would need to be made to work with teh SNAC and you need to calculate how quickly your application writes to the transaction log; as you would need a WAN link big enough to cope in order to give you the high availability due to the nature in which transactions are committed.
HTH
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
User asked for assistance as didnt know subject area; posted suggestions to look at technology wise and gave some thoughts into a couple of options and now op has closed thread and marked answer found by himself.
ASKER
Dear,
I got this link from the net, but nobody suggested me so. I got it and did some alterations.
So nothing wrong in it. Did anybody suggested me thiz? I waited to 3 days to get an answer, but i did not. So i found solution for my problem by myself, what is wrong in this.
I got this link from the net, but nobody suggested me so. I got it and did some alterations.
So nothing wrong in it. Did anybody suggested me thiz? I waited to 3 days to get an answer, but i did not. So i found solution for my problem by myself, what is wrong in this.
ASKER
Dear,
Please See My Comments, Where I repeadly said i dont know much about SQL. Is not that enough for an Expert to grab what i mean, what i need. If i dont know much about SQL means to give a clear picture on Low Level. A Simple Solution.
Still i dont have any Issue in distributing Points, But i want to know only is that If i was right or wrong!
Please go through my Comments and aswell as Experts Comments.
With Reards
Please See My Comments, Where I repeadly said i dont know much about SQL. Is not that enough for an Expert to grab what i mean, what i need. If i dont know much about SQL means to give a clear picture on Low Level. A Simple Solution.
Still i dont have any Issue in distributing Points, But i want to know only is that If i was right or wrong!
Please go through my Comments and aswell as Experts Comments.
With Reards