Sorry for the late reply. I received the backup for the database fom my source peoples. Issue solved. Thanks all for your sugessions:-)

Regards,

Sathish.K

:-)thanks a lot guys:-)

Really helpful

i got that..

Could u please help me with any script to move the datas in a database to another database.

this could help me a lot

Thanks in advance:-)

i used this query:

RESTORE HEADERONLY

FROM DISK = N'H:\sample.bak'

WITH NOUNLOAD;

GO

i found '1' in 'backup type' attribute

Its Full backup type.