• Hi subhash,

    Get logical file names as follows

    restore filelistonly from disk='your backup path\filename.bak'

    then restore database as follows,

    restore database database_name from disk='your backup path\filename.bak'

    with

    move 'Logical_name for mdf file' to 'Path where you want to create .mdf file',

    move 'Logical_name for ndf file' to 'Path where you want to create .ndf file',

    move 'Logical_name for ldf file' to 'Path where you want to create .ldf file',

    stats=1

    Note:- Depends on number of your .ndf file use move to part.