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
What authentication modes does sql server support? : sql server DBA
What are the different types of upgrades that can be performed in sql server? : sql server DBA
How do you open a cluster administrator? : sql server DBA
how to restore files with rman?
How to start SQL Server in minimal configuration mode?
What the different components in replication and what is their use? : 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 is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
How do you troubleshoot errors in a sql server agent job? : 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
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
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 can a session indicate its interest in receiving alerts?
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
