PS_GameLog_Data Doubts, Help

[trysten]

I noticed that PS_GameLog_Data over time is becoming a gigantic file. greater than 10GB. I would like to know without some way to clean the logs without affecting the server's functions and configurations. because it is consuming a lot of space on my machine. Someone can help in this part.
Sorry my english google translator

[XareL]

idk but if u want clear logs execute this query ;

DELETE FROM PS_GameLog.dbo.ActionLog ---- clear in game actions
DELETE FROM PS_ChatLog.dbo.ChatLog ----- clear in game chats

[[MXD]Takeshi]

Originally Posted by XareL

idk but if u want clear logs execute this query ;

DELETE FROM PS_GameLog.dbo.ActionLog ---- clear in game actions
DELETE FROM PS_ChatLog.dbo.ChatLog ----- clear in game chats

Hello, sorry but from delete you dont clear ur IDENTITY....
use this command for clear all...

TRUNCATE TABLE PS_GameLog.dbo.ActionLog
TRUNCATE TABLE PS_ChatLog.dbo.ChatLog

also you wanna clear all tables of database?
use this command...

USE PS_GameLog
EXEC sp_MSforeachtable 'TRUNCATE TABLE ?'

all table of ps_gamelog clear

[XareL]

you may only need to delete certain tables, as some special databases may have plugins for ps_gamelog.

[[MXD]Takeshi]

Originally Posted by XareL

you may only need to delete certain tables, as some special databases may have plugins for ps_gamelog.

is right.... i has just add a few commands is possible that someone other need it
anyway i has understand that him need clear only data, just for clear use this command "TRUNCATE", for remove something use "DELETE"

[{Skrillex}]

Hi,
i think you have to shrink your database too.

Regards

[trysten]

Originally Posted by [MXD]Takeshi

Hello, sorry but from delete you dont clear ur IDENTITY....
use this command for clear all...

TRUNCATE TABLE PS_GameLog.dbo.ActionLog
TRUNCATE TABLE PS_ChatLog.dbo.ChatLog

also you wanna clear all tables of database?
use this command...

USE PS_GameLog
EXEC sp_MSforeachtable 'TRUNCATE TABLE ?'

all table of ps_gamelog clear

I used all the procedure. I cleaned the tables of Ps_game_log still continues with + 10GB