It was a damn legacy SQL Alert that should have been turned off months ago - always the last place you look. 😀

Remove/turn off alert - problem solved. 😎

Cheers all,

qh

Tempdb datafile is 10GB in size with 99% freespace

Master datafile was only 33MB and 1% of freespace remaining so I have increased this to 100MB now 66% freespace

I am still...

Getting bogged down in semantics here. 😀

Whether its Showcontig or sys.dm_db_index_physical_stats or whatever the next command will be - the point I was making is that someone with an...

For a very, very simplistic view of becoming a SQL Server DBA 5 stars, however in the REAL WORLD only 1 star - how many of us actually wanted to...

Solved this one ourselves. Didn't realise that there were different service accounts runnning on the SQL instances (old system) and the instances with a newer account worked fine...

Thanks for the reply. I had a similar issue to you where the named pipes registry settings for the cluster causing the problems was incorrect.

Again I had to hack...

A workaround was found by hacking the registry values and changing to correct path/instance name before the sql server service was failed over. This works with no errors, however...