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

How to list all objects in a given schema?

1106

---

Which are the two editions in which SQL Azure database available?

121

---

List the data types available in mssql?

1102

---

Can binary strings be used in arithmetical operations?

985

---

What is stored procedures?

1110

---

What is coalesce in sql server?

1102

---

How to use old values to define new values in update statements in ms sql server?

1330

---

Explain trigger and its types?

1115

---

Is sql server 2016 free?

979

---

What are scheduled tasks in sql server?

1139

---

What are the restrictions that views have to follow? : SQL Server Architecture

1058

---

How many database files are there in sql server 2000?what are they?

1107

---

Can You Use Data Mining Models In Ssrs?

152

---

How do I view a procedure in sql server?

1037

---

How to list all dsn entries on your local machine using odbc_data_source()?

1089

---