Post reply

Restoration of multiple backup files

  • July 20, 2005 at 9:38 am

    #165397

    Hi,

    I have one requirement  in which I need to restore database from one server to another.The problem is full backup file is divided into 3 files.So when I restore data base I am using following syntax (which I got on web)

    RESTORE DATABASE MYDB FROM

    DISK = 'C:\MYDB_1.BAK', DISK = 'C:\MYDB_2.BAK',DISK='C:\MY_DB_3.BAK'

    My question is how I am going to move the data files and log files.

     

    I used Restore filelistonly for each file and found that the data and log files are using extension .dat format instead of .mdf and .ndf.

    I am new to multiple backup files concept.So the syntax for restoring such files don't need to mention data files and log files logical names.

    Any help is appreciated.

     

    Thanks,

    Sree

    Thanks,
    SR

  • July 21, 2005 at 10:17 am

    #576146

    I'm not familiar with using multiple files to backup, but when you restore, the data files and log files are created from the full backup set on the fly.  You might have to to a WITH MOVE 'File1' to 'C:\NewFolder\File1.DAT' if the directory structures are not the same.

    Search Books Online for RESTORE.

    Dylan

    Dylan Peters
    SQL Server DBA

  • July 21, 2005 at 10:45 am

    #576156

    Thanks for your help Dylan.

     

    Thanks,

    Sree

    Thanks,
    SR

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply