[_HAWK_]

I has a web hosted server where I added a database. Is there a way to use a database in SSMS to create/restore the server database with schema and data. I have tried to backup the Db I want and use the restore task while I have a connection to the server. I get the following error.



I type the correct path in the next dialog and it fails.

[thava]

i have some suggestion,
1) where is the file, is it in Server or in the local machine, if it is in the local machine transfer it to the server and choose the path where you transfer
2) check you have the read permission for that file

[_HAWK_]

The backup db file is on the local machine created from SSMS. The DB on the server was an empty DB file that I could connect to with SSMS. I am not good at setting permissions on the DBs. The server DB has 2 logins sa and the one I created - the web host does not allow me to see the sa account, and I can use my login just fine. I have been having such a hard time I decided to rebuild the tables in SSMS instead, but would still like to know how to do this via the restore option if poss.

[thava]

you need to transfer the database backup to the server other wise there is no chance to restore the empty db with your current backup, there is an another option you can transfer the db through the scripts, you can generate scripts for the entire database, and just run the script in the server, you can also include some insert script for some predefined data's

see this link
SQL SERVER – 2005 – Create Script to Copy Database Schema and All The Objects – Stored Procedure, Functions, Triggers, Tables, Views, Constraints and All Other Database Objects


SQL SERVER – 2005 – Generate Script with Data from Database – Database Publishing Wizard