Setting up your Database environment for integrations and general GP management

When I take a new job the first thing I do after reviewing the database status (backups, Recovery Model, logs etc) is to create a Sandbox database.  This is a database that I use to stage imports into GP and to store quick table backups as I modify data.  The underutilized QBE interfaced is, for certain operations, faster and more reliable.

A quick example.  Purchasing tells you that a new item just entered gives the error "UOM Does not exist..."  You look at the usual suspects for missing setup on the item but nothing pops.  Finally you look at the iv00106 table and notice that there is no entry for that SKU.  The first thing I do is to back up the table to the sandbox database before I modify it.