Need host that lets me do my own MSSQL backups

[emperor3740]

Have you tried asking them if they would create a SQL job that would perform the backup for you? Most host would not have a problem with that. Depending on your database size, it should only take a few seconds for the server to completely backup your db.

[rooper88850]

you could try this..

BlackBall SQL Agent
http://software.techrepublic.com.com...x?docid=302490

[dragon2073]

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

[emperor3740]

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

Hi Terry,

My apologies for the inconvenience caused to you. As HELM 3 does not provide a backup/restore functionality, we need to perform these tasks manually. However, we can definitely arrange for creating a scheduled task which will back up your database daily and place it in a specific folder in your domain. Just open a support request for the same and tech support guys will take care of the same. But I regret to inform you that as of now, you will need to contact us to perform database restores.

Thanks,

[emperor3740]

I finally found a tool that will run from my home server and back up my databases. I just save the command line to a .cmd file and schedule it to run every night :agree:

http://www.codeplex.com/ScriptDB

So I will stay with my current host

[dragon2073]

Hello,

I believe most of the problem is that the MS SQL servers are not going to be running Web servers and services. They are usually secured pretty tightly also. This makes the job harder for the script as it will have to copy to another location or vlan to drop it off in your FTP/domain area.

However, this should not stop you from being able to use .Net, DTS, etc. to export (backup) the data to your home/development server or elsewhere.

Hope this helps, good luck w/ your search and best wishes.

[emperor3740]

I'm starting to think that I won't find a shared host with the features I need so now I'm researching a cheap VPS. I'm hoping I can find something in the $30-$35 range but that is probably the most I can handle at the moment.

[emperor3740]

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

I haven't found anyone that would let me do it from a script. If I get to that point it would be trivial to put the script in a Scheduled Task on my home server.