1
vote
0answers
81 views

state_desc field in sys.databases Seems to incorrectly report “ONLINE” when it's still in recovery

Is it normal that select state_desc from sys.databases where name='mydbname' reports ONLINE instead of recovering? The database is not accessible and Recovery is still at 24% according to the ...
0
votes
3answers
604 views

SQL Server rolling forward lots of transactions, what should I look at?

I am running SQL Server Express on a Windows XP Embedded box. It runs for a day or two, doing some transactional processing for a POS type system, and with another system pulling data out to an OLAP ...