Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
allidav80
Starting Member
4 Posts |
 Posted - 2014-07-29 : 09:13:00
|
| Hi Everybody,I need to implement in my company the High Availability for our SQL Server instance. My question is if is it possible to configure a two node Failover Cluster Instance and, on the same nodes, the log shipping solution? Thanks.Regards,Davide |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2014-07-29 : 12:44:00
|
| Yes you can, though I'm not sure why you'd want to. Why not Availability Groups instead or even database mirroring? I use log shipping as the last, last, last resort.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
 |
|
|
allidav80
Starting Member
4 Posts |
Posted - 2014-07-30 : 03:33:50
|
| Hi Tara, thanks for your reply. I've discarded the Availability Group solution because we have a SQL Server Standard Edition and the Enterprise license is too much expensive. The mirroring solution was also discarded because Microsoft say that this feature will be removed in a future version of Microsoft SQL Server and it advises to avoid using this feature in new development work. So, what did you recommend for a good High Availability solution? Thanks in advance for your reply.Regards,Davide |
|
|
|
allidav80
Starting Member
4 Posts |
Posted - 2014-07-30 : 06:19:45
|
| My big doubt is: if the two nodes of Failover Clustering share the same SQL data files, how is it possible for the log shipping do a backup from the primary server and restore it on the secondary? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2014-07-30 : 12:45:31
|
quote:
Originally posted by allidav80
My big doubt is: if the two nodes of Failover Clustering share the same SQL data files, how is it possible for the log shipping do a backup from the primary server and restore it on the secondary?
I'm confused. You want to log ship within the same cluster? Why? Failover clustering provides high availability already. The only reason to add log shipping, in my opinion, would be to "mirror" the databases to another cluster, such as for DR purposes.You should still use mirroring over log shipping. It is a viable solution in all supported versions. Don't worry about the deprecation until after version 2014. I assume Microsoft will provide a Standard edition option for AG.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
|
|
|
allidav80
Starting Member
4 Posts |
Posted - 2014-07-31 : 11:27:51
|
| Tara, thanks for your valuable informations. I think that the Mirroring is the best solution for my Company.Regards,Davide |
|
|
|
|
|
|
|
|
AlwaysOn FCI + Transaction Log Shipping