Small Business Server 2008 Drive Full Part 2

In Knowledge Base Blog by angeladmin

 BACKUP YOUR SERVER 1ST

 

Small Business Server 2008 installs default install puts everything on the C:\ Drive.  there are tools available in the Small Business Server Console to move some of the data to other locations, but several folders that remain in the C:\ volume will grow if left unchecked, this will potentially eat all the available disk space on the C:\ drive. Once the C:\ drive begins to reach capacity some services will stop functioning properly on the server, while others will change their behavior to prevent data loss. The biggest impact of the low disk space issue is e-mail flow.  The most common error is 452 4.3.1 Insufficient system resources.

IIS and SBS Logs

All IIS  web sites have logging enabled, this can lead to some large folders in C:\inetpub\logs\LogFiles

Launch IIS Manager from Administrative Tools.

  1. Expand Server, Sites, and select the site you wish to adjust web site.
  2. Inn the middle of the screen under IIS double-click on logging.
  3. On the far right click disable.
  4. Repeat the above steps for any other web site. Please note that logging may be needed for troubleshooting or auditing purposes on sites that are public facing, this is usually not the case on the WSUS Administration site.
  5. Navigate to c:\inetpub\logs\logfiles and delete all log files, note that you will be denied access by default to these directories so standard tools like windirstat will not report these directories size.

 

A few of the SBS 2008 log files can grow to a very large size.  Check in the C:\Program Files\Windows Small Business Server\Logs. Some of the logs that will grow the most and may need shrunk.

  1. Console.log, this log will continue to grow while the SBS Console is running.  If you delete this file windows will recreate it, make sure you close the SBS console before trying to edit or delete this file.
  2. *.evtx files, these are the event logs before the setup of the server completed, they can be safely removed if the server has been in production and had no setup issues.
  3. W3wp.log, in the C:\Program Files\Windows Small Business Server\Logs\WebWorkplace folder. This is the log for Remote Web Workplace.
  4. The C:\Program Files\Windows Small Business Server\Logs\MonitoringService\Logs folder. These are the logs for the Windows SBS Manager service.  Windows will recreate these logs if you delete them.  You must stop the Windows SBS Manager service to delete or edit these files.

 

 

Delete events in the Windows SBS 2008 licensing log

  1. From the server, open a Command Prompt window as an administrator. To do this, click Start, and then in the Search box, type command prompt.
  2. In the list of results, right-click Command Prompt, and then click Run as administrator.
  3. At the command prompt, type the following command: del “%systemroot%system32winevtlogsMicrosoft-Windows-Server Infrastructure Licensing*%4Debug.etl.*”

Edit the Registry to disable the License Logging.

  1. Click Start, type regedit, and then press ENTER.
  2. In Registry Editor, locate and then click the following registry key:
    HKEY_LOCAL_MACHINESOFTWAREMicrosoftServerInfrastructureLicensing
  3. Right-click TraceMask, and then click Modify.
  4. In the Edit DWORD dialog box, change the value for Value data to 0, that is a zero then click ok.
  5. Restart the server.

Use the WSUS(Windows Server Update Services) cleanup wizard to delete old and unnecessary updates.

  1. Hit Start and type “windows update server”  in the search box.
  2. Expand the server name and select options.  Don’t change what is downloading as it will break the console but run the “Server Cleanup Wizard” This may take a very long time.

SharePoint Database log file is growing out of control

 

          1. Open notepad and copy/paste the following into it, save the file as c:\logshrink.sql (You may need to save to your documents and move the file to C:\)

declare @ConfigDB varchar(255);
declare @ConfigDBLog varchar(255);
declare @ConfigDBCmd varchar(255);
select @ConfigDB = name from sys.databases where name like ‘SharePoint_Config_%’;
set @ConfigDBCmd = ‘BACKUP database [‘ + RTRIM(@ConfigDB) + ‘] to disk=”C:\windowstempbefore.bkf”’;
execute(@ConfigDBCmd);
set @ConfigDBCmd = ‘use [‘ + RTRIM(@COnfigDB) + ‘]’;
execute(@ConfigDBCmd);
set @ConfigDBCmd = ‘BACKUP LOG [‘ + RTRIM(@ConfigDB) + ‘] WITH TRUNCATE_ONLY’;
execute(@ConfigDBCmd);
set @ConfigDBCmd = ‘use [‘ + RTRIM(@COnfigDB) + ‘]’;
execute(@ConfigDBCmd);
select @ConfigDBLog = name from sys.database_files where name like ‘SharePoint_Config%_log’;
set @ConfigDBCmd = ‘use [‘ + RTRIM(@ConfigDB) + ‘] DBCC SHRINKFILE([‘ + RTRIM(@ConfigDB) + ‘_log],1)’;
execute(@ConfigDBCmd);
set @ConfigDBCmd = ‘BACKUP database [‘ + RTRIM(@ConfigDB) + ‘] to disk=”C:\windowstempafter.bkf”’;
execute(@ConfigDBCmd);
go

