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.

How can you append an identity column to a temporary table?

0 Answers  

---

How do you rebuild an identity column?

0 Answers  

---

What are the advantages of having an index on the sql server?

0 Answers  

---

how to update a null value field in sql server eg a table contains 3 fields id,name,salary and 3 records salary of 1 record is null i want update the nullfield 111 arun 300 112 ddd 200 113 ttt null i want to update table with add 100 to every record include null after updation the recrds should be 111 arun 400 112 ddd 300 113 ttt 100

6 Answers   ABC, HCL,

---

What is database replication? What are the different types of replication you can set up in sql server?

0 Answers  

---

What is the significance of master, tempdb and model databases?

0 Answers  

---

Explain the difference between primary keys and foreign keys?

0 Answers  

---

Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?

0 Answers  

---

How to grant a permission in ms sql server using "grant execute" statements?

0 Answers  

---

what is the primary use of the model database? : Sql server administration

0 Answers  

---

Plz tell about backup&recovery?

3 Answers  

---

What is the beast way to write CTE in SQL Server ?

0 Answers   HCL,

---