SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 High Availability (2008)
 AlwaysOn FCI + Transaction Log Shipping
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

allidav80
Starting Member

4 Posts

Posted - 07/29/2014 :  09:13:00  Show Profile  Reply with Quote
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

USA
37134 Posts

Posted - 07/29/2014 :  12:44:00  Show Profile  Visit tkizer's Homepage  Reply with Quote
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 - 07/30/2014 :  03:33:50  Show Profile  Reply with Quote
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 - 07/30/2014 :  06:19:45  Show Profile  Reply with Quote
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

USA
37134 Posts

Posted - 07/30/2014 :  12:45:31  Show Profile  Visit tkizer's Homepage  Reply with Quote
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 - 07/31/2014 :  11:27:51  Show Profile  Reply with Quote
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
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000