Backup/Restore Issues: Difference between revisions
Jump to navigation
Jump to search
m (1 revision imported) |
Latest revision as of 12:58, 14 July 2023
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.