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.
Could you provide a screenshot?
Separately, are those databases participating in replication? If so, and you are on 7.5, we are aware of an issue and have created a 7.5.1 to address it. You can contact Support for the update or download from SupportLink (should be posted today) or download from Quest.com.
The databases in question are not participating in replication. Here is a screen shot of what I am seeing in the Litespeed console.
I have checked the sql server that has databases that are replicated and the display is all normal.
Are those database undergo Log Shipping?
None of the databases on the QA server are participating in Log shipping.
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.