|
You last visited: Today at 02:31
Advertisement
Database Problem
Discussion on Database Problem within the SRO Private Server forum part of the Silkroad Online category.
07/21/2017, 21:25
|
#1
|
elite*gold: 4 
Join Date: May 2017
Posts: 1,128
Received Thanks: 247
|
Database Problem
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 ?
|
|
|
|
07/22/2017, 06:20
|
#2
|
elite*gold: 190
Join Date: May 2011
Posts: 1,204
Received Thanks: 832
|
Maybe it contains a huge amount of data about characters.
|
|
|
|
|
07/22/2017, 06:50
|
#3
|
elite*gold: 0
Join Date: Dec 2016
Posts: 65
Received Thanks: 18
|
Try to clean it!
|
|
|
|
|
07/22/2017, 12:57
|
#4
|
elite*gold: 4
Join Date: May 2017
Posts: 1,128
Received Thanks: 247
|
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
|
#5
|
elite*gold: 28
Join Date: Aug 2014
Posts: 4,096
Received Thanks: 2,653
|
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
|
#6
|
elite*gold: 1
Join Date: Nov 2011
Posts: 2,532
Received Thanks: 1,440
|
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
|
#7
|
elite*gold: 4
Join Date: May 2017
Posts: 1,128
Received Thanks: 247
|
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
|
#8
|
elite*gold: 28
Join Date: Aug 2014
Posts: 4,096
Received Thanks: 2,653
|
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
|
#9
|
elite*gold: 4
Join Date: May 2017
Posts: 1,128
Received Thanks: 247
|
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
|
#10
|
elite*gold: 0
Join Date: Dec 2016
Posts: 65
Received Thanks: 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
|
|
|
|
|
07/24/2017, 09:46
|
#11
|
elite*gold: 85
Join Date: Sep 2008
Posts: 390
Received Thanks: 153
|
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
|
#12
|
elite*gold: 4
Join Date: May 2017
Posts: 1,128
Received Thanks: 247
|
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.
|
|
|
|
 |
Similar Threads
|
[Official Release] Rainbow Database: Vampire/Godship/Legionairre Database!
04/25/2021 - EO PServer Guides & Releases - 106 Replies
http://i43.tinypic.com/jgo485.png
Additional: The database contains all material and server features which I alone coded, designed and created. I can barely recall if their were any bugs. I think there was with one of the vampire skills. People said it was supposed to be an xp skill but they could use it without having to be on XP. So its pretty minor but if you find any other problems please report them to this thread and i'll make a fix asap.
Many database releases have come before this...
|
[How-To]Change from sql-database to txt-database
08/11/2016 - Metin2 Private Server - 1 Replies
Hello guys...
My Server uses item_proto and mob_proto from navicat , iwant to use item_proto and mob_proto from fillezilla, ????
Show me the way and thnak you .:o
|
[Release] Sro-r DataBase , And Real TWsro DataBase
04/01/2013 - SRO Private Server - 10 Replies
its a gift from me because i will left Sro Forever
so today i will release Sro-r DataBase , And Real Twsro Database + Server Files
Download Link
HAPPY 1/4
:D i never do that lol you mad ! ?
:p
|
All times are GMT +1. The time now is 02:32.
|
|
