Hmmmm.... that's what I thought so thanks for confirming.

The reason I'm asking is because I have a job which performs daily differential backups and another which does fortnightly full backups.

So...

Perry Whittle (11/7/2012)

And that's good news!!

So, none of your databases require a point...

I think the question is to see if you know how to transpose rows to columns.

Really sorry for the late reply GSQUARED (why do I keep calling you CSGUARD?!)

I may have missed something, but do all the Full backups have to be on the same...

It turns out that two of my databases didn't have full backups which explains why the differential backup job failed.

Thanks for the suggestion Tony!

I have this book and yes it does have plenty of illustrations yes. Not bad book IMHO.

If you're comfortable with SSIS/SSRS then Parts 1, 3 and 4 will be very...

Here is how I understand it, maybe the OP will find it useful.

Think of SQL server as a shopping mall, the databases are individual shops, and the main car park...

When you create the SQL Server logins, specify SQL Server Authentication only?

However, windows authentication (when configured correctly) is very secure and will be less headache for your DBAs 😉

LOL.. was faced with the same problem earlier. Thanks for sharing how you found the setting!

Thanks Anthony.

I've reconfigured the job to output the log to a text file.

Let's see what happens tonight.

Arrgghhh, the above output is actually the last part of the string from the job log history table so I'm afraid it's all I've got to work with.

Create aggregate tables or use SSAS.

Why do you want to convert this to CLR? Unless I'm missing something, I don't see what a CLR version of this sproc is going to give you that a...

That makes sense. I know you're right.. there must be a FULL somewhere but as you said, if the DB was created from a backup on a different server then...

Let's see what my new DBA repository tells me:

18 SQL Server instances.

492 Databases.

6TB of data