VC db log file shrink?

[mlubinski]

Hi,

I would like to ask you about following. If someone before installing VC set DB for it, and set DB size of 26GB and initial log file size of 200GB is there any way to change it (shrink)?

I think that this was serious mistake, and this should be set as default, so small initial size with autogrow.

Did anyone perform such operation in his environment?

[Troy_Clavell]

I am no SQL DBA by any means, but take a look at this document

http://www.vmware.com/files/pdf/vc_microsoft_sql_server.pdf

[mlubinski]

Hi,

attached document didn't have any tips. But I finally found solution to this issue.

1. I did full DB backup

2. I run following SQL query inside SQL server

DBCC SHRINKFILE(vmware_Log, 1)

Go

BACKUP LOG vmware WITH TRUNCATE_ONLY

Go

DBCC SHRINKFILE(vmware_Log, 1)

3. After this I changed DB recovery mode to SIMPLE, so I hope from now log will be automatically truncated