Becci No Comments

GoldMine – Detach and Attach the GoldMine Database

As the GoldMine Administrator there may be times when you need to detach and/or attach the GoldMine database.  Some examples would be to move or copy the files, remove or add a restored database or when connecting other databased to the SQL Server.

To Detach a SQL Database:

  1. EVERYONE MUST BE LOGGED OUT OF GOLDMINE.
  2. Open SQL Server Management Studio.
  3. Connect to SQL Server.

The server name should be the LOCALMACHINENAME\INSTANCENAME

Authentication:  SQL Server Authentication

Login: sa username

Password: sa password

  1. Click the Connect
  2. Expand the Databases section in the Object Explorer on the left.
  3. Right-click on the database to detach and choose Tasks –> Detach. The Detach Database window opens.

  1. If there is a message that there are still active connections, check the box under Drop Connections.

  1. Click OK to detach the database.
  2. The database name (e.g, GoldMine) will be removed from the Databases list on the left. The data files are now disconnected from the SQL Server and can me moved, copied, etc.

To Attach a SQL Database:

  1. Open SQL Server Management Studio.
  2. Connect to SQL Server.

The server name should be the LOCALMACHINENAME\INSTANCENAME

Authentication:  SQL Server Authentication

Login: sa username

Password: sa password

  1. Click the Connect
  2. Right-click on the Databases section in the Object Explorer on the left and choose Attach. The Detach Database window will open.

  1. Click the Add The Locate Database Files window opens.
  2. Navigate to the folder the backup is in on the left and select the actual backup file on the right.

  1. The database will display under Databases to attach and the file details will display in the lower section. Click OK to attach the database.
  2. The database name (e.g, GoldMine) will be added to the Databases list on the left. The data files are now connected from the SQL Server and can used in applications and queries.
  3. If you don’t see the database name in the list and you did not receive an error, right-click on the Databases section and choose Refresh.
Becci No Comments

GoldMine – Backing Up the GoldMine Database

Before you make changes to the GoldMine database such as importing records, doing multiple merge purge actions, or global replaces, a quick backup of the can be a life saver.  Backing up the database will also be needed if you are moving the server or saving archives.

To back up the GoldMine database:

  1. Open SQL Server Management Studio.
  2. Connect to SQL Server.

The server name should be the LOCALMACHINENAME\INSTANCENAME

Authentication:  SQL Server Authentication

Login: sa username

Password: sa password

  1. Click the Connect
  2. Expand Databases on the left and right click on GoldMine. Choose Tasks –> Back Up.  The Back Up Database – GoldMine window opens.

Database:  GoldMine

Recovery Model:  SIMPLE

Backup Type:  Full

Backup component:  Database

Back up to:  Disk

If a database location is displayed, select it and click the Remove button.

Click the Add Button and then click the Browse (…) button to navigate to the location you want to store the backup file. (e.g., C:\GoldMIne\Backup).

Enter a File name:  e.g., GoldMineBackup5-8-19.bak

  1. Click
  2. The location/file path will display in the list. Click on it to select.
  3. Click the OK button at the bottom of the window. The backup will begin.
  4. Progress will be displayed in the bottom left of the window under Progress.
  5. When the backup is done a message will display.

  1. Click OK and the windows will close.
Megan Hagedorn No Comments

Dynamics 365: Bulk Edit Records

Bulk editing a group of records is easy to do and can save quite a bit of time–as long as the edit you need to make is allowable in the Bulk Editing menu! You do not need to have the field you want to edit displayed in a given view, but any records you wish to edit must be displayed in the current view.  If your view has 300 records in it, you’ll have to perform the bulk edit once per page.  Keep reading to learn how to bulk edit records! Read more

Megan Hagedorn No Comments

Office 365: Pin Apps to the App Launcher

When you log in to Office 365 via portal.office.com, you’ll see an assortment of Apps that you can immediately open:

But what if an app that you frequently access is missing? It’s easy to add application shortcuts to the app launcher; keep reading to learn how!
Read more

Megan Hagedorn No Comments

Office 365: Manage Tasks with Microsoft To-Do

Did you know that Microsoft has a dedicated task manager called To-Do?  That’s right–it’s more than the “tasks” element of Outlook and OneNote.  In fact, beginning in March, Microsoft began rolling out a new Web Outlook Task experience–powered by To-Do. In this post, we’ll go over some To-Do basics. Read more