Good comments, and I completely understand if someone can't run, or volunteer. I have my reasons, similar to Grant's. However make sure they are really good reasons and that you...

The answer has been corrected to show the correct database name. Good catch, and you can submit changes to BOL through Connect.microsoft.com

If the logs didn't get restored, they wouldn't be there. Sometimes people delay logs by time, so check that first.

If log shipping is running, the changes move. No way they...

I'd agree with Jason. If you just want to get data onto the web, SSRS is probably the easiest thing to do.

I mostly do this for Grant's reasons, but nice catch Elliot on missing rows in the second table.

OLAP, SSRS is just a tool. To do web based analytics, you need a web application that allows you to access data. There are tools that can do this, or...

rerun setup. There's an option to install client tools.

What are you worried about? You are doing a backup and restore. The DDL is the same, or it is once the secondary has caught up to the primary.

You can...

Can what be a simple thing like Excel? I'm not sure you've defined the problem you have very well.

Submit it here: http://www.sqlservercentral.com/Contributions/Home

We'll help you rewrite/draft it. Some notes here as well: http://www.sqlservercentral.com/About/WriteForUs

LOL, it wouldn't be quick if I were at TechEd. I only have a couple times a day I check things. Back home today.

The article would be short, but it...

Any suggestions from South Africa? Something from Cricket, Soccer, etc?

Post us a script, or send me an article, MG, when you get it working. That is something others can use.

Good suggestions. I'll think about adding them in.

I'd agree with BT. If you're not explicitly closing connections, and maybe don't have connection pooling, you could get this behavior.