Please help: sql 2008 on a virtual 2008 Ent running on 2008 Ent host. All updates installedthe ReportServer$ServerTempDB_log is growing huuge. was 3.5GB. i set recovery model to simple and shrunk the database. its now back to 504kb left the setting at simple whats weird is the sql log writes every some seconds Setting database option COMPATIBILITY_Level to 100 for database ReportServer$SERVER and Setting database optoion COMPATIBILITY_Level to 100 for database ReportServer$SERVERTempDB 1st q: i checked and its set to 100 so i dont understand why it keeps trying to set it to 100 every few seconds. how do i make it stop and why isit doin that? 2nd q: where are the logfiles the errors are filed in located physically? they must be huge by now with 2 lines added every other secondtia

Not sure which log files are you referring to in your quesiton.But you can read more about report server log files athttp://msdn.microsoft.com/en-us/library/ms157403.aspx

i am referring to the SQL Server logs viewable in SQL Server Management Studio - Log file viewer. Current and Archive #1 - Archive #6. Current upt to date has 190846 records!Source: spid51, spid52 and spid53Message: Setting database option COMPATIBILITY_Level to 100 for database ReportServer$SERVERMessage: Setting database optoion COMPATIBILITY_Level to 100 for database ReportServer$SERVERTempDBLog Type: SQL Serveri found the locotion where the logfiles are stored physically:C:\Program Files\Microsoft SQL Server\MSSQL10.SERVER\MSSQL\Loghow do i make SQL stop trying to set the database option to 100 if its already set to 100??

any update with this problem? same experience here..

It is NOT a good answer, MS Bug and they won't fix it. Go buy SQL 2008 R2. http://connect.microsoft.com/SQLServer/feedback/details/488169/setting-database-option-compatibility-level-to-100-for-reportserver