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 are constraints? Explain different types of constraints? : Sql server database administration

0 Answers  

---

i want to create procedure for create table in sql server 2005 for example create procedure create_table @table varchar(20) as create @table( id int, name char(20) ) but it will get error what is solution?

5 Answers   Aptech,

---

What stored by the model?

0 Answers  

---

Tell me what do you mean by an execution plan? Why is it used? How would you view it?

0 Answers  

---

What is the purpose of linked server configuration in sql server?

0 Answers  

---

What part does database design plays a role in performance of an sql server-based application?

0 Answers  

---

What is analysis service repository?

0 Answers  

---

You are creating an application where users are asked their gender in the gender combo box you have three options: ‘male’ , ‘female’ and ‘i choose not to disclose’ these options are stored in the table as 1, 0 or null which datatype should you use?

0 Answers  

---

What are clustered and non-clustered index?

0 Answers  

---

What is a virtual table in sql?

0 Answers  

---

What are the system database in sql server 2005?

0 Answers  

---

Explain what is use of dbcc commands?

0 Answers  

---