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

Ray Herring (12/9/2014)

---

Early in the script (about line 5) you set ToFileOnly = True. Then about 3 lines from the bottom you set the option to False.

is there a...

Brandon Forest (12/8/2014)

---

Thanks for the article. This is something I've been meaning to do for awhile, but have been too wrapped up in other work. Now if someone could...

MG-148046 (12/8/2014)

---

Thanks for the info. Do you know if a message is outputted when an encrypted object is encountered? I currently check for IsEncrypted and write a message to...