Yep, in 2008 the backup to a file defaults to append. http://msdn.microsoft.com/en-us/library/ms186865.aspx

It is possible that you have multiple backups in this file. You can use RESTORE HEADERONLY to find this...

Where are the variables? How are you setting them? You many or may not need to pass them in, depends on what you've done in the code.

Glad you liked the question. I was working on something else and learned a few things here.

Sad panda face.

Since Girardi left, but he's been someone I've enjoyed watching.

Thanks for the note, and I'd love to know how it works out. If you can grab some metrics now, and then some later, I've love to see a writeup...

I tend to be with Perry. There are ways that software can handle the imaging, and 4 hours seems long. But overall, I wouldn't build a VM, and a non-VM...

If you use the Configuration Manager, it should assign all rights SQL Server needs to the account. If you've moved anything, or you use non-standard folders for things like backup,...

I'd choose #1, but I'm conservative, and tempdb gets written to a lot, so I'd be worried about failure.

With the four files, one filegroup? Depending on your workload, you might...

Here you go, pie chart:

john.arnott (1/23/2012)

---

Re: Moneyball....

The lessons applied were not just in talent evaluation, but also tactical decisions while playing the game. Statistical analysis showed that outs are often under-valued and so...

I never merged w/ DB objects.

The Red Gate tool can help (disclosure: I work for RG), but it doesn't necessarily do all this. It's just an interface to the tool.

The...

It's close to the book, but there's much more in the book.

In terms of...

You are welcome, good luck, and if you have more questions, post away.

I'm not quite clear what you mean?

The two applications don't matter if they're sharing the same data. You just have code and tables, and you call what's appropriate from each...

I think what's confusing is you say "separate 1 for the data, and 1 for the code/engine", but you say 2 applications. So are you proposing, or dealing with:

db1

- data

db2

-...