Backup and restore

• praku_youth

  SSC Veteran

  Points: 265

  More actions

  January 5, 2010 at 11:14 am

  #214163

  Hi all,

  I have a backup of one database named DB1 with 1 datafile and 1 logfile. Now I need to restore it to DB2 which has 2 datafile and 1 logfile. Is it possible?

  I hope my query will be addressed

• Lynn Pettis

  SSC Guru

  Points: 442467

  More actions

  January 5, 2010 at 11:29 am

  #1099113

  The RESTORE will not add a new datafile. To do so, you first restore the database, then you ALTER it to add the second datafile.