Cascade Database settings (MSSQL Server)
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.
Discussions are closed to public comments.
If you need help with Cascade CMS please
start a new discussion.
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
Support Staff 1 Posted by Tim on 20 Apr, 2015 04:15 PM
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!
Tim closed this discussion on 20 Apr, 2015 04:15 PM.
Joel Trauger re-opened this discussion on 20 Apr, 2015 04:26 PM
2 Posted by Joel Trauger on 20 Apr, 2015 04:26 PM
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
Support Staff 3 Posted by Tim on 20 Apr, 2015 04:30 PM
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!
Tim closed this discussion on 20 Apr, 2015 04:30 PM.