Whaaa? No backups of your laptop? None of your music? No pictures?

😉

What's your plan? Not allowing changes to model?

I wouldn't say that's a plan, or even a best practice. Model exists to make a template for new databases. I know people...

Hmm, I ran a test and moved my model log. Creating a new database doesn't put the log in the new spot.

You might want to look at differentials, which could potentially help with recovery time if you end up with many log backups to restore.

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