Restore MSSQL database using batch script


If you are looking for a tool which can restore the MS SQL DB backup from the production environment to the development environment, this script is just the one that you are after. In my example, the script does the following things: 1) Copy of the latest pro db backup to local. 2) Close all connections of … Continue reading Restore MSSQL database using batch script →

Convert Lazy Zeroed Disk to Eager Zeroed Disk


We plan to build a new file server cluster by utilizing couple existing Windows 2012 R2 in the VMware 5.5 farm. According to the VMware KB, the system drive has to be created with Eager Zeroed  disk, I think the reason is to have low disk latency otherwise the high disk latency may lead to failover. The … Continue reading Convert Lazy Zeroed Disk to Eager Zeroed Disk →

Monitor V7000 active alerts in Xymon


Continue with my previous post on installing the Xymon, you can write your own monitor scripts. I wrote a script named v7000alerts to check whether there are active alerts in my IBM StorWize V7000. 1) Download the script v7000alerts to /home/xymon/server/ext, and run 'chmod a+x v7000alerts' and 'chown xymon:xymon v7000alerts'. 2) Add the following into /home/xymon/server/etc/tasks.cfg … Continue reading Monitor V7000 active alerts in Xymon →