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
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
Where do you find the default index fill factor and how to change it? : sql server DBA
I have A,B,C servers.i want to 3 servers jobs move to D server(target server)..how? note: i said that take the backup of msdb and restore to the target server..he said while restoring jobs replaced. what is the solution
What are the commands you'd issue to show the explain plan for "select * from dual"?
how can you communicate with operating system files from oracle?
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
Which autogrowth database setting is good? : sql server DBA
What would you do with an "in-doubt" distributed transaction?
how can you generate profile of pl/sql applications to identify performance bottlenecks?
how can a session indicate its interest in receiving alerts?
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
How to bind a cobol module to a given job? I am not able to understand this concept.Can anyone help me out as how to carry out this task?
Why does Oracle not permit the use of PCTUSED with indexes?
What is the difference between the 2 operating modes of database mirroring? : sql server DBA
What authentication modes does sql server support? : sql server DBA
