[Help] DarksTeam MuServer 0.99.60/62T (1.0M) Beta 13 [DB too much GB volume]

[NewEmpire]

Hi,
Who can help to reduce memory for this DB, 244GB is too much for 100 online.

 

[DarkMaster]

Older SQL servers

USE master
BACKUP LOG [MuOnline] WITH TRUNCATE_ONLY
DBCC SHRINKDATABASE([MuOnline], 0)

Newer SQL servers

ALTER DATABASE MuOnline
SET RECOVERY SIMPLE;
GO
DBCC SHRINKFILE (MuOnline_Log, 1);
GO
ALTER DATABASE MuOnline
SET RECOVERY FULL;
GO

 

[Dea7h]

And I am guessing if you don't want it to become this big again in a short period of time, you should skip the last part and use only this:

ALTER DATABASE MuOnline
SET RECOVERY SIMPLE;
GO
DBCC SHRINKFILE (MuOnline_Log, 1);
GO

 

[Damian]

Here is how to reduce DB size using Graphical Interface: