A reboot cleared this up.

Does anyone have a definitive answer for this? This is an absolute nightmare.

Yes, The database is a principal in mirroring. The mirroring session had actually been suspended for a few days (oops), transactions were being hung up in in the...

Turns out mirroring had been suspended for a while. Broke mirroring, truncated the log, now rebuilding mirroring.

thanks everyone

I have SA rights. Like I said, this works fine in all other databases....

edit: Database appears to be identical in options, etc as all the other databases.

Here is...

Excellent write up. I've been looking into implementing this on one of my servers. Would it be helpful to look that the total composition of the plan cache...

In a 32bit OS environment, 2GB is reserved for Kernel mode, and the other 2 is reserved for user...

of course 🙂

Geoff A (5/4/2012)

---

Developer Edition allows developers to build and test any type of application with...

Got it:

function Get-SqlCommand

{

param($serverName,$databaseName,$query)

$SqlConnection = New-Object System.Data.SqlClient.SQLConnection

$SqlConnection.ConnectionString = "Server=$servername;Database=$databasename;Integrated Security=SSPI;"

...

awesome, thanks!

GilaMonster (1/13/2012)

---

No.

Alter the databases to read-write, set recovery model to simple, ...

It looks like adding the WITH INIT option did the trick

Hi, I appreciate the response. That was a typo on my part when creating the post. Additionally, It would have generated a file does not exist error.

It was a bad iso image. I re downloaded and its working fine