Register for your free account! | Forgot your password?

You last visited: Today at 05:54

  • 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: 191
Received Thanks: 33
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   #2
 
elite*gold: 0
Join Date: May 2006
Posts: 364
Received Thanks: 92
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 online now  
Old   #3
 
elite*gold: 0
Join Date: Mar 2018
Posts: 68
Received Thanks: 12
use overwrite option
ScarOnline is offline  
Reply



« Previous Thread | Next Thread »

Similar Threads
ShardManager process reduce + reduce log + delete logs
Hey all how r u?okey enough :facepalm: GOAL doesnt recording the database logs EFFECT * ShardManager msgCount values reduce 9000+ to 5-10 *...
12 Replies - SRO PServer Guides & Releases
[SIZE="6"][/SIZE]Wichtig an alle die gepowerlvlt werden möchten !![/SIZE]
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...
2 Replies - WarRock
Minimise guard size and maximize met dove size
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...
20 Replies - CO2 Main - Discussions / Questions



All times are GMT +2. The time now is 05:54.


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.