I have been thinking about the changes that occur with the differences between MS SQL Server 2000 and MS SQL Server 2005. Here are some specific steps that should be taken to ensure that you proactively avoid problems with your SalesLogix database. One big item is to adjust the compatibility level.
These steps are very specific to make sure that the process is completed in the best possible manner. I would confirm them with your DBA to determine if he suggests anything additional. There is no ‘undo’ button on the setting changes and it is per database on a SQL server instance setting.
===========================================
Standard Disclaimers
1. Kick off the users.
2. Perform off hours.
3. Back up your database.
===========================================
Steps
1. Change the compatibility level (2000 to 2005 etc.)
2. Run the following scripts in Query Analyzer on the appropriate SalesLogix database
a. Run the statement and review the results
b. If there are messages in the first statement (step 3), run query statement (step 4)
DBCC CHECKDB with all_errormsgs
– This statement may take a while to run, on average 7 to 10 minutes
DBCC UPDATEUSAGE (databasename)
– Will update the database for the differences in the pages and row counts, etc. Replace (databasename) with the actual database name
EXEC sp_MSforeachtable @command1=”print ‘?’ DBCC DBREINDEX (‘?’)”
– This is a standard MS SQL Server 2005 reindex statement
EXEC sp_updatestats
– This is a stored procedure for updating the stats
DBCC CHECKDB with all_errormsgs
– Check the database at the end to make sure everything looks fine
3. Make sure the normal database maintenance tasks and jobs are fully operational
Here is also a helpful reference link: http://msdn.microsoft.com/en-us/library/ms176064.aspx. Let me know if you need additional assistance. We are more than willing to assist, but wanted you to have the information at your disposal.
“Any fool can make things bigger, more complex, and more violent. It takes a touch of genius-and a lot of courage-to move in the opposite direction.”
Albert Einstein
If you would like to learn more tips, or if you have a CRM topic you would like us to write about, please contact Simplesoft Solutions, Inc. in one of our Cincinnati/Dayton (OH), Charleston (WV), or Charlotte (NC) surrounding area office locations:
Dayton, Ohio Office:
Simplesoft Solutions, Inc.
550 N. Main St. Suite A
Springboro, OH 45066
Phone: (937) 885-1204 x 3204
Fax: (937) 885-3580
sales@simplesoft.net
Ripley, WV Office:
Simplesoft Solutions, Inc.
710 Random Rd.
Ripley, WV 25271
Phone: (304) 521-2387
Fax: (937) 885-3580
sales@simplesoft.net
Charlotte, NC Office:
Simplesoft Solutions, Inc.
3635 Eastover Ridge Drive
Charlotte, NC 28211
Phone: (704) 910-3872
Fax: (937) 885-3580
sales@simplesoft.net
Tags: Administrators, MS SQL database, Sage SalesLogix, Sage SalesLogix Administrators, Sage SalesLogix database tips, Sage SalesLogix Deployment
