04 - Backing Up a Terrestrial Application

04 - Backing Up a Terrestrial Application

This tutorial will guide you through the process of backing up data from a terrestrial application that runs on a server, whether it's located in a law firm’s network or a third-party data center.
While we will demonstrate the backup process using ProLaw as an example, the steps are nearly identical for every terrestrial application.

In this tutorial we will:

Before You Start

Required Information

Before starting this process, you should ensure you have the following:

  • A migration workstation that is on the same physical network as the server.
  • The administrator username and password to the relevant server(s)
    • Many apps have a database server and a file server.
    • You should have the administrator login to both.
    • The firm should NOT create a secondary administrator account for you.
      Reason:  Secondary admins often have less permissions than the primary admin.
  • An administrator login into the application
    This should be a login into the application itself.  For example, a ProLaw or Time Matters username.
    Reason:  This is necessary in order cross-check data between the old app and the new one.
  • The cell phone number of your primary point of contact within the firm.
    Reason:  This will allow you reach out if an after-hours issue occurs.
  • The cell phone number of the primary technical contact for the firm.
    Reason:  This will allow you reach out if an after-hours issue occurs.
  • All this information should be documented in your playbook.

Verify Required Information

Once you have gathered the necessary credentials and contact details, you should verify that all usernames and passwords work correctly. Additionally, perform test calls to the provided phone numbers to ensure that everyone can whitelist any relevant phone numbers for smooth communication. 

Backup the Raw (Original) Database

You should Create the Database Backups

We never recommend requesting a backup of a database from a law firm or their tech department.  Instead request access so that you can create the backups yourself.  We recommend having the IT department install TeamViewer on the legacy file server and database server and then retrieving any necessary backups yourself.
 
Many IT departments don't know much about databases.  They often don't know how to make the backups, they send incomplete backups, or backups of the wrong databases.  When you rely on them to create backups, you waste tons of time teaching them how to do things that you could do and you tie yourself to their schedule.

Never Work from a Live Database

Before beginning the backup process, log into the database server and create a backup of the firm's database. Copy this backup to your migration workstation and restore it there.
This is best practice for several reasons:
  • This ensures that you are working from a known point-in-time snapshot of the database. 
  • This protects you from accidentally editing a live database.
  • This protects you from overloading the server as backing-up data is resource intensive.
  • This protects the reliability of the migration as backing-up data from across a network may be interrupted if the remote server undergoes any kind of maintenance such as a reboot or momentary blip in network connectivity.
The steps to backup a raw database are different for each kind of SQL Server.  Please refer to the information for your specific kind of SQL Server.

As you can see in Management Studio, I have already completed this step and am ready to begin.

Launch the Backup Utility

In Universal Migrator, click the Backup button.



Next, choose the system you want to back up data from. In this case, I will select ProLaw.
You can use the search box to quickly find the system you're looking for.


Create a database to hold the backed-up data

On this screen, you can name the cached database.
The default name typically includes today’s date, time, and the system being backed up.
Universal Migrator recommends leaving the default name and appending a tag that indicates which client the backup is for.
For example, I will append TestFirm.com.

Select the database you restored from the firm’s server. In this case, it is the ProLaw database.. Then I’ll click Next.
It will take a few moments as the database is being created for you.

Initiate the Backup

This screen is customized for each platform and shows everything that Universal Migrator can back up.
When backing up data from a terrestrial application, it is generally recommended to back up all data, ensuring you have a complete backup of everything.
Now I am ready to initiate the backup by clicking Next.

Universal Migrator will back up the data as quickly as your hardware allows. During the process, the system reads data from the legacy database and saves a copy to the specified database. Whether it takes minutes or hours, your job is done.  Universal Migrator will handle backing up all the data you requested.


    • Related Articles

    • 03 - Backing Up a Cloud-based System

      This tutorial will guide you through backing up data from a cloud application. While this tutorial will demonstrate backing up data from Clio, the steps are nearly identical for every cloud-based application. In this tutorial we will: Launch the ...
    • 05 - Backing up a File Server

      This tutorial will guide you through backing-up data from a folder structure. This can be a folder from a file server, Google Drive, OneDrive, or any other location that your PC can access as a folder. However, if the folder structure is ...
    • Merging Data into an Existing Application

      This is a highly technical process Experience with SQL queries is necessary to perform Join Migrations. Sometimes you may have customers who have data that needs to be restored into an existing system that is already set up and active. This type of a ...
    • Training: Overview

      Welcome to the Migration Academy! This series will help you learn everything you need to know in order to deliver high-value, rock-solid data and document migrations. Completion of the academy generally takes 4-8 hours and is required in order to ...
    • 02 - General Backup Guidelines

      When backing up data, the process will vary from one application to another, however, there are some general guidelines that you should always follow: Always Backup All Data You Will Ever Need When you are creating a backup, always back up all the ...