A very nice little bit of code. You could probably go to town on this one and set up SSIS packages to load the output file and then a...

See I missed this on Friday so was still busy chewing some sour grapes!...

I don't mind. After the shenanigans of last week it's nice to have a question that really does only have one possible...

Not that I'm bitter about getting the question right but selecting the wrong answer 😉 but I reckon we could have a few more possible answers.

If we're saying that unique...

I think one of the major advantages of cloud services is that of resilience. I know there have been some very high profile cloud service outages in the past,...

Sometimes in order to achieve the big-bucks salaries you have to make sacrifices along the way. I know a couple of people who wanted to break in to the...

I think I'll probably end up taking the exams. Simply because I will spend some time learning about 2012 and the various aspects of it. I could probably...

I misread the question initially and made the assumption the question was referring to the log backup as opposed to the file. It was only after I clicked Submit...

I don't understand is how tempdb can't allocate a new page. With 37Gb of free space in the db itself, plus autogrowth potential, this seems way too much space to...

A nice article providing step-by-step instructions (although I haven't quite figured out what the light bulbs are for??)

But I agree with Koen, perhaps something that highlighted potential gotchas when installing...

Thanks everyone for getting in touch - I really do appreciate it.

Simha, unfortunately virtual memory isn't the issue. As the memory usage ramps up when the snapshot is taking...

Thanks for the replies. In response, firstly my hammering of my square peg...

Kevin, the subscriber is on a remote site managed by a third party, and therefore co-ordinating...

If anyone has any ideas on this one it would be very much appreciated! I've got the backup plan of being able to initialise from backup, but ideally I'd...

Thank you very much Gail for clarifying all of this (and for the excellent article on COPY_ONLY). You have certainly added a lot of clarity to my understanding of...

Echoing everyone else's comments - great article!

However, I was all prepared to query your statement in the article:

It is important to note that while a full or differential backup...