One of my QA SQL 2005 Servers has a number of databases where the the icon is red and not the normal green. These databases are not being backed up via Litespeed 7.5 either via amaintenance plan or selecting backup database from the tasks. There is no error written to either the sql logs or txt report file(verbose selected). I am able to successfully back the databases up via native SQL. The databases are not in suspect mode or read only. All databases pass when I run DBCC CHECKDB on them. Any ideas as to what more to check and reset so that I can back these databases up using litespeed.
All those colors mean is that the database has not been backed up in the number of days specified in Options. You can disable this feature if you are not actively backing up these databases. Go to Tools | Options – General – Database Status.