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 mixed authentication mode of sql server?

0 Answers  

---

What are the new features in sql server 2016?

0 Answers  

---

What is a filestream?

0 Answers  

---

how to know Who Is Blocking Your SQL Server?

4 Answers  

---

What is the purpose of floor function?

0 Answers  

---

---

how to find the particular row in table?(means suppose one table contain 10 rows , in these 10 rows how to find the particular row(example in 10 rows i want 5 row how)?

16 Answers   Accenture, IBM, Marlabs,

---

How many databases Microsoft SQL server provides?

0 Answers   Abacus,

---

Insert syudents details in table.Current system date &time insert into joining time.How do insert?( in sysdate only return current system date how do add time?)

0 Answers  

---

Which language is supported by sql server?

0 Answers  

---

How to find index size for each index on table?

0 Answers  

---

How to delete all rows with truncate table statement in ms sql server?

0 Answers  

---

ehat is the default port no of sql 2000?

2 Answers   IBM,

---