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...

Not quite what I'm talking about, Rudy. @=)

Though the striping could be used as part of the...

I don't have specific links, but check out Backup in Books Online or Google "Backing up SQL Server", "Backup VLDB SQL Server", things like that.

The problem is, because everyone's...

Your backup strategy may need to be revisited at this point too. If you're still using the "small DB backup" strategy, it's probably taking a ton of maintenance time.

Regardless, if...

Well if everything we suggest is too much work, then I'm afraid we can't help you.

Sorry.

You're welcome. And thanks for the luck.

Let me know whether or not this does what you're wanting.

Bad joins between the Dimension tables and the Fact tables. Depends on whether you're getting too many records or not enough records.

Check your table relationships.