• @gilamonster

    I understand that. But in the target server without creating an empty database i wont be able to restore the database in the target server. when i create an empty database .mdf and .ldf files will be created by default. But my db in the source server has .ndf file. My backup has all the .ndf files, but in the target server those files are not there. Is there a way to create a dummy .ndf file and restore it with the contents form the db backup?

    **thanks for the advice. will create new post in future.**