Creating a Database Backup for your GoldMine SQL Database
Back in January, we posted a blog article on Creating a Database Maintenance Plan for your GoldMine SQL Database. A maintenance plan typically involves automation for tasks such as Checking the Database Integrity, Rebuilding the Index, Backing up the Database, etc.
What if you needed to make some changes to your GoldMine database, but just wanted to take an ad-hoc database backup? Before making any system-wide changes such as creating fields, importing data, and running GoldMine Maintenance, we always recommend to take a full GoldMine database backup. Here's how to do this:
Launch Microsoft SQL Server and log in with an account with Administrator Access (usually Windows Authentication or "sa" for SQL Server Authentication).
Expand the "Databases" tree, right click the GoldMine Database, and select Tasks, then Back Up...
The "Back Up Database" Window will open
Give the Backup set a descriptive name
Remove the default Destination Directory and then click "Add"
Select a Backup Destination
You can browse out to a file directory location to save the physical backup file
Select OK to close off the remaining Windows.
Once this Window comes up, the Backup process is now completed.