Talib123 (9/3/2013)

---

Use the Repoting services configuration manager on the system you want to move.

Backup the RS encryption cert . Backup the RS and RSTEMPdb with copy.

Install SSRS on new...

We're running SSRS 2008R2, and will still be on SSRS 2008R2. It's the OS that's getting updated.

GilaMonster (8/31/2013)

---

Just ....

Sent late on a...

OK, I've learned my lesson...

Never, ever, ever, never, ever run DBCC Timewarp(slowtime) in production on a Friday...

At least I didn't use the "Reversetime" option...

:hehe:

Seagram's 7

Springsteen

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