VMware Cloud Community
ksuchewie
Contributor
Contributor
‎09-22-2009 12:01 PM

Reducing database on sqlserver

Today I noticed the database for vmware on our sqlserver was sitting at 38 GB. How can I trim this down, because I am starting to run out of HD space?

Thanks,

Matt

0 Kudos
5 Replies
vmroyale
Immortal
Immortal
‎09-22-2009 12:03 PM

Hello.

Check out kb article 1000125

Good Luck!

Brian Atkinson | vExpert | VMTN Moderator | Author of "VCP5-DCV VMware Certified Professional-Data Center Virtualization on vSphere 5.5 Study Guide: VCP-550" | @vmroyale | http://vmroyale.com
0 Kudos
ksuchewie
Contributor
Contributor
‎09-22-2009 02:00 PM

I just ran the script and the database got bigger, instead of smaller.

:_|

0 Kudos
LucasAlbers
Expert
Expert
‎09-22-2009 09:17 PM

It's the database and not the transaction logs?

If you do a backup how big is the backup?

how big is the database after the backup?

krowczynski
Virtuoso
Virtuoso
‎09-22-2009 09:22 PM

I would suggest to create job and make BAK and TRN Backups!

MCP, VCP3 , VCP4
0 Kudos
ksuchewie
Contributor
Contributor
‎09-23-2009 05:56 AM

It was the transaction logs that were the problem. The database was really only 3 GB, but the transaction logs was 40GB. I was able to clear the logs with this query:

DBCC SHRINKFILE("vmware_Log", 1)

BACKUP LOG vmware WITH TRUNCATE_ONLY

DBCC SHRINKFILE("vmware_Log", 1)

I am backing up my sqlserver with Symantec so now I have to figure out why the logs aren't purging.

0 Kudos