Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeDevelopment and...Development and...SQL and SQL Ser...SQL and SQL Ser...DNN not working with read-only databaseDNN not working with read-only database
Previous
 
Next
New Post
3/20/2015 4:08 AM
 

Recently I've tried to optimize my DNN backup script to ensure 100% website availability by allowing IIS to work during DB and filesystem backup process. The problem is: if I set DB to read-only mode, DNN fire HTTP 500 error and complaining about it could not update DB as it read-only.

 
New Post
3/20/2015 4:49 AM
 

Roman,

even if it seems that no one enters data: DNN logs a lot of things into the database (as page visits, errors, user logins, etc. etc.) - so setting the db to read only results in exactly those errors.

During the DB backup, there is no reason to stop IIS. The backup always happens in a consistent state, at a specific point of time. The only "problem" could be when you backup the files, as some cache and/or log files could be locked by the application pool. This is not really a problem when restoring the files in regard of a working web site.

Of course: If you want  to ensure that the files and the database are consistent (because of tables referencing files for example) then you should stop the application pool, make a backup of the database and the files and starting the app pool again.

Happy DNNing!
Michael


Michael Tobisch
DNN★MVP

dnn-Connect.org - The most vibrant community around the DNN-platform
 
New Post
3/20/2015 4:51 AM
 
use Backup options of SQL Server instead of backing up database files yourself.

Cheers from Germany,
Sebastian Leupold

dnnWerk - The DotNetNuke Experts   German Spoken DotNetNuke User Group

Speed up your DNN Websites with TurboDNN
 
New Post
3/20/2015 5:55 AM
 

I do DB backup via osql utility, then goes filesystem backup via archiver.

 

 

 
New Post
3/20/2015 6:29 AM
 

If app. pool isn't stopped, and user (or come other agent) makes website filesystem changes after DB backup and initial files listing done by archiver utility,  then 3 (well, at least) cases may happen:

1) If user adds new files in that time, archiver just not lists them, and DB backup (done before) just not contains references to them. In case of full restore needed, those newly added files will be lost - but it's OK, as some part of work will be lost anyway.

2) If user changes files content in that time, achiver will add changed files to backup, and DB already contains references to them (maybe with some desync about file size, etc.) So it also OK.

3) But if user deletes some files in that time, archiver already listed them (but they will not be added to filesystem backup, as there are no such files), but DB backup will still contain references to deleted files.

Point 3 is the main concern - how those references to non-existant files will be treated by DNN?

 
Previous
 
Next
HomeHomeDevelopment and...Development and...SQL and SQL Ser...SQL and SQL Ser...DNN not working with read-only databaseDNN not working with read-only database


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out