Oops. I was (partially) confusing server side traces with Profiler Traces...

With this particular trace and the rules, no. The goal behind it is if something needs to be investigated later, we're able to dig into the trace files.

Between the...

Where I work has similar requirements, and actually provides the script to create the trace. Downside is, they write the trace to disk and default it to 1GB files...

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...