The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!
|
|
Simple Recovery Mode
Posted: 24 Mar 08 2:12 PM
|
| I had the understanding the the recovery mode of the database has nothing to do with the application(s) utilizing the database. With this in mind, I had noticed that our Saleslogix db was was configured for simple recovery mode. We run SLX 6.2.6 in conjunction with Mas500 6.3 using DynaLink to migrate information from one to the other. Why might someone have set the SLX db to use simple recovery, or could it possibly be accidental if someone where looking at the db properties through enterprise manager? |
|
|
|
Re: Simple Recovery Mode
Posted: 25 Mar 08 2:22 AM
|
If I recall, all blank databases (and eval possibly) are set to simple by default. It's trivial to change it to full and back and it shouldn't affect remotes. I'm unaware of anything in SalesLogix that would configure this so it should never change on it's own if that's what you're implying happened.
Jeremy |
|
|
|
Re: Simple Recovery Mode
Posted: 25 Mar 08 7:41 AM
|
| I realize something like the recovery mode will not just change on its own. I was more interested to see why the db might have been set to simple recovery mode. |
|
|
|
Re: Simple Recovery Mode
Posted: 25 Mar 08 9:26 AM
|
| Jeremy answered this, correctly, - if it's never been touched then the database is simple by default. Using EntMgr/Tools would not change that accidentally as you have to be quite specific about changing it from full to simple and vice versa. |
|
|
| |
|
Re: Simple Recovery Mode
Posted: 25 Mar 08 1:48 PM
|
I *think* that all databases default to simple when created but that's coming from a part of my brain I don't use any more so it might not be right.
Likely the reasons Sage kept the default is that it's easier to attach the database when you don't need to worry about the .ldf and they're lazy  .
Having said that I keep my database on Full for the transaction logs. I don't think they're generated in simple mode. Then there's the VSS link that "prefers" simple mode. The ability to take an atomic copy of the database while it's in use is very useful. The ability to recover data within 3 hours versus a day trumps it though. |
|
|
|