Database Problem

Worshiper · 07/21/2017, 21:25

is really its more if SRO_VT_SHARD IS 182 giga ?
SRO_VT_SHARDLOG IS 42 Giga

what do you think guys its a problem or what ?

R3D* · 07/22/2017, 06:20

Maybe it contains a huge amount of data about characters.

SwaGy. · 07/22/2017, 06:50

Try to clean it!

Worshiper · 07/22/2017, 12:57

Quote:

Originally Posted by Acs'

Maybe it contains a huge amount of data about characters.

iam not sure :xD

Quote:

Originally Posted by SwaGy.

Try to clean it!

how to clean you mean Delete chars and .... by query ? lol its a online game and have players

Exo · 07/22/2017, 15:04

Management Studio:
Database (Right Click) -> Reports -> Standard Reports -> Disk Usage by Table.

Sort by Data and you will get which tables are using that much.

Snow* · 07/22/2017, 16:13

Just save the database somewhere incase you needed to look at the logs and wipe the current one

Code:

USE [SRO_VT_LOG]
GO

TRUNCATE TABLE [dbo].[_LogCashItem]
TRUNCATE TABLE [dbo].[_LogEventChar]
TRUNCATE TABLE [dbo].[_LogEventItem]
TRUNCATE TABLE [dbo].[_LogEventSiegeFortress]
TRUNCATE TABLE [dbo].[_LogSchedule]
TRUNCATE TABLE [dbo].[_LogServerEvent]

Worshiper · 07/22/2017, 18:51

Quote:
Originally Posted by Snow*
Just save the database somewhere incase you needed to look at the logs and wipe the current one
Code:
USE [SRO_VT_LOG]
GO

TRUNCATE TABLE [dbo].[_LogCashItem]
TRUNCATE TABLE [dbo].[_LogEventChar]
TRUNCATE TABLE [dbo].[_LogEventItem]
TRUNCATE TABLE [dbo].[_LogEventSiegeFortress]
TRUNCATE TABLE [dbo].[_LogSchedule]
TRUNCATE TABLE [dbo].[_LogServerEvent]

I Did this query and still same

Quote:

Originally Posted by Exo

Management Studio:
Database (Right Click) -> Reports -> Standard Reports -> Disk Usage by Table.

Sort by Data and you will get which tables are using that much.

yes i see but when i clean my database with the Query and backup it and offine sql and open and restore again still same 182 giga

Exo · 07/23/2017, 05:29

Quote:

Originally Posted by [GM]Dejo

I Did this query and still same

yes i see but when i clean my database with the Query and backup it and offine sql and open and restore again still same 182 giga

Well, you might take the database offline then delete the physical files and then recreate the database from the BAK file. I'd backup everything first (including mdf/ldf) if you're not sure what you're doing.

Worshiper · 07/23/2017, 06:16

Quote:

Originally Posted by Exo

Well, you might take the database offline then delete the physical files and then recreate the database from the BAK file. I'd backup everything first (including mdf/ldf) if you're not sure what you're doing.

still same but if the size only problem its ok but i ask in future this can lag the server ?

SwaGy. · 07/23/2017, 09:18

Quote:

Originally Posted by [GM]Dejo

iam not sure :xD

how to clean you mean Delete chars and .... by query ? lol its a online game and have players

i thinked its offline game to try !

Quote:

Originally Posted by [GM]Dejo

still same but if the size only problem its ok but i ask in future this can lag the server ?

i think that

DeviasOnline · 07/24/2017, 09:46

PHP Code:


			
ALTER DATABASE SRO_VT_SHARD SET RECOVERY SIMPLE 

dbcc shrinkfile ([SRO_VT_SHARD_Log],1)

ALTER DATABASE SRO_VT_SHARD SET RECOVERY FULL

Worshiper · 07/25/2017, 21:05

Quote:

Originally Posted by DeviasOnline

PHP Code:

ALTER DATABASE SRO_VT_SHARD SET RECOVERY SIMPLE dbcc shrinkfile ([SRO_VT_SHARD_Log],1) ALTER DATABASE SRO_VT_SHARD SET RECOVERY FULL

Error

Msg 8985, Level 16, State 1, Line 2
Could not locate file 'SRO_VT_SHARD_Log' for database 'master' in sys.database_files. The file either does not exist, or was dropped.