Troubleshooting › SA Manager and UI Server Troubleshooting › Disk Full

Disk Full

Symptom:

The disk where I installed CA SOI is full.

Solution:

You can use a command to shrink the Microsoft SQL transaction log file to free some space. However, your database must be configured with the recovery model Simple. If the recovery model is Full, the shrink command does not work.

Note: For more information, see the MSDN document http://support.microsoft.com/kb/907511.

Follow these steps:

1. Perform a full database backup using the following command:

   BACKUP DATABASE [SAMStore] TO DISK = N'C:\Program Files\Microsoft SQL 
   Server\MSSQL.1\MSSQL\Backup\SAMStore.bak' WITH NOFORMAT, NOINIT, 
   NAME = N'SAMStore-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, 
   STATS = 10
   GO
   

2. Back up the transaction log:

   BACKUP LOG [SAMStore] TO DISK = N'C:\Program Files\Microsoft SQL 
   Server\MSSQL.1\MSSQL\Backup\SAMStore_log.bak' WITH NOFORMAT, NOINIT, 
   NAME = N'SAMStore-Transaction Log  Backup', SKIP, NOREWIND, NOUNLOAD, 
   STATS = 10
   GO
   

3. Shrink the size of the log file:

   DBCC SHRINKFILE (N'SAMStore_log', 100) WITH NO_INFOMSGS
   

   SAMStore_log

   Specifies the logical transaction log file name.

   Sets the file size to 100MB. You can make it above or below this value depending on your disk space availability.