Belinda Allen, Smith & Allen Consulting, Inc. (SACI) aka Belinda the GP CSI.  Microsoft Professional, MCT and MVP.describe the imagedescribe the image

Belinda supports

Follow Me


If you are not a member of the Microsoft Dynamics GP Community, you should be, I am a member.

There is loads of good information, including a forum that I actively answer.

Click on this link to go to the Microsoft Dynamics Community!

Search this Blog


Subscribe by Email

Your email:

Need Microsoft Dynamics GP Forms?

Purchase Deluxe Products

Click on the image above to find your compatible Microsoft Dynamics GP forms from Deluxe For Business.

Click HERE to download Brochure.

This is all about how I use GP, based on what I learned in my investigations with clients...

Current Articles | RSS Feed RSS Feed

Microsoft Dynamics GP The Almighty SQL Server Backup

Today I walk you through backing up in SQL Server 2008 R2 AND directly in Microsoft Dynamics GP! There are some activities that TRULY need a backup BEFORE you proceed. This video shows 2 ways to achieve successful backups.

This is so important; I felt the need to bring it up again. See Backups? I don't need no stinking backups!! from July, 2010 where I talked about backups!

Belinda (the GP CSI) Allen
Tags: ,

Backup? I don't need no stinking (Dynamics GP) Backup!


Are you backing up before you perform certain key tasks such as year end close, check links, or reconciling (Inventory, AR, AP, not Bank Reconciliation) in Microsoft Dynamics GP?????

If not, you are playing with fire.

To be "fire-free" you have 2 options:
1-Perform these tasks first thing in the morning, then the previous nights backup will suffice.
2-Walk to the physical server, log in as "sa" (or have IT do this) and click File-Backup. This is an easy way to backup both the Dynamics database and your company databases. Of course if IT does this, they may perfer to backup using SQL Server, which is GREAT!

Now, protect yourself further. Ask your IT department or your MSVAR (Microsoft Value Added Reseller) to show you the backup plan and perform a test restore, and do this on a regular bases (once a month or once a quarter.)

I like to have an additional company called "TEST" and I perform restores on this database. This has dual purposes, you test your backup and you have a database of your real data that you can play with, and train on without affecting your live data.

And finally, the question I get asked all the time...

Q: How often do I have to backup?

A: How much data are you willing to lose?
Belinda (the GP CSI) Allen

A Morning spent with Dynamics GP Passwords!

I just spent the morning working with a client improving passwords.

If your Microsoft Dynamics GP uses SQL 2005 or higher, you can set policies that make sure passwords are set appropriately, so use that!

When you make passwords, keep in mind the rule of thumb to use Upper Case, Lower Case, Numbers and/or Symbols. Do not use an actual word or name.

Write your password like you are writing a License Plate.
Gr8tPlainz instead of Great Plains

Also make it at least 6 characters, 8 or more is better.

Common Passwords: 123456, Jesus, Password, Love, etc.

Don't be Common, not in life or passwords!
Belinda (the GP CSI) Allen

Good Housekeeping offering Advice with Microsoft Dynamics GP?

On my flight home to NYC today I was reading through the July 2010 copy of Good Housekeeping and right there with with how to organize your garage, how to load a dishwasher and how to strip paint off wood was a section on "How to Unfreeze Your Computer."

I read the small article and agree with it for most home users. The article said if your machine is frozen, press Ctrl + Alt + Delete keys to open the Task Manager and select the program that is "Not Responding" and "End task." This is not bad advice.


If the program "Not Responding" is Microsoft Dynamics GP (or Great Plains), do not be so quick to "End Task." Since GP uses a SQL Server database, not all work is actually performed on your machine, some is performed on the server. If work is being performed on the server then GP may say "Not Responding" because it's waiting for something (from the server.) Just be careful about ending task on GP.

Good Housekeeping is a great magazine, one of my favorite reads, but it is not intended to be your advisor on Microsoft Dynamics GP!
Belinda (the GP CSI) Allen
All Posts