Just make sure this is a one-time shrink. If you get in a situation where you're shrinking over and over, that leads to issues down the road.

Or both.

Markus (10/6/2015)

---

Ok, thanks for the assistance. Next time it happens I will query sys.dm_tran_locks and see what shows up.

The NOLOCK hint is a left over from when this was...

Oh, and I forgot, a wizard for setting up backup testing (aka, a...

I work for the company so...

Absolutely!

The biggest advantage is in multi-server management. You...

Michael L John (10/6/2015)

---

Ed Wagner (10/6/2015)

---

BWFC (10/6/2015)

---

I can't get my head around that kind of attitude, particularly when there'e so much...

GilaMonster (10/6/2015)

---

Seen that happen before. Brought am entire application to a complete standstill on all users' machines.

If...

jellybean (10/6/2015)

---

I do recall seeing message "x rows effected" but it may have been syntax error on my part. I *may* have done something like:

update someTable

set='newValue'

where someField='oldValue'

As I say -...

Unless they're starting a transaction and then walking away with it uncommitted. That would lead to this issue, possibly. As Gail says, we don't know what objects are being locked...

I'd suggest taking a look at the Minion tools, in your case Minion Backup[/url].

I might help some, but probably not much, especially considering the amount of memory you have on the system.

Locking and blocking are primarily an issue related to code and data...

You should be able to take another log backup and, assuming it succeeds, everything should be fine. You can check it by using RESTORE HEADERONLY to look at the Log...

Eirikur Eiriksson (10/5/2015)

---

Grant Fritchey (10/5/2015)

---

You can give the files any extension name, but it's the path and security to that path that are going to make the difference. Before you...

You can give the files any extension name, but it's the path and security to that path that are going to make the difference. Before you run the command to...

I'd take a look at Louis Davidson and Tim Ford's book

Performance Tuning with SQL Server Dynamic Management Views

It's free to download.