Every night you run a full backup after every 3 three hours you make a differential backup every hour you make an incremental backup in a worst-case scenario, how much work you can lose?

0 Answers  

---

Let us say master db itself has no backup. Now you have to rebuild the db so what kind of action do you take?

1 Answers  

---

What is the filtered index?

0 Answers  

---

What are the different types of indexes?

0 Answers   Blue Star,

---

Does a server store data?

0 Answers  

---

---

Explian different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?

2 Answers   HCL,

---

What is filtered index?

0 Answers  

---

Can binary strings be converted into numeric or float data types?

0 Answers  

---

What is Full Outer Join?

3 Answers  

---

What are the components of sql server service broker?

0 Answers  

---

can you any body tell me simple recovery,full recovery,bulk logged recovery where can use?

1 Answers  

---

Explain the concept of view and Types of views in SQL server?

0 Answers   HCL,

---