reduce database size

[Neecross]

ye my problem is im at 60gb database already and my harddriver is full so any chance to reduce the size ?

 

[Dakino]

i think the only way is too delete skill bar and friend list if your players can understand
because im sure many accounts are not being used

 

[spamman]

lol. No, you need to truncate the transaction logs. Basically. Backup your database, replace older recovery sets, and then restore the database. It will truncate the transaction log. The database isn't 60 gig, the transaction log is. Your db will never be 60 gig. Mine is one of the biggest databases, and it's like 50 gig . That's not counting the transaction log. So, try what I suggested.

 

[Neecross]

might sound noobish but how XD

 

[spamman]

You must be registered to see links

 

[Neecross]

kinda knew that it will end up like that :biggrin2: thx alot anyway time for da search button