Answer Posted / amit kumar sharma

Logshipping: Database are restored using the transition log
maintained by the db. If db dosen't maintained the
transition log then you will not able to restore the db.
Set Maintain Transition log of db to 'true' in db
environment variable.

Mirroring : Its just a spanshort of the actual database at
some schedule interval. or rather say just a copy of LDF
and MDF file taken at a particular time.

How to read data in a table with "select" statements?

967

---

What is shrink log file?

897

---

Can we create clustered index on composite key?

1082

---

What is the report model project?

141

---

What is the difference between getdate and sysdatetime?

1005

---

What factors you will consider calculating the storage requirement for that view?

949

---

What do you mean by sql server 2005 express management tools?

1305

---

What is temporal data type?

921

---

Explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?

1113

---

Can sql servers linked to other servers?

1041

---

What are different types of schemas?

947

---

What is dirty page?

973

---

What are cursors? Explain different types of cursors. What are the disadvantages of cursors? How can you avoid cursors?

1169

---

Explain transaction server distributed transaction?

979

---

How to filter out duplications in the returning rows in ms sql server?

1140

---