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.

 All Forums
 SQL Server 2008 Forums
 High Availability (2008)
 AlwaysOn FCI + Transaction Log Shipping

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 Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

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
Go to Top of Page

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?
Go to Top of Page

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 Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

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
Go to Top of Page
   

- Advertisement -