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'
)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
how can you process messages in order asynchronously?
what is logical system in sap basis
What are statistics, under what circumstances they go out of date, how do you update them?
What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA
what are the benefits of flashback feature?
Why would you use sql agent? : sql server DBA
What the different types of replication and why are they used? : sql server DBA
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
What are the operating modes in which database mirroring runs? : sql server DBA
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
currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba
What are the different types of database compression introduced in sql server 2008? : sql server DBA
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
What are the different sql server versions you have worked on? : sql server DBA
What are the recovery models for a database? : sql server DBA