Scott has good advice, but I don't see a lock. A database backup can occur without interrupting activity.

I think what Jeff is implying is that we have no idea if you are just grinding your own ax with Bill. You have no details or information, and perhaps...

GSqaured,

Sorry to hear that and hope you have some great memories. I know as I get older, things hurt, it becomes harder and harder to stress the body. I've learned...

I tried, even tried to sweat-talk the Toshiba tech, offering some SWAG, but no XP drivers for a few things on the laptop. I suppose I could dig through the...

Dr. Andras is correct, the length doesn't matter if it exceeds the total length. I've used 1000 sometimes when I'm not sure if I have 10 or 20 more spaecs...

I tend to agree with Sean. It depends on a lot of things.

Log shipping/mirroring are nice in that they cover the database. Replication requires you to setup replication for all...

Lots of things will work, but unless your developers can continue to update them and follow the standards, things will have problems.

This is really more of an administrative issue than...

There are quite a few articles on this site regarding moving databases. Search for that and you'll get some answers.

I thought that a security admin would be able to add a user to any database. Is that not the case? Have you tried logging in as the RED user...

The witness is for database mirroring. The clustered servers monitor each other with a heartbeat to determine if the other is still alive.

I think most of the books out there contain lots of the same material. pick one up and it will help guide you.

To build some skills, I'd read through questions...

I'd tend to agree with Atif. The first few aren't really understood by the kids. Get your wife some time, have fun with your son in the park, hiking, laying...

Unless you have a good reason, and understand it, you SHOULD NOT set a production database to simple mode.

The transaction log is essentially a copy of all the work done...

Please don't cross post.

I'd also recommend you rewrite this as

select x

from table a

inner join table b

on a.x = b.x

rather than your syntax. It's possible...