Scheduled Backups?

Is it possible to schedule nightly backups of my SQL 2005 database so that I can simply grab the .bak file off my web site?
I'd like to avoid having to log in to the control panel every night to do this manually.

 

Of course I have absolutely no idea of the method you guys are using for that but theoretically isn't it possible to create a DTS package for this sort of thing?

 

Bruce,


I am very intersted in this topic. Would it not make sense to allow me to automate the Backup of my SQL database and FTP that file to my local server? Once I have the .bak file, I can do as I please and know my data is safe.


At the end of the day, a website is useless without data. If my SQL database is corrupted, andI dont have a recent backup, my business willgo bust. I am sure many othersites are in the same position.


As you could understand, it is unreasonable to ask me to log on, and make a manual backup, then copy it to my server on a daily basis. Or even more regularly.


Is there anyway this can be automated? DTS is not good enough.


Thanks,


Peter

 

Sounds like you'll have to buy some software, or create a custom solution.


There is no way for us to PUSH sql backups to your local machine.


The only way for you to transfer the data from the REMOTE server to your LOCAL server is to PULL the data.


One thing we could schedule is the automatic backup to your REMOTE website (which is local for us). Though we haven't seen a demand for this (or much of a use either, since it's still REMOTE to you).



Joel Thoms
DiscountASP.NET
http://www.DiscountASP.NET

 

Thanks Joel.

I understand you cant PUSH anything to me, but if you can schedule a backup on your server on a specific interval, that would be great. Once that is done, I can grab that file and make a backup to my server.

How can i schedule this backup to happen?

Thanks.

 

Yes, that's what I was asking for in the first post of this thread. Keeping my fingers crossed!

 

Currently you can't. This feature has been brought up to our marketing team. It's up to them whether this gets put into the pipeline or not.


Joel Thoms
DiscountASP.NET
http://www.DiscountASP.NET

 

Could we create a custom solution using a scheduled task that hits a .aspx or .ashx page that contains .net code to perform a backup?

Do our normal SQL IDs have "backup" permissions?

Thx.

 

I don't think you'll be able to do this with a scheduled task. Our backup does a lot more than run SQL commands.


Joel Thoms
DiscountASP.NET
http://www.DiscountASP.NET

 

I'll like to add my voice to this request.
We really need a reliable, consistant backup of our SQL database. Having to login everynight and manually create it is not acceptable.

I'll be looking to see is some tool or 3rd party software can pull the data on a scheduled basis. If not we most likely will have to move our site.

If I come up with a alternitive solution, I'll post.
-GP

 

Bruce,
How do I get access to the nightly database backup?
Regards

 

Yes... I'd like to chime in with my support for access to dated automatic SQL backups. The 'killer app', in my mind, would be access to the last 7 days (or possibly even 14 twice-daily backups over the last 7 days) which we can download at our convenience. I'd also be willing to pay for this added peace of mind!

 

Nightly backups or even twice daily backups are essential for me. I will have to do these manually but I'd be over the moon if you introduced this as an automated service. My DB is critical and if I lost ANY data two years of development work would quite literally go down the pan. I don?t think it would be unreasonable for you to charge a premium for this service either ? I?d happily pay it.

Keep up the good work though ? you are by far the best host I have ever used and I?ve used a lot!

 

That's why it's a paid add-on! Instead of leaving it up to each individual to create their own local backup program, just charge $10/month (or whatever) for an extra gig of diskspace to have the 7 day rotating backups. It could even be on a different server or different FTP site from the hosting account. (That may even be better) I think that would satisfy most users backup needs.

Just trying to provide some feedback. It could be another revenue stream for DASP!