Forum Discussion
Sharepoint with SQL Always On
Hello
please recommend help me about two solution
1. Sharepoint one farm wih Sql Always On
With solution then only one farm in DC and DR .and if i want create one database Test on sharepoint with DR side then can not ?
2. SHarepoint with two farm
- I will build SQL always one (1 for DC and 1 for DR)
- and I will install two farm depend in two DC and DR
- But with Contend database i will add it to availiable group
So with this way i can create Test DB on DR site and can backup Content and can running contend backup in DR
please recommend help me
Best Regards,
Thanks
What is the business case you're trying to solve?
The first option looks like a Stretched-Farm and the second option is a traditional DR farm approach.
I'd suggest to create the backups from your primary farm because it will probably run with Full Recovery model in SQL and the proper backup strategy will help keeping the transaction log's storage need low.
I suggest to take a look at this article Stretched SharePoint Farms vs. Disaster Recovery SharePoint Farms and follow all links in it as well.
And also read this longer guidance as well:
Create a high availability architecture and strategy for SharePoint Server
4 Replies
What is the business case you're trying to solve?
The first option looks like a Stretched-Farm and the second option is a traditional DR farm approach.
I'd suggest to create the backups from your primary farm because it will probably run with Full Recovery model in SQL and the proper backup strategy will help keeping the transaction log's storage need low.
I suggest to take a look at this article Stretched SharePoint Farms vs. Disaster Recovery SharePoint Farms and follow all links in it as well.
And also read this longer guidance as well:
Create a high availability architecture and strategy for SharePoint Server
sassdawe : this link i can not access https://blogs.msdn.microsoft.com/sambetts/2014/04/17/stretched-sharepoint-farms-vs-disaster-recovery-sharepoint-farms/ . do you have another link
Thanks
I have Sam's blog exported.
You can find 9 of his posts in this pdf: http://bit.ly/2HRLeK9 72 pages :)
