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.
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.
Thanks
With Regards
Abhishek Rajiv Luv
"Helpful then please Mark as Answer"
http://www.codeabstract.com/
http://pluralsight.com/training/users/abhishekluv
Marked as answer by wavemaster on Jan 10, 2013 04:40 PM
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.
Thanks
With Regards
Abhishek Rajiv Luv
"Helpful then please Mark as Answer"
http://www.codeabstract.com/
http://pluralsight.com/training/users/abhishekluv
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.
Thanks
With Regards
Abhishek Rajiv Luv
"Helpful then please Mark as Answer"
http://www.codeabstract.com/
http://pluralsight.com/training/users/abhishekluv
wavemaster
Participant
1279 Points
1125 Posts
site maintenance on a live site - database
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.
TIA
Robert
Mikesdotnett...
All-Star
154818 Points
19853 Posts
Moderator
MVP
Re: site maintenance on a live site - database
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.
Beginning ASP.NET Web Pages with WebMatrix | My Site | Twitter
davidsa
Member
210 Points
126 Posts
Re: site maintenance on a live site - database
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.
Abhishek Luv
Participant
1736 Points
468 Posts
Re: site maintenance on a live site - database
Jan 10, 2013 01:46 PM|LINK
@davidsa
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.
With Regards
Abhishek Rajiv Luv
"Helpful then please Mark as Answer"
http://www.codeabstract.com/
http://pluralsight.com/training/users/abhishekluv
wavemaster
Participant
1279 Points
1125 Posts
Re: site maintenance on a live site - database
Jan 10, 2013 04:42 PM|LINK
My site is hosted on the Azure platform.
do you know if there are automatic backups done?
Abhishek Luv
Participant
1736 Points
468 Posts
Re: site maintenance on a live site - database
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.
With Regards
Abhishek Rajiv Luv
"Helpful then please Mark as Answer"
http://www.codeabstract.com/
http://pluralsight.com/training/users/abhishekluv
wavemaster
Participant
1279 Points
1125 Posts
Re: site maintenance on a live site - database
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?
Abhishek Luv
Participant
1736 Points
468 Posts
Re: site maintenance on a live site - database
Jan 11, 2013 12:46 AM|LINK
Yes dear.
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.
With Regards
Abhishek Rajiv Luv
"Helpful then please Mark as Answer"
http://www.codeabstract.com/
http://pluralsight.com/training/users/abhishekluv
wavemaster
Participant
1279 Points
1125 Posts
Re: site maintenance on a live site - database
Jan 11, 2013 01:44 AM|LINK
No maintenance tab in Azure.
for now I can do the manual backup.