Register for your free account! | Forgot your password?

You last visited: Today at 21:39

  • Please register to post and access all features, it's quick, easy and FREE!


Reduce SQL database size

Reply
 
Old   #1
 
elite*gold: 0
Join Date: Sep 2017
Posts: 442
Received Thanks: 104
Reduce SQL database size

I was wondering how to reduce my database size.
I mean like, when I make a back-up and I try to restore it,
I find out that the SHARD database only has 32 GB and that's a huge number actually.

So, I am pretty sure there's something that cleans database from dumb files/logs something like these things.



#HB is offline  
Old 05/27/2018, 20:42   #2
 
elite*gold: 0
Join Date: May 2006
Posts: 474
Received Thanks: 198
Quote:
Originally Posted by #HB View Post
I was wondering how to reduce my database size.
I mean like, when I make a back-up and I try to restore it,
I find out that the SHARD database only has 32 GB and that's a huge number actually.

So, I am pretty sure there's something that cleans database from dumb files/logs something like these things.
the most common case for a huge sized database is because generally people make a backup set in addition to the original backup set so they can pick a specific set with its date and restore to whatever date they want.
you can overwrite the backup with the latest backup set and it will keep 1 latest backup set.

Just tick BACKUP with overwrite option in ssms, or u can just use my filter backup option its doing the same thing, just programatically.

there are some other methods of shrinking a db size but im too lazy for those lol


Isoline* is offline  
Old 05/28/2018, 17:18   #3
 
elite*gold: 0
Join Date: Mar 2018
Posts: 69
Received Thanks: 13
use overwrite option
ScarOnline is offline  
Reply


Similar Threads
ShardManager process reduce + reduce log + delete logs
01/25/2012 - SRO PServer Guides & Releases - 12 Replies
Hey all how r u?okey enough :facepalm: GOAL doesnt recording the database logs EFFECT * ShardManager msgCount values reduce 9000+ to 5-10 * youve got lower lag because we'll delete recording logs * die for logs:D:D
[SIZE="6"][/SIZE]Wichtig an alle die gepowerlvlt werden möchten !![/SIZE]
08/21/2011 - WarRock - 2 Replies
habe einige Powerlvl service auf e-pvp getestet und auch einiges an geld gezahlt. Doch passt auf sie ziehen euch bloß das geld ab und verschwinden dan :(. Ich dachte wenigstens auf e-pvp wird macn nicht abgezogen aber kann man ja nix machen. mfg damdam9
Minimise guard size and maximize met dove size
10/25/2005 - CO2 Main - Discussions / Questions - 20 Replies
erm....is any1 here capable to making summon guard smaller and making met dove bigger both in 1?i wan to reduce guard size as its annoying when u r killing ur enemy and i tink some of u notice tat too dun u guys?hope some 1 would modify the ini file :D cus i dunno how to =X



All times are GMT +1. The time now is 21:39.


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Abuse
Copyright ©2018 elitepvpers All Rights Reserved.