[Help] I can't Clean this DB.

[JENZO]

hello!!!
here is this Database



I can't clean up this database
When do I clean it and set up GM Account and enter the game I find organic by the same old Silk And when i buy something i taking disconnected
Is one of you can be cleaned and repaired for me

And Can any one know this Database Re upload LOG_SHARD And server file with out Data Folder

this To all.

Fix Delete plz

[seriouscos]

Originally Posted by JENZO

hello!!!
here is this Database



I can't clean up this database
When do I clean it and set up GM Account and enter the game I find organic by the same old Silk And when i buy something i taking disconnected
Is one of you can be cleaned and repaired for me

And Can any one know this Database Re upload LOG_SHARD And server file with out Data Folder

this To all.

Fix Delete plz

use this query to clean your Data



USE [SRO_VT_ACCOUNT]
GO
TRUNCATE TABLE [dbo].[TB_User]
TRUNCATE TABLE [dbo].[TB_User_Bak]
TRUNCATE TABLE [dbo].[SK_CharRenameLog]
TRUNCATE TABLE [dbo].[_Punishment]
TRUNCATE TABLE [dbo].[_ServiceManagerLog]
TRUNCATE TABLE [dbo].[Test_HN]
TRUNCATE TABLE [dbo].[_BlockedUser]
TRUNCATE TABLE [dbo].[_CasGMChatLog]
TRUNCATE TABLE [dbo].[_Notice]
TRUNCATE TABLE [dbo].[_SMCLog]
TRUNCATE TABLE [dbo].[QuaySoEpoint]
TRUNCATE TABLE [dbo].[SK_ITEM_GuardLog]
TRUNCATE TABLE [dbo].[SK_ItemSaleLog]
TRUNCATE TABLE [dbo].[SK_PackageItemSaleLog]
TRUNCATE TABLE [dbo].[SK_PK_UpdateLog]
TRUNCATE TABLE [dbo].[SK_ResetSkillLog]
TRUNCATE TABLE [dbo].[SK_Silk]
TRUNCATE TABLE [dbo].[SK_SilkBuyList]
TRUNCATE TABLE [dbo].[SK_SilkGoods]
TRUNCATE TABLE [dbo].[SK_SubtractSilk_VAS]
TRUNCATE TABLE [dbo].[SR_ShardCharNames]
TRUNCATE TABLE [dbo].[TB_Net2e]
TRUNCATE TABLE [dbo].[TB_Net2e_Bak]
TRUNCATE TABLE [dbo].[tb_paygate_trans]

[cristianxi]

Clean and Super Compressed



Enjoy !