Here’s a nice little utility that compresses the SQL backup files .bak using Gzip. The backups will then take up a lot less disk space. forfiles /P G:\SQLBackup\db /S /M *.bak /c “cmd /c if @isdir==FALSE C:\GZip\bin\gzip.exe @path” Add that as a SQL Agent job and call it after the database backup in the maintenance plan.

Migrating SQL databases if during the initial Citrix installation the default database was selected and you want to change it from Master to something else, here are the steps that should be taken: SQL Server: Create a Citrix database called CTX, create a SQL user called citrix and grant the user dbo database access. First Citrix Server: 1. From a command prompt cdprogram filescitrixindependent management architecture 2. copy mf20.dsn mast.dsn Contents of mast.dsn: ODBC DRIVER=SQL Server UID=sa DATABASE=master WSID=CTXSERVERNAME APP=Citrix IMA SERVER=SQLSERVERNAME Description=Citrix This assumes the sa SQL account was used to connect to the database. If DATABASE isn’t a part of this configuration then Citrix knows to default to master. WSID=Name of the server SERVER=Name of SQL server 3. edit mf20.dsn Contents of mf20.dsn: ODBC DRIVER=SQL Server UID=citrix DATABASE=ctx WSID=CTXSERVERNAME APP=Citrix IMA SERVER=SQLSERVERNAME Description=Citrix 4. dsmaint config /user:sa /pwd:sapassword /dsn:"c:program filescitrixindependent management architecturemast.dsn" This tells Citrix what DSN to […]

Are you SQL log files getting too large? Is your SQL server running out of disk space? Look at you log files, as databases with FULL RECOVERY mode selected can grow out of control… Use this in Query Analyser BACKUP LOG DATEBASE WITH TRUNCATE_ONLY Then shrink the log file in Enterprise Manger / SQL Server Management Studio Disclaimer: I do not guarantee that this will solve your problem and any tips listed on this website you use at your own risk

To reset Administrator Password on HP Insight Integrated Lights Out (iLO): Ensure that SNMP is installed because it was a prerequisite for HP Insight Management Agents. Ensure that HP Insight Management Agents are installed. Download this zip file – ResetiLO.zip Create a folder on the root of your C: drive called hp Create a folder within C:hp called ilo Extract the zip file to c:hpilo Edit the file “Administrator_reset_pw.xml” with the username you would like to reset and also edit the PASSWORD value=”password” to the new password. Than go to command prompt to folder c:hpilo and run the following command: FOR iLO Version 2 and above HPONCFG.exe /f Administrator_reset_pw.xml /l log.txt > output.txt FOR iLO Version 1.88 and below CPQLOCFG.exe /f Administrator_reset_pw.xml /l log.txt > output.txt You do not require the old password to reset the account. For additional information please read the PDF file in the attached zip file.

On VMWare ESX3, your VM has one or more VMDK files (extension .vmdk) and one or more flat vmdk files (last characters flat.vmdk ) In some cases, you may corrupt, lose or accidentally delete your VMDK files. Your VMDK’s contain metadata for your flat.vmdk files. Without your VMDK’s, you cannot load your flat.vmdk-files. Consequence: you cannot load the VM in your VirtualCenter and you cannot start the VM. The following steps will guide you to recreate your vmdk files (.vmdk): Determine the hard disk sizes of your original VM (I call this VM from now on: VM A) Create a new VM (I call this VM from now on: VM B) with VirtualCenter with the same number of hard disks as your old VM, and the exact same sizes. So: if your original VM contained 2 harddisks from 8,00GB and 12,00GB, recreate these harddisks exactly the same in your new […]

Windows® XP has a known issue for not finding a number of File Types when you do a Search for Files “containing text” or using the “A word or phrase in the file” option. This can be remedied for many file types, but not all. The cause is the lack of a PersistentHandler value in the Registry for this type of file. To correct this follow the instructions below: Click Start, Run and entering REGEDIT Navigate to HKEY_CLASSES_ROOT and locating the entry for the file type in question. For example, .txt, .adm, .asp. Expand the branch for that file type, and if the PersistentHandler subkey does not exist, create it. Do this by clicking on the file extension key and going to Edit, New, Key. Name the Key, PersistentHandler. Click on the PersistentHandler sub-key. In Regedit’s right pane, double click on the Default value and enter the following (copy and […]

PLEASE CUT and PASTE ! RunDll32 advpack.dll,LaunchINFSection %windir%INFmsmsgs.inf,BLC.Remove To delete / remove Microsoft Windows XP Windows Messenger 4.7 for good all you do is type this message or cut and paste into your RUN prompt or command.

To turn off the “!New” icon, set the number of days to zero The change is for ALL list items (not just documents) on the virtual server The change is immediate and does not require an IISRESET More information is at the following KB article… http://support.microsoft.com/default.aspx?scid=kb;en-us;825510&Product=spts Run the following (you may need to navigate to the directory where stsadm resides): stsadm.exe -o setproperty -pn days-to-show-new-icon -pv ## -url [Your Virtual Server’s URL] where ## is the number of days to show the “!New“ icon