@steve-2 Jones

Hi,

Could you please be more specific on how to backup .ndf file. Today i ran into the same kind of issue. I took the backup of the db through " SQL Server Management Studio Express 2005 " and tried to move it to a new server. I created a empty database in the target server with the database name ( which created .mdb and .ldb file alone ) and tried to restore it. Now my problem is that, how can i restore a .ndf file? I taught of taking the files by stopping the service. but you told it's not a good way. So please suggest me a way to restore the database.

Thanks in advance.