I don't think the exclusion works. Are you post SP2 on 2005? There were some fixes in a couple of the hotfixes after SP2.

There are scripts here to help you...

First, please stop bolding everything. We can read it fine without adding that.

Second, what's the view code?

There is no issue with the index. The SQL indexes do not get out of date like those you manually maintain, or index with something like FoxPro/dBase. They are built...

Good point, Mike. We need to have instrumentation embedded, and it needs to work. I used to complain about performance monitor dropping events. We need this overhead to be in...

This is confusing, mainly because MS is reusing terms in a new way. I wish they had called this something else.

If you understand log shipping, then you should know that a log backup is a log backup. As long as they're in sync, in a chain, they can be used...

There is no "log shipping backup"

Log shipping is a process that uses normal log backups and sends them to be restored to another server in an automated fashion. The log...

I'm confused, do you have log shipping taking tlog backups and separate t-log backups?

That won't work as log shipping needs to have every single log backup sent to the secondary...

There might be low level developers, but if they triaged reports of bugs, at least it would be captured somewhere. I know in a company that employed 200 people that...

Arjun,

Companies have outsourced manufacturing to other countries for years. The US has done it in Mexico and China. Japan has done it in Korea. The UK has done it in...

Jeff is giving you the right idea. Basically when you fail to the mirror, then it starts receiving transactions, and I assume, making log backups.

Those log backups need to go...

The certificate is a "fancy password". You need to protect this to ensure that the database is protected.

If you take a database our of restoring status, then you break log shipping.

A backup isn't taken from the secondary database, it comes from the primary.

Are you planning on running in 80 compatibility mode? Or upgrading to 10?

Your career is up to you.

I think you ought to try and be thinking about whether your not your job can be outsourced, and what you can do about it....