You are here:
SQL Server 2012 - Microsoft's latest database engine SQL Server 2012 - Microsoft's latest database engine

Microsoft SQL 2005 database publishing wizard for Backup and Restore

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

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!!