Bit of an old thread, but issue we have had looks to be a known SQL 2012 bug. I have found the blog:

http://www.travisgan.com/2013/05/sql-server-2012-simple-recovery-model.html

Seems this issue will...

Typical that shortly after I post this I find answer.

You also have to update the INSERT, UPDATE, DELETE stored procedures to get this to work (in statement delivery section on...

Hi Guys,

Thanks for your input, I was able to get this working in the end. As previously mentioned, you do need a SQL 2008 engine to act as...

Hi,

Thanks for reply. It's my understanding that you can have 2005 SQL as a witness, as far as I know it shouldn't be a problem? I did...

Hi,

Just to conclude, restarting the server seemed to fix the issue. Could not find out what the issue was in end which is frustrating!

Hi,

Sorry for late reply, I cannot see anything in the SQL logs either. We have decided to give the server a restart tonight, as we need to apply...

To add to this, running:

msdb.dbo.sp_help_job

Errors out with:

Msg 0, Level 11, State 0, Line 0

A severe error occurred on the current command. The results, if any, should be discarded.

I have...

Hi,

My gut instinct is that this is not a SSMS issue (although could be wrong you never know), i think somthing odd is going on with SQL Agent itself....

Thanks for your replies. Mirroring is definately an option now as I have convinced the guy to have these servers purely SQL. However there will be some moaning...

Thanks for that, very useful!!

I have more questions now (sorry).

Is it possible to create a 2 node (active / passive) cluster where the SQL databases are not using shared storage....

Just to add to this, reasearching this I have found node and file share majority for 2008.

Node and File Share Majority is a quorum model in Windows Server 2008 Failover...

Had to resort to server reboot in the end. SQL came back up with no issues. This was a weird one for me. If anyone can explain...

Hi,

Yep has been changed in AD, however login on SQL has not changed.

Well afraid I can't give you an explanation!

I spotted someone running a query (when he shouldn't have been) and soon as I killed it the free space was...

Hi,

Sorry guys turns out that the problem was not to do with me. A user was running a stupidly large query on one of the other DB's which...