Always fun the day after an emergency SAN firmware update which requires all SQL VMs and physical Oracle servers to be shut down...

Thankfully, the update went smooth, all my SQL...

Without installing some sort of monitoring tool, you're pretty much limited to setting up a Windows Scheduled Task, and a script to check if the service(s) are running. Downside,...

Brandie Tarvin (8/27/2013)

---

GenCon was a working vacation. I worked 3 eight hour shifts in the Catalyst Game Labs booth, helping run the Shadowrun Experience (the interactive demo of our fifth...

Cool, thanks!

I thought it sounded reasonable, as you've got several options in case the upgrade goes wrong:

1. Restore VM snapshot

2. Restore snapshot and DB backups

3. Load up...

sql-lover (8/23/2013)

---

I would stay away of defrag the SAN with the built-in Windows Defrag, specially if your SQL boxes are virtual, and you do not have physical mdf or ldf...

/me sits back, munching popcorn while reading the Full backup / transaction log breakup topic

😀

Hey!

I *said* I resisted!

And yeah, I read through it, and the poor guy seems rather confused. Reads to me like he thinks the log shipping setup also ships full...

So I saw this forum posting this morning: Full and transaction log backup chain breakup

And had to resist the urge to post a reply of:

"Well, if Full would take Transaction...

Man, they have an "appreciation day" for employees, and this place gets deader than the old Michigan Railroad station...

I'm almost tempted to start reading this topic from page 1 and...

Koen Verbeeck (8/22/2013)

---

Steve Jones - SSC Editor (8/21/2013)

---

It's been in Sept before, a few times, and once in Jan when the Sept one was cancelled because of a hurricane.

When it's...

DOGGIE! :hehe:

I think maybe not 100%, but close. They've found that everytime an update is pushed out for this AV, Sharepoint starts having problems.

We are set up in a "farm"...

Well, so far (knocks on wood) my SQL boxes aren't being impacted too bad by this. It's the Sharepoint guys who are having headaches. I think I got...

SQL2005 doesn't have Extended Events, so you'd need to use the trace flag option, which won't get you your information from 15 days ago. There's not much you can...

Presuming you're on SQL 2008, you could try querying the Extended Events. Depending on how much has gone on since the day you need, however, the information may already...