Cascade Database settings (MSSQL Server)

Joel Trauger's Avatar

Joel Trauger

01 Dec, 2014 06:11 PM

Quick question for the masses. My transaction logs are full and my server crashed recently because it ran out of HDD space.

So...

Should the database recovery be set to FULL or SIMPLE? I do nightly backups so FULL isn't exactly necessary, right? I don't remember if the requirements for the Cascade Database are that it be set to FULL since it does it's own version of rollback on assets...or if it relies on the FULL recovery of the database to do just that.

  1. Support Staff 1 Posted by Tim on 20 Apr, 2015 04:15 PM

    Tim's Avatar

    Hi Joel,

    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 this page has a pretty good comparison between the two methods.

    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.

    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.

    I hope this helps!

  2. Tim closed this discussion on 20 Apr, 2015 04:15 PM.

  3. Joel Trauger re-opened this discussion on 20 Apr, 2015 04:26 PM

  4. 2 Posted by Joel Trauger on 20 Apr, 2015 04:26 PM

    Joel Trauger's Avatar

    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.

    Joel Trauger
    Webmaster
    Office of Marketing and Communications
    Henderson State University<http://www.hsu.edu>
    Box 7823 • Arkadelphia, AR 71999-0001
    870-230-5356

  5. Support Staff 3 Posted by Tim on 20 Apr, 2015 04:30 PM

    Tim's Avatar

    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!

  6. Tim closed this discussion on 20 Apr, 2015 04:30 PM.

Comments are currently closed for this discussion. You can start a new one.

Keyboard shortcuts

Generic

? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac