1. If a server migration or new installation was completed, back up the NpsSqlSys from the previous system: File > Backup > NpsSqlSys.
  2. Copy the NpsSqlSys into the SQL backup folder on the new system.
  3. Restore the NpsSqlSys to the new system:  File>Restore>NpsSqlSys and choose the back file to restore from.
  4. If a server migration or new installation was not performed, then the NpsSqlSys might have become corrupt.
  5. Contact support to have a blank NpsSqlSys restored and then create new users.
Additional Information: 

Backing up Database

You can back up and restore all organization databases and the system database (NPSSQLSYS) for the current version.

When running a backup, the system creates an uncompressed copy of the database.  You can back up any database while users are in the system. However, to restore a database, all users must exit the system.
  1. Find the backup directory on your server.
  2. Log on to Administration.
  3. Open the File>Backup form.
  4. Select the database you want to back up from the Database to Backup drop-down list.
  5. Accept the default name (the database name, date, and time) or enter another name in the Backup to File box.
  6. If needed, click the Browse button and select the backup directory.
  7. Click the Start button, and the log on screen appears. Log on to the system.

Restoring Database

  1. Log on to Administration.
  2. Open the File>Restore form.
  3. Select the database to restore from the drop-down list. If this is the first time a database has been restored, its name is not available in the drop-down list; you must enter a name here.
  4. Enter the name in the Restore to File box.
  5. Click the Browse  button to locate the file.
  6. Click the Start button.

Required Tags:

Article Type: 
Product Info
Product Line: 
MIP Fund Accounting
Product Module/Feature: 
Auto Updates
Data Issues
Data Management
Table Maintenance
Technical Issues

No votes yet