Switching to simple breaks your recovery chain, if you are backing up logs and expecting to recover to a point in time.

ISNULL - http://msdn.microsoft.com/en-us/library/ms184325.aspx

Or Coalesce - http://msdn.microsoft.com/en-us/library/ms190349.aspx

I'm with Gail. Separate backup file every day, with timestamp in the name.

Maintenance plans will do this. Ola Hallengren has a great script on this site that can help you...

what's the variable supposed to be? Or how does it change? you're leaving out lots of details.

For example, if this is a date, you can configure the script to pull...

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