Microsoft SQL Server Database Publishing Wizard 1.1 creates an insert statement for every row in your database. To use them for restore purposes you probably have to do some editing. First do it in a test database first which has the same exact structure of  your prod database. Truncate all the tables. Allow identity inserts on the tables, run the inserts and disable identity inserts. If there foreign key restraints, I am sure they are, the inserts have to be done in the proper order. I doubt the wizard creates them in the proper order. The Export wizard doesn't do it.

Depending on the size of the database, the amount of the inserts could be huge but if your host allows SSMS access, you should be OK. There's another tool which allows running SQL from the command line taking input from text files. The host still needs to allow access to sql server from the net.

You can restore DBs on your local machine and then use Publishing Wizard to generate SQL Script that you can execute in your hosting account. Don't forget to check database user after that.

HTH

Regards,

---

Have a nice day,
Arief Iman Santoso

Are you looking for a DotNetNuke Hosting? Or do you need a DotNetNuke Custom Module Development? Contact me!