Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post Jan 11, 2013 01:44 AM by wavemaster
Jan 10, 2013 02:45 AM|LINK
As I am still in the early stages of a live site and users are beginning to sign up, I occassionally notice problems that I need to correct.
Not always clear what has happened, so I download my site database.
I am curious if this can be done without disconnecting users that are signed on and are potentially querying the database.
Looking for ideas as alternative to what I am doing now.
Jan 10, 2013 04:51 AM|LINK
You are downloading a copy of the database, so the site will continue to work for all users.
Jan 10, 2013 01:35 PM|LINK
Mike is correct but I would add that if users update the database after you have downloaded a copy - you will not get the latest version. So perhaps you can schedule maintenance at odd hours or do it when on one is online. You can make use of the App_Offline.htm
file to take the website offline. In your App_Offline.htm code, alert the users the website is down for maintence.
Also, you can click the Remote tab in WebMatrix and click Open Remote View. You can open and work on a remote file as you would a local file. When you hit save, the remote file will be updated. Use this with caution to manage your code.
Jan 10, 2013 01:46 PM|LINK
Yes your right.
Website Backup's as well as Database Backup's should be done at the end of the week i.e Saturday or Sunday. I usually do it on sunday's early morning when all my site users are sleeping.
Jan 10, 2013 04:42 PM|LINK
My site is hosted on the Azure platform.
do you know if there are automatic backups done?
Jan 10, 2013 05:28 PM|LINK
No there is no automatic backup. Its an awaited feature on window azure. It would better to do manually backups.
If you do it automatically then it will eat up space on your server every time a backup is created.
You dont need to keep all the backup files on the server you can just keep the last latest create backup file.
Jan 10, 2013 06:23 PM|LINK
When I am loading the site back up I would need to take the site off-line first, correct?
Jan 11, 2013 12:46 AM|LINK
Do you have a Maintenance tab in windows azure from where you can put your site into Maintenance mode or stop the site and
then create backups. If you get 3 to 4 users a week then do backups on week ends, more then that do it alternate days.
Jan 11, 2013 01:44 AM|LINK
No maintenance tab in Azure.
for now I can do the manual backup.