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

what is Full Text Search ?

1 Answers   TCS,

---

What is the difference between cross join and Full outer join?

1 Answers   HP, Standard Bank,

---

What is the meaning of resultset type_scroll_insensitive?

0 Answers  

---

What is impersonation? What are the different impersonation options available in ssas? : sql server analysis services, ssas

0 Answers  

---

Why transaction is important?

0 Answers  

---

can we have a nested transaction? : Sql server database administration

0 Answers  

---

How to modify the underlying query of an existing view?

0 Answers  

---

How do you clear a log file?

0 Answers  

---

Accidentally i deleted my table. How can i get that table?

4 Answers  

---

Can we use where and having clause together?

0 Answers  

---

Explain the use of containers in ssis?

0 Answers  

---

How does using a separate hard drive for several database objects improves performance right away?

0 Answers  

---