Initiate Mage
- Joined
- Jun 5, 2017
- Messages
- 1
- Reaction score
- 0
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:
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.
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: