Yahoo Answers is shutting down on 4 May 2021 (Eastern Time) and the Yahoo Answers website is now in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Hi Folks, Need some help on SQL Server database. I have a situation on a busy system (500 transactions/second) where we have two needs?
-Big need is for disaster recovery, if server/db go down we need to port things over to second automatically.
-Little need is for data availability on a secondary server for reporting needs. Could be delayed a bit
Need input on the following, as in what will work for the two needs above.
-Availability Group
-DB Mirroring
-Replication
-Log shipping
Here is the setup
Windows server 2012 R2 standard
Microsoft SQL Server 2014 standard
Ty so much in advance
1 Answer
- Anonymous5 years ago
Not a good choice. You would be far better off using a local web based system using the Apache web server and mysql database, preferably on a Linux server. You can easily use data replication.