Thank you all for the inputs I tried with detach and attach...while attaching I got the error like 'e:ew-db.ndf' file is missing

Thanks again for the help.

Regards,

Menaka

no... files are not missing, below is the query I used to check for files and even checked in the drives files are existing.

use master

go

SELECT name, physical_name

FROM sys.master_files

where database_id =...

Hi There,

from the source server bcp out..syslogins and copy to the target server using bcp in command.Hope it will resolve your login issue.

Cheers

Menaka