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 can you process messages in order asynchronously?

959

---

what is logical system in sap basis

1623

---

What are statistics, under what circumstances they go out of date, how do you update them?

2228

---

What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA

1091

---

what are the benefits of flashback feature?

1003

---

Why would you use sql agent? : sql server DBA

1061

---

What the different types of replication and why are they used? : sql server DBA

1159

---

Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?

1893

---

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

1157

---

can u plz tell me what r the mandatory skills for getting job as a sql dba......plz send me all details thank you my id :k.mohann.mohan@gmail.com

1738

---

currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba

2422

---

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

1080

---

Typically, where is the conventional directory structure chosen for Oracle binaries to reside?

2603

---

What are the different sql server versions you have worked on? : sql server DBA

996

---

What are the recovery models for a database? : sql server DBA

1115

---