What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA
- 1 Answers
- 1134 Views
- I also Faced
- E-Mail Answers
Answer Posted / Ankur Varshney
High availability solutions in SQL Server include database mirroring, log shipping, AlwaysOn Availability Groups, and SQL Server Failover Cluster Instance (FCI). Database mirroring provides data redundancy with automatic failover support. Log shipping allows for backup and recovery of databases across multiple servers. AlwaysOn Availability Groups provide higher scalability by combining database mirroring and log shipping. SQL Server FCI is a more traditional high-availability solution that requires shared storage.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com
what is the last version,the release date of that version and fix pack of ibm db2 udb?
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
