For a point in time restore, it doesn't matter how to schedule things. The log backups contain all the necessary data. The full has some log information, but if you...

Joe Johnson-482549 (5/14/2012)

---

I moved into management a while back. I still lead projects and I try to stay up on the technology side but it gets harder and harder...

True, but if I have doubts, I try to...

Read some of the...

For sure.

Craig-315134 (5/14/2012)

---

Terrific editorial, Steve.

I'm aged 56, and after a couple of successful stints in IT management, I returned, of my own volition, to software development some years ago. And at...

I have found documentation to be key in my career for CYA, but mostly for just being aware of what was agreed to. My memory has proven to be as...

you are welcome, and sounds like...

GilaMonster (5/12/2012)

---

Talking about London, heading that way tonight and won't have much time for SSC while I'm there. Could some people keep a watch for corrupt databases, production restores or...

I do think most of the good senior DBAs have jobs. If you know of one, and they become available, you should hire them.

If you need one, contact a...

You need to read about files and filegroups in Books Online. By default, a database as one MDF file for data, and one LDF file for logging. You can add...

It would help if you provided some DDL for the tables and list the relationships that are defined.

If I read this correctly, you have multiple databases that are...

IIRC, there isn't a difference when you grant. If you add new objects, they are picked up by datareader/writer. Seems to also work in R2.

I've usually had the media for downgrades already. You can re-use an old key, IIRC. If you don't have it, I'd contact the seller or MS.

That book talks about that. For the most part, it recommends you not drink, or have one, and do not bring your family, or bring them for short periods.