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.

Explain transaction server isolation?

0 Answers  

---

why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it? : Sql server administration

0 Answers  

---

Can we move Resource database from one path to another? If yes,How can we?

1 Answers   Wipro,

---

What are the disadvantages of using the stored procedures?

0 Answers  

---

Explain how to send email from sql database?

0 Answers  

---

When would you use a before or after trigger?

0 Answers  

---

When I run the sql server 2000 setup, it just hangs. What do I do?

0 Answers  

---

code to create procedure for taking databse backup in sql server or i have the query for it but what it's query returns means i want to show on my jsp that the databse backup has been taken on the basis of that return value.does it returns 0 or 1.wat is the code for that

0 Answers   IGT,

---

Why we need sql server?

0 Answers  

---

Delete duplicate rows from a table without primary key by using a single query Table Employee empname salary A 200 B 300 A 200 C 400 D 500 D 500 Output should be A 200 B 300 C 400 D 500

14 Answers  

---

how to restart sql server in single user mode? How to start sql server in minimal configuration mode? : Sql server database administration

0 Answers  

---

What is the difference between osql and query analyzer?

0 Answers  

---