Solved

How to take daily website backup?

Posted on 2009-06-27
8
765 Views
Last Modified: 2012-05-07
Hi,

I am fairly new to web-development.

I would like to know following:

(a) At what intervals should site backup be taken?

(b) By site backup, I believe we are talking about database backup right?

(c) How to do database backup...and how to restore it if site is not hosted on dedicated server...i.e. you are hosting it on some commercial web-host?
0
Comment
Question by:meetpd
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
  • 2
  • +1
8 Comments
 
LVL 12

Assisted Solution

by:techExtreme
techExtreme earned 100 total points
ID: 24730219
Well there are number of possibilities depending upon your web host and functionalities provided by them.
For example, if they allow you to take your db backup online through their cpanel or something, you'll have to do it manually.
If you are using database in asp.net site like aspnet mdf  inside the app_data folder, you can through your code copy the file at regular intervals in appropriate location or something like that for backup purposes.
0
 

Author Comment

by:meetpd
ID: 24730254
I dont see app_data folder on my webserver. Where is it located?
0
 
LVL 12

Expert Comment

by:techExtreme
ID: 24731863
If your site is created using asp.net and if you are using the aspnet inbuilt database (the mdf file basically), then it must be there in the app_data folder inside your root. i.e. if your while site is in a folder say 'html',  then the app_data folder will be under html as well.

Kindly confirm what type of database you are using.
If you are using for example godaddy.com, then they provide database services wherein you need not to use such database, instead database is created using your username and is stored in a different place. So it depends on the host/ t ype of hosting that you buy.
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 13

Accepted Solution

by:
Onthrax earned 300 total points
ID: 24732565
(a) At what intervals should site backup be taken?

This would be at your own disgression and is also dependant on the update interval. If the database only gets updated once a week, you shouldn't backup each day, but if your database gets updated daily or even every minute you should backup every week. If you provide a little more information about the exact website we could advise better.

(b) By site backup, I believe we are talking about database backup right?
Not just the database, you'll need to backup your files as well. Not just the files that are part of the code, but also any uploads done by your users.

(c) How to do database backup...and how to restore it if site is not hosted on dedicated server...i.e. you are hosting it on some commercial web-host?
As techExtreme has already mentioned, this fully depends on the package and host you are using.
0
 
LVL 4

Expert Comment

by:vbgb
ID: 24734537
If you are using a commercial web hosting provider, they will almost invariably backup all your web site files and any SQL databases automatically - usually at least once a day. This is for their own security as if you are paying to have your site hosted, they are responsible for ensuring that your files are safe in the event of anything happening to the hardware.

Some hosting proividers will make a charge if you ever need to restore the files, unless it is needed because of a hardware failure.

If you host a site on your own dedicated server, then you need to implement your own backup strategy for all files and databases on the server.
0
 
LVL 13

Expert Comment

by:Onthrax
ID: 24734909
This is for their own security as if you are paying to have your site hosted, they are responsible for ensuring that your files are safe in the event of anything happening to the hardware.

One shouldn't assume this. There are numerous times I've heard of people losing everything because the hosting company does not create backups, or stores the backups on the same server (read: Hard Drive) as the website, so when a HD fails so will the backup.
I'm not saying all hosting company's do this, but there's loads of differences between hosters.
0
 
LVL 4

Assisted Solution

by:vbgb
vbgb earned 100 total points
ID: 24735048
Onthrax - agreed! You obviously need to check and check again the web host terms and conditions to ensure that backups are provided.

Having said that it is difficult to run your own backups on a shared server, other than simply copying the files within your own webspace (so on the same hard drive), which is hardly safe! You could copy over ftp to a local machine, but doing this regularly could take a long time, particulalrly where you end up with large database files (most providers store SQL databases on seperate servers that you cannot access anyway so you need to rely on the hoster to back these up, unless you can copy  to a local server using DTE (for which you need the full version of SQL Server Managament Studio
0
 
LVL 13

Expert Comment

by:Onthrax
ID: 24735193
There are cheaper and simpler solutions. For example KLS Backup software. This can fetch all files from an FTP and (if permitted by the host) can backup the database as well. One can set a schedule so all goes automatically.
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Dramatic changes are revolutionizing how we build and use technology. Every company is automating, digitizing, and modernizing operations. We need a better, more connected way to work together as teams so we can harness the insights from our system…
When the s#!t hits the fan, you don’t have time to look up who’s on call, draft emails, call collaborators, or send text messages. An instant chat window is definitely the way to go, especially one like HipChat. HipChat is a true business app. An…
Explain concepts important to validation of email addresses with regular expressions. Applies to most languages/tools that uses regular expressions. Consider email address RFCs: Look at HTML5 form input element (with type=email) regex pattern: T…
This tutorial walks through the best practices in adding a local business to Google Maps including how to properly search for duplicates, marker placement, and inputing business details. Login to your Google Account, then search for "Google Mapmaker…

691 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question