Reduce size of SOPHOS4 SQL database

1. Install Microsoft SQL Management Studio Express
2. Open Sophos DB
3. Confirm DB that is using space.
Right Click DB go to properties, Check Size
4. Once you find the Sophos DB using disk space open its properties page.
5. Click on Options
6. Change Recover Model to Simple
7. Click Ok
8. Create Backup of DB
• Right click DB
• Select task
• Select backup
• Set backup type full
• Change backup to Disk
• Add location do save the backup file
• Click ok
9. Next Shrink the DB
• Right click DB
• Select Tasks
• Select Shrink
• Select Database
optional Tick Reorganize files before releasing unused space….
• Select OK
This will shrink the DB down. My Sophos DB change from 2.5 GB to 25Mb.
Thanks to


http://community.sophos.com/t5/Sophos-Small-Business-products/Size-of-SOPHOS4-log-LDF/m-p/2374

Install SNMP on Windows 2008

servermanagercmd.exe -install SNMP-Services

Slow RDP refresh

A great read...

http://blog.tmcnet.com/blog/tom-keating/microsoft/remote-desktop-slow-problem-solved.asp

This command seems to help:

netsh interface tcp set global autotuninglevel=highlyrestricted

netsh interface ip set global taskoffload=disabled

Symantec Endpoint server firewall rules

netsh firewall add portopening TCP 8443 "Symantec server port"
netsh firewall add portopening TCP 9090 "Symantec management console port"
netsh firewall add portopening TCP 8014 "Symantec client communication port"

Error during the configuration of the host:Failed to update the disk partition information

vSphere client issues this error when creating storage on an iSCSI SAN, in this caseMD3200i

Error during the configuration of the host:Failed to update the disk partition information

This was cuased by me etting the LUN paths to Round Robin rather than Fixed which was the VMware default.

How to move a DHCP database from a computer that is running Windows Server 2003 to Windows Server 2008

Export the DHCP database from Windows 2003:







1. On the Windows 2003 DHCP server, navigate to a command prompt
2. Type the following Command: netsh
3. Type the following Command: DHCP
4. Type the following Command: server name or ip address
5. Type the following Command: export c:\w2k3DHCPdb all

Note You must have local administrator permissions to export the data.

Import the DHCP database


1. Copy the exported DHCP database file to the local hard disk of the Windows Server 2008-based computer.
2. Install the DHCP Role on the server.
3. Stop the DHCP server service on the server. To do this, follow these steps:

a. Log on to the target DHCP server by using an account that is a member of the local Administrators group.

b. Click Start, click Run, type cmd in the Open box, and then click OK.


c. At the command prompt, type net stop DHCPserver , and then press ENTER. You receive a "The Microsoft DHCP Server service is stopping. The Microsoft DHCP Server service was stopped successfully" message.


d. Type exit, and then press ENTER.

4. Delete the DHCP.mdb file under c:\windows\system32\DHCP folder.
5. Start the DHCP server service.
6. Right-click on the Command Prompt (cmd) and select run as administrator, to open the cmd prompt using elevated privileges.

Note You must have local administrator permissions to import the data.


7. Type the following Command: netsh
8. Type the following Command: DHCP
9. Type the following Command: server name or ip address
10. Type the following Command: import c:\w2k3DHCPdb
11. Restart DHCP and verify the database has moved over properly.


From: http://support.microsoft.com/kb/962355

Creating PTR records with BT static IP addresses

If you need to create a PTR record for a BT static IP address you need to send an email to:

reverse.dns@btbroadbandoffice.com

Stating your broadband phone number, static IP address and which host you want it pointing to.