tag:help-archives.hannonhill.com,2010-02-09:/discussions/installation/3452-cascade-database-settings-mssql-serverCascade CMS: Discussion 2015-04-20T16:30:30Ztag:help-archives.hannonhill.com,2010-02-09:Comment/354265752015-04-20T16:15:09Z2015-04-20T16:15:09ZCascade Database settings (MSSQL Server)<div><p>Hi Joel,</p>
<p>I was going through some open discussions and realized you never
got a response from anyone on this. Were you able to figure this
out? I'm certainly no SQL Server expert, but <a href="https://technet.microsoft.com/en-us/library/ms175987%28v=sql.105%29.aspx">
this page</a> has a pretty good comparison between the two
methods.</p>
<p>In the event of a failure in your case, I think that as long as
you're OK with the prospect of losing any changes that may have
been made between that time and the previous night's backup, you
should be fine using SIMPLE backups.</p>
<p>From the application's perspective, all versions are stored in
the database itself as records and the system doesn't rely on any
particular backup methods in order to roll assets back to previous
versions.</p>
<p>I hope this helps!</p></div>Timtag:help-archives.hannonhill.com,2010-02-09:Comment/354265752015-04-20T16:26:07Z2015-04-20T16:26:07ZCascade Database settings (MSSQL Server)<div><p>I figured out that I can do nightly backups and it will be fine.
We publish on a one-per-day basis, so if the system crashes after
the publish, we can just ask our users to redo their page edits
from the live website. It seems to be an acceptable model.</p>
<p>Joel Trauger<br>
Webmaster<br>
Office of Marketing and Communications<br>
Henderson State University<a href="http://www.hsu.edu">http://www.hsu.edu</a><br>
Box 7823 • Arkadelphia, AR 71999-0001<br>
870-230-5356</p></div>Joel Traugertag:help-archives.hannonhill.com,2010-02-09:Comment/354265752015-04-20T16:30:29Z2015-04-20T16:30:29ZCascade Database settings (MSSQL Server)<div><p>Thanks for the update, Joel. This seems to go along with what
the majority of our clients do (regardless of database vendor).
Have a good one!</p></div>Tim