I assigned the user to the TargetServerRole. The user then could see all of the jobs but received an error message that basically said 'cannot execute sp_start_job" ....

Thank you so much. I am going to go read to find out what the 'TargetServerRole' is. I am not familiar with that role.

I just showed the details to prove that the spid that is connected to the 'Trans' database is actually the one that just opened the Activity Monitor.

My initial inquiry to...

It is not a new [query] window or the object browser, it is when I open the 'Activity Monitor'. I've noticed on other servers when I open the Activity...

Thank you all. Using the Activity Monitor I can always see that the database is 'Trans' and the Application is 'Microsoft SQL Server Management Studio'; I am curious as...

It can be that the authorization credentials are cached for the services on failover but jobs scheduled for later don't have the credentials cached.

Received the same message:

DBCC CHECKDB

( 'MyDatabase' , REPAIR_ALLOW_DATA_LOSS

) ...

Nothing like stating the obvious. I had used the checkdb and it identified that the only object with a problem was the one table. so I thought I...

you seem to be available just now ... so let me ask you something else, just call me stupid. I saw where several other people received the -1...

Thank you. Great idea. When this mess is cleaned up I will copy the system files for safe keeping.

Just about as soon as I posted my question I found my answer.

the files were under the X86\DATA directory on the disk

and the main problem was that the...

tempdb is okay -- the files recreated when moved to an available drive, master and msdb are fine also.

The errors received now are for the user databases that had the...

I am trying to understand the components .... we have a development SQL Server that has the ReportServer database and the ReportServer tempdb; it has the dev copies of the...

Our developer has access to test and development databases; she has a server login and database access with object permissions. She doesn't need an actual copy of the database.

I...

Found the files and the restore is complete.

We forgot to restore the log file from midnight -- '0000'

Now at least I know the backups are working correctly!

Thank you.