I have looked all over the web and forum about this error below that I kept getting no matter what type of restore that I initiated. I initiated RESTORE WITH RECOVERY and as well as WITH REPLACE, tried to do the restore via Enterprise manager within the server, same result. This is a restore that works every month but this time, it will not do it. Please help, I have already spent 6 hours on this with no luck
[298] SQLServer Error: 4060, Cannot open database requested in login 'QAS'. Login fails. [SQLSTATE 42000]