<< Hardware failure, SQL Server edition | Home | Seriously, 32mb? My cell has more memory than that >>
SQL Backups in a hosted environment!
posted on Monday, May 12, 2008 10:20 PM |

So I'm in the process of switching to a new hosting service and I had a friend hook me up porting my data via an SSIS package to my new server.  Now I'm when most would call a retard when it comes to SQL.  I can design databases but I dread doing SQL.  That is why Joe ruled for doing this for me.

I did a few quick laps around the internet and can up with nothing.  SQL Server's tools are designed to back up the database locally only.  So if you don't have physical access, you're out of luck.

After asking around internally, one of my awesome coworkers pointed out there is a tool to do just this called the Microsoft SQL Server Database Publishing Wizard 1.1.  Another tool looks to be on CodePlex called SQL Host.

Tags [ Coding General Computer Knowledge ]

Your Comments.

  • # re: SQL Backups in a hosted environment!

    Clint, these days many hosts provide a web based tool for sql backup and restore. The most common of these is by mylittletools.com. In fact, Applied Innovations provides such a tool, email support and they'll get you the url.

    Left by Jess at 5/15/2008 9:27 AM
  • # re: SQL Backups in a hosted environment!

    Thanks Jess, my old hosting provider didn't provide such tools so I was left in the dark wondering how to pull this off.

    Left by Clint Rutkas at 5/15/2008 7:40 PM
Post Comment
Title *
Name *
Email
Url
Comment *  
Please add 3 and 2 and type the answer here:
Friends
Microsoft
Archives
Post Categories