How to fix .exe database restoring error.

Results 1 to 1 of 1
  1. #1
    Newbie curirin107 is offline
    MemberRank
    Jun 2017 Join Date
    1Posts

    wink How to fix .exe database restoring error.

    If you are having trouble restoring Tales Runner database with the .exe file (collation error, file/filegroup error), then here goes a fix!

    You will need to run this script on SQL Server before running the .exe:

    Code:
    CREATE DATABASE TR_GAMESVR_DB;
    GO
    ALTER DATABASE TR_GAMESVR_DB MODIFY FILEGROUP SECONDLY1 DEFAULT;
    ALTER DATABASE TR_GAMESVR_DB ADD FILEGROUP SECONDLY1;
    
    ALTER DATABASE TR_GAMESVR_DB ADD FILE(FILENAME = '{dbfile}.ndf', NAME = 'TALESDB') TO FILEGROUP SECONDLY1;
    GO
    
    ALTER DATABASE TR_GAMESVR_DB COLLATE Korean_Wansung_CI_AS;
    GO
    Replace {dbfile} with a location + filename where the database will be stored by SQL Server, but mantain extension (.ndf).

    After that, execute the .exe backup and run it by upgrading the created database, not creating a new database.
    Last edited by curirin107; 07-06-17 at 03:09 AM.




Advertisement