Thanks Robert, I'll take your advice. It's going to be a tough 6 hours so will need to be well on the ball. It was a relief to read in...

Hi,

I'm taking the MCM lab exam in London, 2 weeks from now, and used the same center for the knowledge exam a couple of months ago. There were builders in...

Another significant problem with maintenance plans, well documented, is that the 'Verify Backups' check box doesn't translate to backups WITH CHECKSUM. It actuall runs a restore verify only immediately after...

A scratch servers the way to go, thanks 🙂

So the only way to verify the integrity of your master database backups on a busy production server is to use restore with verify only!

I had to recovery a master database in production recently and used this blog as guidance, it worked an absolute treat.

http://blogs.technet.com/b/fort_sql/archive/2011/02/01/the-easiest-way-to-rebuild-the-sql-server-master-database.aspx

It's a possible approach to verifying production...

There are fantastic scripts and articles/blogs on your sqlskills website Paul. Anyone with an enquiring mind can use them as a starter for ten and extrapolate out entire features sets...

The Ola Hallengren maintenance scrips create SQL Agent jobs that use sqlcmd to instantiate the backup and maintenance procedures he has written. Rahul, if Ola isn't overly concerned about patents...

.

.

Pleasure, thanks for the reply 🙂

There are 163 advanced functions available here - http://sqlpsx.codeplex.com/ , I could review them, put them in a Business as Usual sort of context and consider how to...

Ukgav suggested getting a proto type running which I'll try to do (on a local instance of sql) but it won't be until the end of July. It's a good...

It was impossible to get a SQL Azure instance, hopefully there will be some sort of developer edition eventually.

Thanks Gavin , that is a coincidence, I'll look him up.

Cheers