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.

What methods do you follow to protect from sql injection attack?

0 Answers  

---

How to include text values in sql statements?

0 Answers  

---

How to execute a sql statement using mssql_query()?

0 Answers  

---

What are key, name and value columns of an attribute? : sql server analysis services, ssas

0 Answers  

---

How will you find out if there are expensive SQL statements running or not?

0 Answers   Atos Origin,

---

---

Do you know data definition language, data control language and data manipulation language?

0 Answers  

---

can any one post me, how to remove rows in the below table ENO ENAME EDEPT ELOC 3368 BPS BI Adayar 3371 RAN BI valachari 3369 SRI BI valachari 3372 jay BI Chn - - - - - - - -

2 Answers  

---

What is RAID? What are the different types of RAID configurations?

0 Answers   Flextronics,

---

How to handle errors in Stored Procedures. I want to display a message to the user in the .aspx page that is calling a stored procedure in it's code behind. please help me.

2 Answers   247Customer,

---

Do you know exporting and importing utility?

0 Answers  

---

Tell me what are the advantages of using stored procedures?

0 Answers  

---

What is the use of group by clause?

0 Answers  

---