From the documentation

How to Calculate Processor Licenses for a Single VM

If your Virtual host IS NOT hyperthreaded

# of Virtual Processors assigned to the VM / # Cores in the...

do a full backup on a weekend, differentials every day except your full backup day, tx logs every X mins/hours

E.G

Sat, Sun, Mon, Tue, Wed, Thurs, Fri

Full, Diff, Diff, Diff, Diff,...

Roy, can you detail why you would put your SQL servers in the DMZ, as I too, would consider this as a massive security issue.

Typically the DMZ is outside of...

you could try this to find out whats still on the filegroup

SELECT

o.[name] AS ObjectName,

o.[type] AS ObjectType,

s.[name] AS SchemaName,

f.[name] AS [Filename],

i.[name] AS PrimaryKey,

i.[index_id] AS IndexID

FROM

sys.indexes i

INNER JOIN...

is the data in the table encrypted so when you do

SELECT col FROM table

Col is returned in an encrypted state?

If so it looks like the insert done by the...

It would seem that your connection pool isn't clearing out dead/idle connections, or something spawned to many concurrent connections and the limit was reached.

Wasn't any changes to the app yesterday...

can you post your full error log

also MS say they have resolved the bug in this hot fix http://support.microsoft.com/kb/2543687 after a did a google search.

only other time i have seen this is when the server was rebooting due to automatic updates.

did your server reboot last night?

have you checked the SQL Server Configuration Manager on the server?

under SQL Server Network Configuration, Protocols for ~INSTANCENAME~ (named instance), or Protocols for MSSQLSERVER (default instance), check that Named Pipes...

If its running on a server I would always run a server OS, if your running it on a desktop for DEV reasons then either or.

If its a production server,...

Depends on you tape device and the software that its using.

You could add a dump device to SQL and backup to that.

Or if its mounted as a disk drive with...

yes, it is licenced on physical CPU's not cores.

for example, I could go and purchase a server now with 4 physical CPU's, these CPU's each have 10 cores, if I...

i think the best thing to do would be to set logshipping up in a test environment which mirrors live.

leave the databases in full recovery, and do your log backups...

i think the question is, how do you get the padlock on objects like some 3rd parties do, one example is LiteSpeed, where the properties of the object show as...

how many physical cpu's are in the box 16?

or is it 2 cpus, 4 cores, hyperthreaded? ((2 x 4) x 2) = 16cores = 2 licences

or is it 4...