March 19, 2009 at 10:13 pm
A SQL 2008 maintenance job failed for the first time after countless successful runs w/ the following error:
Databases that have a compatibility level of 70 (SQL Server version 7.0) will be skipped.
All user db's have a compatibility level of 100 (sql 2008).
The SQL version is 10.10.1763 hosted on a Windows Server 2003 Enterprise 64bit SP2 OS.
Any ideas on what happened and a resolution?
March 20, 2009 at 3:16 am
Can you tell me what is your maintenance job scheduled for?
Tanx 😀
March 20, 2009 at 11:11 am
The maint job runs tasks in this order: Check Database Integrity, Rebuild Indexes, Update Statistics and History Cleanup. The job terminates on the Check Database integrity task w/ the compatibility error.
March 20, 2009 at 7:17 pm
Do you get any rows in output when you run the below mentioned query:
select * from sys.databases
where compatibility_level<>100
MJ
March 26, 2009 at 10:35 am
No records came back for the query but the maint job is now mysteriously running successfully again. WTH??
I want to thank those who replied. Much appreciated.
March 26, 2009 at 11:09 am
DataBase Assassin (3/19/2009)
A SQL 2008 maintenance job failed for the first time after countless successful runs w/ the following error:Databases that have a compatibility level of 70 (SQL Server version 7.0) will be skipped.
All user db's have a compatibility level of 100 (sql 2008).
The SQL version is 10.10.1763 hosted on a Windows Server 2003 Enterprise 64bit SP2 OS.
Any ideas on what happened and a resolution?
Curiosity, where did you get these databases from with compatibility level of 70? Have you recently migrated these databases to your 2008 server?
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply