Answer / 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.

In what script is "snap$" created? In what script is the "scott/tiger" schema created?

1 Answers  

---

if monday take full backup and tuesday it was cumulative backup and wednesday we taken incremental backup, thursday some disaster happen then what type of recovery and how it will take?

1 Answers  

---

How to make a replica of existing oracle server to another server?

3 Answers  

---

What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

1 Answers  

---

how do see how much space is used and free in a tablespace

2 Answers   Genpact,

---

What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA

1 Answers  

---

Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.

1 Answers  

---

You're getting high "busy buffer waits" - how can you find what's causing it?

1 Answers  

---

how does an oracle clusterware manage crs resources?

1 Answers   Oracle,

---

How do you troubleshoot errors in a sql server agent job? : sql server DBA

1 Answers  

---

How do you tell what your machine name is and what is its IP address?

4 Answers  

---

What purpose does the model database server? : sql server DBA

1 Answers  

---