Abu, I don't think it's really about the money,...

Paranoia says back up the DBs, even if they shouldn't need it...

😀

Cool, thanks. No I have no intention of trying to browse the DB itself.

Thanks!

Jason

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