Need host that lets me do my own MSSQL backups

[emperor3740]

Hi

Does it have to be automated? Could you not use a script to download a local copy of your Database to your local computer?

[emperor3740]

How about creating a scheduled task with a host which will back up your database and place it in a specific folder of your domain? There are lot of sql scripts/utilities available for the same provided your host allows you to run scheduled task.

Good luck!

That's all I really want to do. If I can get a .sql or .bak file in my domain folder I'd have no problem creating a job to FTP it home. The problem is none of the hosts I've talked to will copy my DB to my domain folder on a nightly basis. Either that or they want $5 per month per DB which would be doable if I only had 1 but right now I've got 3 and could see creating another handful in the future.

[emperor3740]

How about creating a scheduled task with a host which will back up your database and place it in a specific folder of your domain? There are lot of sql scripts/utilities available for the same provided your host allows you to run scheduled task.

Good luck!

[emperor3740]

CrystalTech is out for now. I can create my own backups in their control center which will save to my web root but I cannot automate it according to their support team.

If I can't find anyone else maybe I could use snoopy or something to spoof it but I'd rather find someone with a tool already built. It can't be that uncommon to actually want to back up your own data, can it?

[emperor3740]

Ironically enough, I've interviewed to work at CrystalTech. I like their plans but my initial search of there forums resulted in a few posts where a CT employee said you could create a backup but you had to create a ticket to have it moved to your space.

That was from last May though so I submitted a ticket with them to ask if there is an automatic method now.

[emperor3740]

[rooper88850]

Hi

You will need an application my MyLittleBackup to Backup & Restore databases. This application is not cheap that is why not all hosts offer it, or MyLittleAdmin which is another premium Addon for SQL.

You wont be able to schedule backups but you can login and click backup then download it to your PC.

[emperor3740]

[dragon2073]

Which MS SQL 2005 are you trying to backup? Are you using Express, Workgroup, or Standard edition?

if its a hosting company, it will be Workgroups or above.

[rooper88850]

How about creating a scheduled task with a host which will back up your database and place it in a specific folder of your domain? There are lot of sql scripts/utilities available for the same provided your host allows you to run scheduled task.

Good luck!

Rick, do you allow this at SoftSysHosting? And do you allow customers to perform their own restores? I assumed this was available and after signing up I can't seem to find any information on how to do it. I contacted tech support to restore my DB which they did some 4 hours later. I'm actively looking for another hosting company unless I can find a way to do this - backup & restore - at SoftSysHosting. Thanks for any insight/help.

Terry