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

Microsoft Dynamics GP The Almighty SQL Server Backup

Posted by Belinda Allen on Apr 17, 2012 4:01:00 PM

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!

Tags: Maintenance, SQL

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

Posted by Belinda Allen on Apr 1, 2012 8:02:00 PM

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?

Tags: Maintenance

A Morning spent with Dynamics GP Passwords!

Posted by Belinda Allen on Apr 1, 2012 8:00:00 PM

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!

Tags: Maintenance

Good Housekeeping offering Advice with Microsoft Dynamics GP?

Posted by Belinda Allen on Apr 1, 2012 7:57:00 PM

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!

Tags: Maintenance