Cheers Gilla, have read a few blogs and articles about it and it would appear that if all else fails, recreate the database and import the data back across.

Don't suppose...

All down to permissions alright, permission had to be explicitly allocated at the root folder into a read/write group.

Fairly misleading error message when ran as a job, also seems very...

All down to permissions alright, permission had to be explicitly allocated at the root folder into a read/write group.

Fairly misleading error message when ran as a job, also seems very...

Sorted it myself, SQL Browser had not come back up online after the repair.

Also, just to mention that the install of SQL 2008 R2 was done with a slipstream version with SP2 applied. The Repair I ran would have been from the same...

Some more detail from the SQL logs

2012-08-28 17:36:17.97 Server The SQL Server Network Interface library could not register the Service Principal Name (SPN) for the...

Managed to figure it out, different versions of Red Gate between environments meant the Replace failed

The issue is down to this function:

function RedgateGetDatabaseName ([STRING]$backupfile)

{

$SQLConnection.Open()

$SQLQuery = "exec master..sqlbackup '-sql ""RESTORE SQBHEADERONLY FROM DISK = [$backupfile] WITH SINGLERESULTSET""'"

...

Found the offending query in the end, all down to the way I was trapping the offending queries in Foglight.

Ended up searching for every T-SQL statement and Batch that ran...

On further inspection, this query is not the reason why the tempdb grew. I have ran it a few times myself and it has not hit the growth rate that...

@jeff - The HAVING clause is based on a value being > sum(xxxx)

So the query has to run this check for ever single record in the table

Tempdb MDF doesn't seem to grow now when I run the query again which seems strange, I'm guessing this is down to the result set getting cached in memory

Haven't used...

Thanks Lynn, thought the aggregation would impact it but nowhere near the level it appears to do

Timeout option did the trick, thanks a million guys

Just wondering if version differences in Red Gate Backup could be the issue i.e. different arguments required per version

i.e. The script specifies SQL Backup v6.5.1.9

However, when I run the scripts...