sqla000.tmp file is consuming hard drive space

Problem

the sqla000.tmp file, found at \temp\sqla000.tmp is consuming several gigabytes of hard drive space.

Error

No error but the size of this file is larger than it should be and is consuming hard drive space.  The sqla000.tmp file should typically be only about 200MB in size.

Environment

Windows Server 2008 R2, Symantec Endpoint Protection Manager 12.1 RU1 with an embedded database.

Cause

It appears that a problem with the sem5.log is continually writing extra data to the \temp\sqla000.tmp file

Solution

Rebuild the sem5.log:

Stop the Embedded Database service from services.msc
Note: If you did not install SEPM to the default location, change the paths below.

• Go to "C:\Program Files\Symantec\Symantec Endpoint Protection Manager\db\" and rename sem5.log to sem5.log.old  (Use "Program Files (x86)" if the SEPM is on a 64-bit system)
• Start a Command Prompt (cmd.exe) and type:
  • CD C:\Program Files\Symantec\Symantec Endpoint Protection Manager\ASA\win32\
• Type the following & press Enter (again, use Program Files (x86) if on a 64-bit system)
  • dbsrv11 -f "C:\Program Files\Symantec\Symantec Endpoint Protection Manager\db\sem5.db"
• Start the Embedded Database service & restart the Symantec Endpoint Protection Manager service.

Article URL http://www.symantec.com/docs/TECH188303

Disable password expiration in Windows Server 2008 R2

on a domain controller:

Start > Administrative Tools > Group Policy Management > right click "Default Domain Policy" under domain name > Edit > Computer Configuration > Policies > Windows Settings > Security Settings > Account Policies > Password Policy > set "Maximum password age" to "0"

How to remove default share in Windows Vista and Windows 7

Click Start, type regedit in the Search box, and then click regedit.exe in the search results. The User Account Control dialog box appears.

Enter your UAC credentials to continue. Windows Vista opens the Registry Editor.

Open the HKEY_LOCAL_MACHINE branch.

Open the SYSTEM branch.

Open the CurrentControlSet branch.

Open the Services branch.

Open the LanmanServer branch.

Select the Parameters branch.

Select Edit, New, DWORD (32-bit) Value. Vista adds a new value to the Parameters key.

Type AutoShareWks and press Enter. (You can leave this setting with its default value of 0.)

Restart Windows Vista / 7 to put the new setting into effect.