Database Problem

07/21/2017 21:25 Worshiper#1

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 ?

[Only registered and activated users can see links. Click Here To Register...]

07/22/2017 06:20 R3D*#2

Maybe it contains a huge amount of data about characters.

07/22/2017 06:50 SwaGy.#3

Try to clean it!

07/22/2017 12:57 Worshiper#4

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

07/22/2017 15:04 Exo#5

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.

07/22/2017 16:13 Snow*#6

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]

07/22/2017 18:51 Worshiper#7

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

07/23/2017 05:29 Exo#8

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.

07/23/2017 06:16 Worshiper#9

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 ?

07/23/2017 09:18 SwaGy.#10

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

07/24/2017 09:46 DeviasOnline#11

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

07/25/2017 21:05 Worshiper#12

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.