Solved

How to take daily website backup?

Posted on 2009-06-27
8
764 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
How Do You Stack Up Against Your Peers?

With today’s modern enterprise so dependent on digital infrastructures, the impact of major incidents has increased dramatically. Grab the report now to gain insight into how your organization ranks against your peers and learn best-in-class strategies to resolve incidents.

 
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

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!

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
asp.net figure out error 3 26
Build a string of emails from a gridview 2 18
Secure log in 'box' 4 14
Need to find a web event on the IIS server 4 11
When it comes to write a Context Sensitive Help (an online help that is obtained from a specific point in state of software to provide help with that state) ,  first we need to make the file that contains all topics, which are given exclusive IDs. …
Does your audience prefer people in photos or no people? How can you best highlight what you’re selling? What are your competitors doing, and what can you do that is different and unique from them?  Continue reading to learn how to make your images …
The viewer will get a basic understanding of what section 508 compliance can entail, learn about skip navigation links, alt text, transcripts, and font size controls.
Learn how to create flexible layouts using relative units in CSS.  New relative units added in CSS3 include vw(viewports width), vh(viewports height), vmin(minimum of viewports height and width), and vmax (maximum of viewports height and width).

733 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