Another option for preventing connections to the DB so you can restore in peace, would be to set it to offline, rather than single_user or restricted_user.

See this topic:

"What can I...

I'm using the following WMI to trigger alerts based on disk free space (the size is set per disk):

select * from __instancemodificationevent within 1 where targetinstance isa 'CIM_LogicalDisk' and targetinstance.freespace...

I would almost say, in that situation, if you've got the disk space, it might be easiest to do the following:

1. Backup the TLog

2. Shrink it down as...

Steve Jones - SSC Editor (9/16/2013)

---

jasona.work (9/16/2013)

---

...

When people say "cloud" most automatically think of the big commercial offerings (Azure, Amazon, etc.) But it doesn't have to be. It...

GilaMonster (9/16/2013)

---

jasona.work (9/16/2013)

---

Right up until I...

For myself, I've been using a "personal" cloud at home (a couple Hyper-V Servers, load whatever OS and application I feel like playing with / learning) and find it to...

Right up until I aim the...

What happened? Nothing new in here all weekend, and it's not even any sort of a holiday anywhere (that I'm aware of at least...)

Just think everyone!

Only 101 more shopping...

Ed Wagner (9/12/2013)

---

I heard there was one at Lawrence Technological University once. That would have been great, but I didn't hear about it until afterwards. There's nothing close...

Thanks again guys!

A little more Google-work, and I found code that sounds like it will do exactly what I'm looking for over on SQLSkills, from John K.

http://www.sqlskills.com/blogs/jonathan/tracking-sql-server-database-usage/%5B/url%5D

Once again, thanks!

Jason

I believe the answer to this next question is yes, but I'd like to be sure:

If I create an XE session on SQL2012 (for the GUI) and save it as...

I'm going to take a look at XE going forward for this, but it sounds like in the short-term (as in, need a number / date yesterday) I did the...

Jack Corbett (9/10/2013)

---

Interesting. I'd be more inclined to use a Server Side trace or XEvents to see if a database is used.

I don't think using the last_user_update column...

Koen Verbeeck (9/10/2013)

---

Grant Fritchey (9/10/2013)

---

L' Eomot Inversé (9/9/2013)

---

Grant Fritchey (9/9/2013)

---

Not sure anyone noticed, but we passed the three year anniversary of the thread. Thank the gods the terrible twos are...

Revenant (9/6/2013)

---

SQLRNNR (9/6/2013)

---

L' Eomot Inversé (9/6/2013)

---

Ed Wagner (9/6/2013)

---

SQLRNNR (9/5/2013)

---

crookj (9/5/2013)

---

jasona.work (9/5/2013)

---

Yes,...