Ah. Okay. I think I'm getting it. But here's a sanitized version of the main summary (Fact) table:

Create MyTable (ReportType tinyint, BeginDate datetime, EndDate datetime, PayType varchar(20), BatchNumber int, PayeeID...

Taking FULL backups of your main server should not interupt the log shipping process. So long as you continue to restore the logs to the LS server *in order*. EDIT...

There's no good answer to that. It depends on your hardware, your server configuration, and how much parallell threading you allow the server to do.

If you absolutely need a number,...

Not quite sure what you...

Have you checked the mail server name? If the SMTP mail server isn't working, then SQL Server would queue the emails and not realize anything is wrong.

Also, it could be...

I'm not missing detail values so much as the details are even aggregated. I know that sounds odd, but that's the way it is. Say you have an order with...

I agree with Lynn. Unless you're experiencing serious space issues, leave it alone. I've had this problem several times myself and usually it's a valid process. Only on rare occasions...

By the By, your restore plan for the main server (assuming you use FULL, Differential & Transaction Log backups) will need to be as follows:

Restore the most recent FULL, restore...

I disagree with everyone. This will affect your backup. Because I don't see anywhere in your plan where you're backing up the transaction log.

Unless Log Shipping has seriously changed, you...

Are you trying to send a Service Broker email or just an email to some end users with DBMail? It makes a difference on what you troubleshoot.

Find yourself a long query. Change the connection timeout properties of your DEV server so that it will force a time out. Create your alert. Run your query. That should...

rajganesh.dba (5/18/2009)

---

...If there is one default instance and three named instance of SQL server....If i need to make use of Integration,Analysis,Reporting and notification services for all instances , do i...

I think the only way to do this is to use Profiler or run a trace against your system. But this will only give you a snapshot in time. It...

Hate to say it, but I believe the backup chain was broken when the Recovery Mode was reset. This is probably why you can't continue with the log restores.

My advice...

This sounds suspiciously like a homework or test question. We don't answer those on this site. It shouldn't be too hard for you to find the answer. Look up MDX...