3610 PointCentral Data Backup

Several different tasks are required to complete the entire backup process:

  • Stopping IIS and CalyxPDSFileSync
  • Backing up PointCentral data folders and templates
  • Backing up the PointCentral SQL database
  • Restarting PointCentral

Perform these tasks in the sequence provided.

Important: Store the PointCentral data folders, templates, and the PDS SQL database back up data on another computer or external drive to preserve your data in the event of a server failure.

 

Stopping IIS and CalyxPDSFileSync

Note: PointCentral and any website hosted on the PointCentral server are unavailable during this process.

  1. Go to Start > Runon the PointCentral server.
  2. Enter cmd in the Open field and click OK.
  3. Enter iisreset/stop and press <Enter> to stop the PointCentral admin and service.
  4. Enter netstop CalyxPDSFileSync and press <Enter> to stop PointCentral FileSync.

3610 a

Backing up PointCentral data folders and templates

Use your preferred method to back up the PointCentral data files and templates. However, before you begin, check the root directory path on the PointCentral administration site to verify the Calyx Software directory location.

To back up the PointCentral SQL database:

    1. Log in to the PointCentral administration site.
    2. Select Configuration > Parameters.
    3. Note the Root Folder Path.

      The Root Folder Path contains all the data folders on the PointCentral server. The default path is …Program Files (x86)\Calyx Software\PointCentral\filesync\DataFolders. This path can vary depending on your server configuration.

       3610 b
4. Copy the entire Calyx Software directory to the backup location.

Tip: Sites with fewer than 50 users can support Microsoft SQL Express, a lighter version of SQL Server which is easier to manage for smaller organizations without an IT staff or trained database managers. 

The Connect to Server dialog box is displayed.

 3610 c

5. The password should be the same sa password you defined when SQL was installed.

The Microsoft SQL Server Management Studio screen is displayed.

 3610 d 3610 e 3610 f

6.The destination for the backup data is displayed in the Destination section.

 3610 g 3610 h 

 

Restarting PointCentral

Restart PointCentral when the PointCentral backup is completed.

To restart PointCentral:

    1. Go to Start > All Programs > Microsoft SQL Server > SQL Server Management Studio on the PointCentral server.
    2. Enter the PointCentral Server Name (and if needed, the SQL Express instance name, separated by a backslash), for example, PDS-SVR\SQLEXPRESS. This can vary depending on your environment.Select SQL Server Authentication from the Authentication dropdown list.
    3. Enter sain the Login field.
    4. Enter the password in the Passwordfield.
    5. Click Connect.
    6. Expand the Databases directory, right-click PDS, and select Tasks > Back Up….
    7. Select Full from the Backup type dropdown list.
    8. Specify Database as the Backup component.
    9. Click Add.
    10. Enter the path for the PointCentral SQL database backup file.
    11. Click OKto begin the backup process.3610 i

12.Users can now log back in to Point and access their loan files.

    1. Click Start > Run on the PointCentral server.
    2. Enter cmd in the Open field and click OK.
    3. Enter iisreset/start and press <>Enter>.
    4. Enter net start CalyxPDSFileSync and press <Enter>.
    5. Exit the command prompt.