Thanks

yes i have tried in T-SQL also using following command

RESTORE DATABASE <YourDatabase>

FROM DISK='<the path to your backup file>\<YourDatabase>.bak'

But i am facing following error.

Msg 3241, Level 16, State 7,...