Answer Posted / rohit bhosale

Create Database [database_name] On Primary

(

Name='abc', Filename='path_of_mdf_file'

)

log on

(
Name='abc_log', Filename='path_of_ldf_file'

)



Eg:


Create database emp on primary

(
name='emp1', filename='d:\sql\emp.mdf'
)
log on

(
name='emp1_log', filename='d:\sql\emp_log.ldf'
)

How would you extract DDL of a table without using a GUI tool?

2044

---

A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?

1994

---

What are the different types of database compression introduced in sql server 2008? : sql server DBA

564

---

What are the operating modes in which database mirroring runs? : sql server DBA

608

---

When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA

558

---

---

What are the commands you'd issue to show the explain plan for "select * from dual"?

1723

---

What is dcl? : sql server DBA

643

---

Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA

601

---

what is the last version,the release date of that version and fix pack of ibm db2 udb?

1517

---

What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA

587

---

what is a user-defined lock?

584

---

which background process invoke at the time of upgradation tell me???

2223

---

What is the importance of a recovery model? : sql server DBA

550

---

Explain about your sql server dba experience? : sql server DBA

543

---

How do you troubleshoot errors in a sql server agent job? : sql server DBA

561

---