Backing up a database on a shared MS SQL Server is painful. Sure, DTS can make pretty maps with lots of stripey, candy cane looking pipes. But has anyone ever been able to backup and restore a database on a shared hosting server? No. Don’t lie. You’ve never done it.
There’s finally an easy way to do remote backups against a SQL Server. Microsoft has released a utility entitled: SQL Server Hosted Toolkit. And, believe it or not, it actually works.