• Thanks a lot to all of you for your suggestions.

    I know how to create new databases. But I was first affraid when I got this requirement that I have to transfer the databases from one SQL Server to another SQL Server. I asked the DBA and he sent the back up files and he don't have the access to the other Server. so I did it successfully using SSMS.

    Thank You