At a elevated command prompt run the following command

sqlcmd -S .pipemssql$microsoft##sseesqlquery -E -i c:logshrink.sql

This script creates two backup files (before.bkf and after.bkf) in C:\windows\temp.

 

http://support.microsoft.com/kb/2000544

Shrinking the Active Directory Certificate Services transaction log files

When completing a critical or system state backup of the C:\volume, a new transaction log will be generated under the c:\windows\system32\certlog folder. Removing these logs is only safe as long as the CA database file is consistent. In order to remove these logs and reclaim disk space, follow these steps:

  1. Open the Services MMC and stop the Active Directory Certificate Services service.
  2. Make a backup copy of ALL the file contents present in the c:\windows\system32\certlog folder.
  3. Delete EDB.CHK and all the files that have an extension of .LOG (*.LOG)
  4. Restart the Active Directory Certificate Services service.

Cleaning up the c:\programdata\microsft\windows\wer directory

I just cleaned up 10gig of stored windows error reporting reports.  These can be cleaned up by deleting them and then you can stop them from happening by following the next few steps;

how could you disable or turn off Windows Vista Error Reporting feature or the Problem Reports And Solutions program?

  1. Click the Windows start button or windows orb or hit the start key on your keyboard
  2. Type problem and click the Problem Reports And Solutions shortcut in the Program list,
  3. On the left pane of Problem Reports And Solutions window, locate and click the Change Settings option,
  4. It’s recommended to “Check for solutions automatically and Notify you if you can take steps to solve a problem”. Otherwise, select the option “Ask me to check if a problem occurs”.

 

 

Windows Component Clean Tool

The Windows Component Clean Tool (COMPCLN.exe) can be used to remove the files that are archived after Windows Vista SP2 or Windows Server 2008 SP2 is applied. It also removes the files that were archived after Windows Vista SP1 was applied, if they are found on the system. Running this tool is optional.

Installing Windows Server 2008 service packs increases the amount of disk space that is used by the operating system. This space is used to archive files so that the service pack can be uninstalled. Typically, you should run COMPCLN.exe if you want to reclaim this disk space after applying SP2 and if you will not need to uninstall SP2.

NOTE: You cannot uninstall Windows Vista SP2 or Windows Server 2008 SP2 after you run this tool on an image.

Move Data Wizards

All of the following should be done initially when the server is first implemented but if you haven’t done this please open the SBS console, go to “Backup and Server Storage” then “Server Storage” and run the wizard in the task pane.  This is assuming that you have an additional drive installed or a big data partition.

  1. Move Exchange Server Data: which moves both the exchange database file as well as your exchange transaction logs for all storage groups.
  2. Move Windows SharePoint Services Data: Moves the SharePoint Content and Configuration databases.
  3. Move Users’ Shared Data: Moves C:\Users\Shares fdirectory and all sub directories
  4. Move Users’ Redirected Documents Data: Moves C:\Users\FolderRedirections directory and all sub directories
  5. Move Windows Update Repository Data: Moves the repository data from C:WSUS\WSUS\Content and C:\WSUS\Update\ServicePackages. Please note it does NOT move the SUSDB Folder and the WSUS database which contains the metadata.

To Move the SUSDB File from c:\ to another drive

  1. Open SQL Server Management Studio 2008
  2. Under server name insert the following
    1. .pipemssql$microsoft##sseesqlquery
    2. Use Windows Authentication
  3. Open Databases
  4. Right click on SUBDB and choose Tasks > Detach
  5. Check the box for Drop Connections and Update Statistics
  6. Navigate to c:\WSUS\SUSDB\UpdateServicesDBFiles
  7. Cut the whole folder and move it to a drive that is big enough to hold the file
  8. Go back to SQL Server Management Studio 2008(or newer)
  9. Right Click on Databases and choost Tasks > Attach
  10. Navigate to the location of the SUSDB file
  11. Select it and attach.

 

FOR PART 1 CLICK HERE