Reducing size of SQL Server 2000: why I am not a DBA?!

OK, so I’ve been stupid and, as a result, my SQL Server 2000 DB takes up over 20GB both on the logs and the content.  Ridiculous.  I even know why.

So first thing is first – I got rid of all the logs.

Now I need to figure out how to reduce the bloated tables themselves…

More to come soon…

 

Nikita’s LJ Tags:

Leave a comment

Filed under Tech

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s