I have been looking for a way to back up my MS SQL database that is hosted remotely, so that in the event of switching hosts or needing to restore I have a complete backup of my database. Using SQL Express 2005 this was not possible as you need to backup to a UNC network share or disk that the actual SQL server can see. This obviously left me with a problem and no backup / restore solution until I found this …

http://www.devnewsgroups.net/group/microsoft.public.sqlserver.tools/topic48318.aspx

If you download the “Microsoft Database Publishing Wizard” you can produce a script of objects and data in your remote SQL server, thus allowing you to perform a restore using a single SQL script. This is obviously not an enterprise solution, but for somebody who has a small remotely hosted MS SQL hosted database,, it can really save you hours of restore time!!