Howto: Configure CloudLinux kernel on pv xen

In other to switch your hosted server with pv xen to CloudLinux server, you may refer to the step as below,

1. Make sure that /etc/sysconfig/kernel is as line below, if the file is not exist, create it,

UPDATEDEFAULT=yes
DEFAULTKERNEL=kernel-xen

2. Install grub if it is not,

yum install grub

3. Check /etc/modprobe.conf is exists and with the following line it is not,

alias eth0 xennet
alias scsi_hostadapter xenblk

4. If you have install the newer kernel, run the following line,

mkinitrd -f /boot/initrd-2.6.xxx.img 2.6.xxx

‘xx’ should be the same as you newly installed kernel-xen version

5. Else, install kernel,

yum install kernel-xen

6. Check if /boot/grub/grub.conf exists, else create it,

ln -s /boot/grub/grub.conf /boot/grub/menu.lst
ln -s /boot/grub/grub.conf /etc/grub.conf

7. Make sure that the /etc/grub.conf is look like,

default=0
timeout=10
title CentOS (2.6.18-308.11.1.el5xen)
root (hd0,0)
kernel /boot/vmlinuz-2.6.18-308.11.1.el5xen console=xvc0 root=/dev/sda1 ro
initrd /boot/initrd-2.6.18-308.11.1.el5xen.img

Make sure that the vmlinuz and initrd should be the same.

8. Ask your hosting provider to change the kernel type to pygrub and reboot it.

Howto: Shrink MS SQL Database Transaction Log

As some hosting provider do limited the size of MS SQL database to be hosted, you might found out your database is not really used up the allocated size.

For many cases, it is because your database transaction log used up those spaces and you might not need to have this transaction log for any purpose. To get this resolve, you may shrink the database transaction log.

1. Open the MS SQL Management Studio and connect to the console.
2. Run the following command from SQL Query.

USE <DatabaseName>
GO
DBCC SHRINKFILE(<TransactionLogName>, 1)
BACKUP LOG <DatabaseName> WITH TRUNCATE_ONLY
DBCC SHRINKFILE(<TransactionLogName>, 1)
GO

** Replace the DatabaseName and TransactionLogName with your database information.

In most of the cases, you may schedule this task to be run automatically if needed.