can u be more detail for how to reduce their size?
Open SQL Server Management Studio
Connect:
Server tyle: Database Engine
Server Name: 192.168.200.100
Authentication: SQL Server Authentication
Login: Crimson Desert
Password: BlackNo.1Game#^%
The Login and Password are default, you should use your own if you changed it.
In the Object Explorer on the left side, find SA_BETA_GAMEDB_0002, right click and make a backup first just in case or you can skip the backup if you want.
open its Properties,
In the Option tab, set
Recovery Model: Simple
Auto Shrink: True
then OK
On the top of SSMS window, click on New Query, type CHECKPOINT then click on execute, then the size of SA_BETA_GAMEDB_0002 will be reduced.
Let me clarify, the thing you want to shrink is a transaction log file that is called SA_BETA_GAME_0003 log. it is bound to SA_BETA_GAMEDB_0002 and taking a lot of space. Shrink the log will not affect your saved game data. You don't really need to shrink it if the size is less than 10GB in my opinion.
After the original file is shrank, you need to change Auto Shrink: True to False , or it will reduce to the minimum size which is only good for 1 to 2 days.
You can set the size of SA_BETA_GAME_0003 log to a certain value in the Properties now. It should be the 4th in the File tab. The file will grow over time when you play the game. Based on its minimum value, give it another 5GB should be good for the next 100ish hours.
You can always check its usage. Just right click on SA_BETA_GAMEDB_0002 in the Object Explorer, Task, Shrink , File
File Type : Log
File name: SA_BETA_GAME_0003
It will show you available free space. You can use the CHECKPOINT command again in New Query when you see the percentage is low.
I am new to SQL and this is my noob way to do it. I heard that pros can set automatic checkpoint so you won't need to keep an eye on it anymore. I appreciate if somebody can share a better way.
Thank you very much it is convenient and works well
