When setting up a new instance of SalesLogix on a Microsoft SQL Server I generally setup two maintenance plans using the Maintenance Plan Wizard. Note that if you are using SQL 2005, make sure you are running MS SQL Service Pack 3. There was an issue in earlier versions of SQL 2005 that caused maintenance plans to not run on schedule.

The first plan performs a full backup of the SalesLogix database every night and deletes database backups older than two weeks. Keeping two weeks of backups is up to the clients judgment and hard drive size. Some clients want more backups, others want fewer backups.

The second plan is a SalesLogix Database Maintenance Plan. In this plan I Check the Database Integrity, Rebuild the Indexes, Update the Statistics and Cleanup log files older than two months.

These are the Maintenance Plans that I have found to work. Have any suggestions for better Maintenance Plans?

Posted in:

Infor CRM SLX

Start a Project With Us

Submit your email below to get in touch with our team.

Justin Kuehlthau

Director of Services

Justin is a Customer Relationship Management, CRM, software business analyst and consultant with fifteen years of experience in the industry. Justin started at Technology Advisors on the support desk where he learned extensively about all facets of CRM software. He was quickly promoted to the role of consultant where he learned the entire process of software consulting from pre-sales to post production support. Later he led the SugarCRM Practice and now works as the Director of Services.

Related Content

Solution

Infor CRM SLX

Infor CRM SLX software provides a view of every customer touch point across an organization’s sales, marketing, customer service, and support teams. Technology Advisors has been consulting on, customizing, training, and integrating with Infor for more than 23 years.

Service

Infor CRM Migration

Migrating to Infor CRM should empower your business, not slow it down. With the help of Technology Advisors, Inc. you can start taking advantage of your Infor solution sooner.

Service

Infor CRM SLX Support

Support that quickly and expertly eliminates these issues will drive your long-term success. Technology Advisors' years of Infor experience equips us to guide your issue resolution faster, so you can focus on what really matters: growing your business.

Service

Infor CRM Training

Technology Advisors offers comprehensive, hands-on Infor CRM (formerly Saleslogix) training. We'll guide you through the CRM and teach you how to maximize your user adoption and take full advantage of your CRM power.

Related Blogs

Project Management
,
Infor CRM SLX
,
Field Service Management

From Chaos to Control: Capitalizing on Project & Service Management Software

May 2, 2023

As recently as three years ago, many of our clients were still using Excel spreadsheets to handle internal processes. So, it got me to thinking: have most of us finally been forced to evolve past the spreadsheet, or are there still diehard spreadsheet users out there? I got my answer by talking to our friends at TimeLinx Software. TimeLinx is a project and service management (PSM) solution that automates all the elements of a services organization.

Top 4 Highlights of Infor CRM 8.5

Infor CRM came out with it’s 8.5 release a few months ago and it included several enhancements and features that users will want to take advantage of. In today’s post, we’ll explore the top highlights to look forward to when you upgrade to Infor CRM 8.5.

Infor CRM SLX
,
How To

Tracking How Often a Group is Used in Infor CRM

August 20, 2018

In Infor CRM, there is a database table called GROUPSTATS. It was added in version 8.1. This table tracks how often users select each group.

GDPR
,
Infor CRM SLX

GDPR & Infor CRM

March 22, 2018

What is Infor CRM doing to prepare its system for the GDPR? Let’s take a quick look at how Infor is approaching GDPR compliance and the steps its teams are taking to ensure success.

Infor CRM SLX

Infor CRM Tip: How to Find Specific Attachments

December 12, 2016

I recently helped a client who was looking for a solution that would enable him to find specific attachments quickly based on their intended use. For example, an Account might have several attachments associated with it, but the user may want to know which of those various attachments is being used for which specific purposes. A "specific purpose" might be something like a contract for the account, or a support agreement.