You shouldn't create database before restore. It will cause RESTORE command to fail. Either delete DB before restore or specify REPLACE clause in the RESTORE command.

>Hi I want to restore a database using Transact SQL Commands. I excuted the following code, unfortunately, there were reported errors. Is there something that I missed on the code? Please Help...
>
>1. create database mysampdb
>
>2. restore database mysampdb
> from disk = 'd:\mysampdbbak.dat'
>