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

New SQL Rally designs. Cast your vote

http://99designs.com/logo-design/contests/pass-sqlrally-exciting-community-event-49372

Wait, you can't back up a log in simple mode? Can't I stop the service and just copy the file? :w00t:

Someone is still connected to the db. Connect to another db, like master, and run sp_who2 to see who is "using" that database.