Interested to Buy Any Domain ? << Click Here >> for more details...
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 are the different types of upgrades that can be performed in sql server? : sql server DBA
What is dbcc? : sql server DBA
What are the commands you'd issue to show the explain plan for "select * from dual"?
what is ora 24313?what is the procedure to exclude that error?
What are the steps you will take to improve performance of a poor performing query?
What the different topologies in which replication can be configured? : sql server DBA
what is a crs resource?
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.
what are the differences of where and if in SAS?
how can you find out if a table can be redefined?
. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?
What are the different ways you can create databases in sql server? : sql server DBA
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?
how can you create a user-defined lock?
when does an alert gets signaled?
