Reduce log device

[Former Member]

Hi experts,

How can decrease the log device? Actually it has 10GB and I want to reduce to 5GB

I know that I have to create a new log device and change it, but I do not know the commands.

Thanks in advance,

Regards,

[Former Member · Accepted solution]

Solved with:

use master

go

disk init name='CRD_log_002', physname='H:\sybase\CRD\saplog_1\CRD_log_002.dat', size ='1024M', directio='true'

go

alter database CRD log on CRD_log_002='1024M'

go

alter database CRD log off CRD_log_001

go

sp_dropdevice CRD_log_001

go