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.

when we use function instead of procedure? plz tell me the situation with ex?

3 Answers   IBM,

---

What is the difference between insensitive and scroll cursor?

0 Answers  

---

What is the difference between cube operator and rollup operator? : SQL Server Architecture

0 Answers  

---

can any body tell me how to know the password of current user in sql server

0 Answers   Crea, HCL,

---

How do you Implement SSIS Packages in your Project?

0 Answers  

---

---

What is constraints and its types?

0 Answers  

---

Tell me about the approaches which you used to counter the DI problems.

0 Answers   EXL,

---

How do you rename a table in sql server?

0 Answers  

---

What does dml stand for?

0 Answers  

---

What do you mean by data integrity?

0 Answers  

---

How can delete duplicate records in cte in sql server?

0 Answers  

---

How many types of database relationship in sql server?

0 Answers  

---