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 are the operating modes in which database mirroring runs?

0 Answers  

---

How to create a user to access a database in ms sql server using "create user" statements?

0 Answers  

---

What is the difference between primary key and unique constraints?

0 Answers  

---

How to test values returned by a subquery with the in operator?

0 Answers  

---

what is diffence between replicaion and logshipping?

1 Answers  

---

---

how to avoid cursors? : Sql server database administration

0 Answers  

---

What is ems sql management studio? : sql server management studio

0 Answers  

---

What is RAID? What are the different types of RAID configurations?

0 Answers   Flextronics,

---

What is a periodical index?

0 Answers  

---

what r steps to we need to fallow b4 kill the process?

1 Answers   Verizon,

---

How can I know what query is executing by by a particural user? (using sp id or any othe way.)

2 Answers  

---

How to list all stored procedures in the current database using ms sql server?

0 Answers  

---