Thanks for the response, Jeff. I already know everything you wrote and you're correct.

The problem is a little more complicated than I've indicated and I wanted to stick to basics...

Thanks!

Thanks for your response, Gail.

From all the documentation I've read, I thought the database on the secondary could be restored in STANDBY mode allowing it to be accessible for reading.

From...

Kevin,

In response to your question:

"BTW, did you try a test restore (or even filelistonly restore) from the other SQL Server using a tsql script via SSMS?"

I didn't use a script....

Thanks to both of you for responding.

To answer your questions and suggestions, I'll explain the accounts, shares, and permissions in place and maybe that will produce the right information. After...

If you do just a little searching with Google, there is plenty of information about this type of wait, although some of it is incomplete.

This wait is to obtain access...

One of the best DBA jobs I ever had was at a firm whose chief data scientist and I argued like lawyers.

We both agreed not to take anything personally, so...

Software developers don't like the SQL language primarily for two reasons:

1. It's a minefield of performance issues with many side effects, unlike the object oriented languages most were trained...

Steve:

"...it calls for developers to support the features that they write, even in production systems. I like this idea, though I don't think that it should be a continuous expectation...

If a human being can figure out how to do something, that process can be automated.

...and I forgot to mention that I learn best by reading and doing.

The "do" part is important for the information I read to stick.

The jobs where I've learned the most had the most poorly managed IT shops. One of my former employers, a $100+ million revenue/year company, was not Agile or anything else;...

I have found that any process that I can implement manually, no matter how complex, can be automated.

Automating it may be difficult, it may require a lot of time,...

"Is there such a thing as a 10X programmer?"

It depends.

It depends primarily on what is being coded. For instance, if I'm writing a module for the kernel of an operating...

Steve,

In your vision, what does "making the data more available" look like?

If my employer requested giving people access to data, of course I would implement that.

But what would a...