Great,Plains,Support,MSDE,and, computer Great Plains Support on MSDE and SQL Express: crossing 2GB o
Gone are those times when the companies and the organisations didn't need a hi-tech system to handle them. Owing to the considerable increase in the business sector and thus, an enormous increase in the complexity of the organisational struc ----------------------------------------------------------Permission is granted for the below article to forward,reprint, distribute, use for ezine, newsletter, website,offer as free bonus or part of a product for sale as longas no changes a
MSDE, which is scaled down Microsoft SQL Server 2000 placedthe limit on its database size to be 2GB. Then in 2004, Microsoft Business Solutions came out with incentive toallow Great Plains Standard 7.5 users to obtain registration key for running GPon SQL Server 2000 platform free of charge. If you are crossing 2GB DB limit on MSDN, you should consider thefollowing actions: 1. PurgeTransaction History and then rebuild database. Good idea to work on file rebuilding level. Purging transaction history, however mightnot be a feasible option, especially if your Great Plains users have to look upinto historical data for your customers, vendors, employees, salespeople,etc. Good idea is also check the size ofcompany DB transaction log. 2. Migrateto Microsoft SQL Server 2000 or 2005. Ifyou are on GP version 7.5 likely that this option is not available you willhave to obtain new reg key from Microsoft Business Solutions. If you are on Great Plains Standard 8.0, youwill need to migrate to Microsoft SQL Server 2000. If you are on Dynamics GP 9.0 or 10.0 you caneither migrate to SQL Server Select edition or SQL 2000 or 2005 Standard orEnterprise. Microsoft Business Solutionsrecommend you simply to reattach existing Dynamics and company databases filesto newly installed SQL Server 3. Ifyou do not have support contract with Microsoft and not sure who is yourexisting Great Plains VAR. All writtenabove is definitely cool for those who are current in Dynamics GP annualenhancement program, which allows you to have access to your Customer Source,where you can get your new Great Plains version reg key. If you lapsed in annual enhancement, you willhave to select Great Plains Reseller or consultant, sign Change VAR form toyour new GP Partner, and then your new VAR will have access to your historical GreatPlains Registration Keys 4. FromMSDE 2000 to SQL Express 2005. In SQLExpress you have 4GB DB limit, which is good postponing option, however pleaseknow that you will need to upgrade to at least Great Plains Dynamics GP 9.0. Last warning. If you are subscriber to MSDN or Microsoft TechNet you may have accessto all Dynamics GP versions CD images, however these subscriptions are forevaluation only do not use these CDs for upgrade purpose, if you do not havereg key for targeted version of Dynamics GP
Great,Plains,Support,MSDE,and,