Maintenance Issues

[jloftin]

Using Great Plains 7.5 with SQL 2000. I now that updating SQL statistics and recompling SQL stored procedures are recommended for monthly maintenance are there any other recommended monthly procedures (checking links, reconciling tables), etc... Any help would be appreciated, this has sort of been put upon me quickly.

 

[barbola]

Customer source has all this info.

Thanks!
Barb E.

 

[Luvsql]

Depending on how big your databases are, I would run the database maintenane wizard and schedule them on a weekly basis. It will run all the necessary DBCC statements for you in order to keep itself stable.

 

[jloftin]

Barbara

Thanks. I looked around customer source but I didn't see anything in the knowledge base, white papers, etc... Serching on maintenance didn't provide a whole lot either. If you know where to look that would be a great time saver.

 

[jloftin]

Luvsql

I have the SQL maintaince set to perform all of the normal tasks. I just wasn't sure if there was something else that needed to be done from within GP.

Thanks

 

[Dukester0122]

On the database side its mostly DBCC commands. In GP, our monthly task includes but not required to paid transaction removal, removal of completed POs, Remove Discontinued Items and Sold Receipts, etc.

 

[barbola]

You are right! I thought I remembered seeing it, but maybe that was a year-end check list.

Check links and reconciling should be done monthly, but we don't even do that. The complete backup and SQL stats etc are done weekly (scheduled).

It was suggested to us that inventory gets reconciled daily - yeah right! We do it monthly.

Okay, so I'm no expert....yet.

Thanks!
Barb E.