Lisa Slater Nicholls (5/15/2012)

---

The key thing here is (pace Steve) we don't actually "do the same work for decades". Come to think of it, really good carpenters don't...

Sean Lange (5/15/2012)

---

I certainly would never want to stifle creativity or new ideas. That is truly the basis of the business we are in. The self-service side of the industry...

How often do we see on this site decisions made by people who work as DBAs that are awful? These people are often trained for this work and still make...

I thought the parallel with Mrs. Streep from levynissim was pretty good. We don't think that experienced people in many industries are worse than younger people or worth less.

I see what you are saying and clone/snapshots make some backup scenarios work, but changes, incorrect loads, any number of issues occur that require backups. I suppose logs work, but...

There is no way in SQL Server 2008 to do this inside the database. Actually, this always is the app level, even in SQL Server 2012.

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