Backup/Restore Issues

From KeystoneIntranet
Revision as of 12:58, 14 July 2023 by WikiAdmin (talk | contribs) (1 revision imported)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

Backup/Restore Issues

Before Restoring a company database, check this! (version 4.0.1+)

Because of the new logic introduced in Keystone 4.0.1 that can automatically resume a failed database upgrade script at the point of failure, there is an additional step that you should do BEFORE restoring a company database backup.

  • Open Notepad by right-clicking the Notepad icon and selecting "Run as Administrator."
  • Open the file "C:\ProgramData\GivenHansco\Keystone\Settings\ccwibsv.ini" in Notepad.
  • Here is a sample of this file:
[SMTP]
IPAddress=
IPPort=25
UserId=
Password=
MailFrom=KEYSTONE Application Server
[DBUpgrade]
127.0.0.1:D:\CCGH\DATA\ccw001.ib=5
127.0.0.1:D:\CCGH\DATA\ccw002.ib=7
[IBServer]
DatabaseName=<cp Name="Server Name" Default=127.0.0.1>:<cp Name="Database Path" Default=[ccrootdir][custdatadir]><sp Name="DatabaseName">.ib
OldDatabaseName=<cp Name="Server Name" Default=127.0.0.1>:<cp Name="Database Path" Default=[ccrootdir][custdatadir]><sp Name="DatabaseName">.gdb
[ConnPool]
DefPoolMaximumItems=17
  • If you see the database you are trying to restore listed in the DBUpgrade section, delete the ONE line for the database you are restoring.
  • Save the file.
  • Proceed with the company restore.