Posted on: 12/23/2008 10:55:28 AM | Views : 887

Hi,With SQL Server 2005 Express on XP, I get sometimes huge Error logs files :The file C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG grows to fill the disk (file size becomes more than 15 GB).Use the dos command "type", I can view some of the line in this file: 2008-12-17 00:12:24.03 spid13s     The log for database 'SDomain' is not available. Check the event log for related error messages. Resolve any errors and restart the databaseThe event log contains the same error.I have two questions:What is the best method to limit the growth of the file ERRORLOG? I think I can create a dedicated partition just for sql server logs, but maybe there is a built in mechanism to do this in sql server express.Any idea on the origin of this error?Regards,Julien Benoit ...

Go to the complete details ...