hosted by liquidweb


Go Back   Web Hosting Talk : Web Hosting Main Forums : Web Hosting : Need host that lets me do my own MSSQL backups
Reply

Forum Jump

Need host that lets me do my own MSSQL backups

Reply Post New Thread In Web Hosting Subscription
 
Send news tip View All Posts Thread Tools Search this Thread Display Modes
  #1  
Old
Junior Guru Wannabe
 
Join Date: Sep 2005
Location: Glendale, AZ
Posts: 84

Need host that lets me do my own MSSQL backups


I'm currently with HostNexus and I've been told by their tech support that I need to submit a ticket every time I want one of my databases backed up. This is not going to work anymore and I need to find a new host that will allow me to create and FTP the backups to my home server.

My requirements:
  • At least 1GB disk space
  • Bandwidth won't matter as much right now
  • Allow me to have at least 15-20 domains on my account, I run a few different sites
  • Allow me to create a decent number of MSSQL databases (more than 5)
  • No MSSQL size quote (just let it subtract from the overall disk space)
  • A few MySQL databases
  • Both ASP.NET 2.0 and PHP 5
  • I need to be able to run that MSSQL backup via a Scheduled Task or something

I pay $20 but could go up to $30 if it has all the features + more space. DiscountASP.net seemed to have it all but I could only host one site per account and that just won't work. I did LOVE the thought of having a web service I could use to back up the DBs, though.



Sponsored Links
  #2  
Old
Website Hosting Specialist
 
Join Date: Oct 2003
Location: UK
Posts: 3,095
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.

__________________
Chris D | Director
Cyber Host Pro Ltd - over 10 years in the UK hosting industry.
Website Hosting | Reseller Hosting | Cloud VPS Servers | Dedicated Servers
www.cyberhostpro.com - UK Call Centre + 24x7 Online Chat

  #3  
Old
Newbie
 
Join Date: Mar 2006
Posts: 25
Crystaltech control panel has SQL backup/restore function, just check if they charge you for that though.

Sponsored Links
  #4  
Old
Junior Guru Wannabe
 
Join Date: Sep 2005
Location: Glendale, AZ
Posts: 84
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.

  #5  
Old
Junior Guru Wannabe
 
Join Date: Sep 2005
Location: Glendale, AZ
Posts: 84
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?

  #6  
Old
Quality Guaranteed..
 
Join Date: Feb 2007
Location: USA, Singapore, Amsterdam
Posts: 3,028
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!

__________________
Softsys Hosting USA, Inc. - 100% Performance Oriented Hosting - Denver & Chicago (US), Amsterdam (EU) & Singapore (Asia)

KVM Linux VPSHyper-V Windows VPS From 4 Locations (USA, EU, Asia) IaaS Cloud VM's Bare Metal Dedicated Servers

  #7  
Old
Junior Guru Wannabe
 
Join Date: Sep 2005
Location: Glendale, AZ
Posts: 84
Quote:
Originally Posted by sure123 View Post
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.

  #8  
Old
Website Hosting Specialist
 
Join Date: Oct 2003
Location: UK
Posts: 3,095
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?

__________________
Chris D | Director
Cyber Host Pro Ltd - over 10 years in the UK hosting industry.
Website Hosting | Reseller Hosting | Cloud VPS Servers | Dedicated Servers
www.cyberhostpro.com - UK Call Centre + 24x7 Online Chat

  #9  
Old
Junior Guru Wannabe
 
Join Date: Sep 2005
Location: Glendale, AZ
Posts: 84
Quote:
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.

  #10  
Old
Junior Guru Wannabe
 
Join Date: Sep 2005
Location: Glendale, AZ
Posts: 84
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.

  #11  
Old
Web Hosting Evangelist
 
Join Date: May 2003
Location: Wilmington, NC
Posts: 460
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.

__________________
Allen Burnett StormHosts aburnett@stormhosts.com
Professional MS ASP, .Net, MS SQL 2000/2005 and Reseller Hosting Since 2001
Clustered servers @ Equinix Helm/cPanel/WHM/VPS/colo/Dedicated/MailFoundry anti-spam/Server Mgmt

  #12  
Old
Junior Guru Wannabe
 
Join Date: Sep 2005
Location: Glendale, AZ
Posts: 84
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

http://www.codeplex.com/ScriptDB

So I will stay with my current host

  #13  
Old
New Member
 
Join Date: Feb 2008
Posts: 1
Quote:
Originally Posted by SoftsysHosting-Rick View Post
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

  #14  
Old
Quality Guaranteed..
 
Join Date: Feb 2007
Location: USA, Singapore, Amsterdam
Posts: 3,028
Quote:
Originally Posted by tblankers View Post
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,

__________________
Softsys Hosting USA, Inc. - 100% Performance Oriented Hosting - Denver & Chicago (US), Amsterdam (EU) & Singapore (Asia)

KVM Linux VPSHyper-V Windows VPS From 4 Locations (USA, EU, Asia) IaaS Cloud VM's Bare Metal Dedicated Servers

  #15  
Old
Web Hosting Master
 
Join Date: Oct 2007
Location: United States
Posts: 1,172
Which MS SQL 2005 are you trying to backup? Are you using Express, Workgroup, or Standard edition?

__________________
www.DMEHosting.com - DME Hosting LLC | Servers, KVM/OpenVZ VPS's, Email Hosting, Web Hosting


Reply

Related posts from TheWhir.com
Title Type Date Posted
Web Host Code Spaces Closes Shop After Hacker Deletes Customer Data Web Hosting News 2014-06-19 16:34:41
Enterprises Improve SLAs with Disaster Recovery in the Public Cloud: Forrester Web Hosting News 2014-05-08 12:09:27
CloudOpt Launches Speed-as-a-Service for Windows Azure Cloud Web Hosting News 2013-10-21 10:40:59
Barracuda Network Releases Version 5.4 of Cloud Backup Solution Web Hosting News 2013-08-26 12:18:47
VaultLogix Launches New Version of Hybrid Cloud Backup Solution Web Hosting News 2013-07-30 10:44:21


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes
Postbit Selector

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Forum Jump
Login:
Log in with your username and password
Username:
Password:



Forgot Password?
WHT Host Brief Email:

We respect your privacy. We will never sell, rent, or give away your address to any outside party, ever.

Advertisement:
Web Hosting News:
WHT Membership
WHT Membership



 

X

Welcome to WebHostingTalk.com

Create your username to jump into the discussion!

WebHostingTalk.com is the largest, most influentual web hosting community on the Internet. Join us by filling in the form below.


(4 digit year)

Already a member?