Solved

How to take daily website backup?

Posted on 2009-06-27
8
757 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
  • 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
 
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
Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

 
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

Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Server error in 'XXXXXXXX' application. 12 51
asp.net bundle 8 36
modify h2 4 20
ASP.NET Web API or ASP.NET Core MVC? 3 32
Deprecated and Headed for the Dustbin By now, you have probably heard that some PHP features, while convenient, can also cause PHP security problems.  This article discusses one of those, called register_globals.  It is a thing you do not want.  …
Read about why website design really matters in today's demanding market.
This tutorial will teach you the core code needed to finalize the addition of a watermark to your image. The viewer will use a small PHP class to learn and create a watermark.
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.

746 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now