did other customers disable connection pooling ?

spaghettidba (1/13/2015)

GilaMonster (1/13/2015)

Correct.

Any login that's a member of the sysadmin fixed server role bypasses ALL...

Can you check on your NAS that the target folder isn't compressed ?

I've seen sqlserver backup commands having issues with windows compressed folders.

NOW !

Roust_m (1/12/2015)

This is a replicated database with NOT ALL...

simple: total db size = data file size + log file size ;

20GB + 8GB = 28GB

You can easily get an overview of all completed backup commands and their generated backup sizes, as they are registered in msdb !

declare @DbNameLike sysname

declare @OnlyLastBUset bit

Select ...

any other files ( besides the log file, as Gail suggested ) ?

burfos (1/9/2015)

I haven't on this particular server as the...

Roust_m (1/8/2015)

The goal is to drop the FKs, truncate some tables and re-create the FKs with nocheck option (this is to keep the database schema almost the same.

Could you spare...

FWIW I hope you enabled Instant File Initialization as it also works for restore operations !

Instant File Initialization and restores[/url]

What's the goal of your action ?

The use of temp objects is fearsome, because - I assume, you'll be dropping and re-creating the DRI in the process. If that fails,...

since this is occasionally, I would suspect the restore process not being the 'single user'.

Can you double check there isn't anything between the 'set single user' and the 'restore database'.

That's...

the deadlock resource is dbid = "10" objectname = "F1SB.dbo.LiveMatches" indexname = "PK_LiveMatches"

that is the object involved in the merge operation as receiving object !

I've seen trancount =3 mentioned ...

you'll have to investigate the object referred by waitresource.

e.g. "KEY: 27:72057594095534080 (989126c604a2)"

and interpret how that resource is being used by the conflicting threads