I have a job that every night restores a database as
Today that job failed to work properly, and when I went in to look at it, the job was still marked as running, but won't stop. The _TEST datbase doesn't show up when I list databases (or query sys.databases). I can see the files in the temp location they get placed, and they are locked so I can't delete them.
When I try to open activity manager, I get the attached error (Database 'AZPPLUS_TEST' is being recovered. Waiting until recovery is finished. (Microsoft SQL Server, Error: 922).
I've tried detatching/dropping the database, and it tells me it doesn't exist.
Anyone know what to do? I have the problem on our dev box also, and bouncing the SQL service fixes it, but I'd rather not do that on our live box if it can be avoided.
The Redneck DBA