you are welcome, and thanks for the kind words.

Haven't worked with Compact or VS that much for database work, but you have "autoincrement" set to true in that image. I assume that means the identity is set for...

I assume you mean differential since there is not incremental. Grant and Peter have good advice. Here's what I'd do, given what I think you are doing.

Dev:

Sat: full backup, delete...

Are you saying that you have two disks on your server and are thinking of manually moving the log file for model?

I don't think that the databases take their location...

MysteryJimbo is correct. If writes occur on only one node, then you should be looking at transactional.

If you are somehow trying to get people to connect to either node...

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