Archive for February, 2014

The transaction log for database ‘DBNAME’ is full due to ‘LOG BACKUP’.

Posted: 10th February 2014 by admin in Uncategorized

Here is MsSQL quere to shrink DB log file: For safity!!! DO BACKUP BEFORE Alter database invcenter SET RECOVERY SIMPLE; Go USE databasename; GO DBCC SHRINKFILE (logfilename); GO Alter database databasename SET RECOVERY FULL; Go  

Bash script – check unused (Free) IP from pool / Subnet

Posted: 6th February 2014 by admin in Uncategorized

Hi all, Today wi will code script that check unused IP's In the company where I working nobody count IP used by our clinets and sometimes we need to give dedicated IP ,so it my way to found the clear IP. #!/bin/bash echo "Which IP range you want to check" echo enter as : "IPX(for […]