What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA

987

---

What happens on checkpoint? : sql server DBA

1031

---

When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA

949

---

Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down? : sql server DBA

973

---

What is fill factor? : sql server DBA

1182

---

What is the default port no on which sql server listens? : sql server DBA

1084

---

What is the difference between dropping a database and taking a database offline? : sql server DBA

1013

---

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

1051

---

What are the commands used in dcl? : sql server DBA

995

---

What are the operating modes in which database mirroring runs? : sql server DBA

1106

---

What is a system database and what is a user database? : sql server DBA

1113

---

How do you open a cluster administrator? : sql server DBA

1033

---

Which autogrowth database setting is good? : sql server DBA

1058

---

List out some of the requirements to setup a sql server failover cluster.? : sql server DBA

1188

---

Where do you find the default index fill factor and how to change it? : sql server DBA

1022

---