1. Check security rights to log volume and directory:
For any alternative logging folder, the Network Service account must have read permissions from the root partition and any parent folder for the folder. On the logging folder itself, the following permissions are required:
- Network Service: Full Control
- System: Full Control
- Administrators: Full Control
2. Stop all TMG services
3. Check is there any OLD log DBs:
run privileged console
cd C:\Program Files\Microsoft SQL Server\100\Tools\Binn
sqlcmd -S localhost\msfw -q select @@version
select @@version;
go
select name from sys.databases;
go
you'll see a list of DBs
drop every DBs with name like ISALOG___
drop database ISALOG_20140619_WEB_000
GO
again check is there left any DBs like ISALOG___
4. Run all TMG services
It works for all my TMGs with this log trouble.
Check log status it must change to QUEUE IN USE, and then to READY
-
Edited by
Dezinto
Friday, June 20, 2014 9:05 AM