Possibly the database in question might be set to auto close? Check in the properties -> options section for the database, and if the "Auto Close" option is set...

You could migrate your Server3 SSRS to be hosted / run on Server1 (presuming it's not clustered.)

Install a new instance of SSRS, do NOT set up the databases.

Backup...

Night :hehe:

I too am one of those people who came into IT through the side door...

I started out in High School being interested in architectural drafting, the computer bug bit when...

I'll be applying it to my QA servers either tomorrow or Saturday. I've got no clustered SQL to worry about though, so there's that...

Thanks all for the well wishes!

If you're interested, here's some pics from around the area showing the flooding:

http://www.clickondetroit.com/weather/images-flooded-metro-detroit-roads/27419082

Lynn Pettis (8/12/2014)

---

jasona.work (8/12/2014)

---

So we had some torrential rain yesterday (up to 6" in some places in a couple hours, more than double the normal rainfall for August) Roads...

So we had some torrential rain yesterday (up to 6" in some places in a couple hours, more than double the normal rainfall for August) Roads flooded, basements flooded...

I would suggest having the Commvault admins configure it to skip your MDF / LDF / NDFs, and only back up "normal" files. Additionally, you can likely have them...

Lynn:

Here's the info:

STIG ID: SQL2-00-021300 Rule ID: SV-53265r1_rule Vuln ID: V-40911

The reason we went with TDE rather than full-disk encryption such as the check mentions, is we're on...

Jason,

Yes, each step in the Agent job was the "Create database encryption key" and "alter database enable encryption" steps.

Aanndd thanks to this, I got all paranoid when one of the...

Perry: I think CPU-wise we should be OK, and I'm not going to "bulk encrypt" all the other DBs when I'm done, I'll be doing it in chunks. ...

We're required to comply with the DoD STIG guides for our systems, and one of the requirements is "data files containing sensitive information must be encrypted" and "SQL Server must...

What a way to come back from a long(-long) weekend...

The other DBA (more a developer with DBA knowledge) in trying to get a bunch of Sharepoint DBs backed up to...

In a pinch, yes, you can attach the MDF / LDF and have a working database.

An example situation would be if say the OS crashed hard, you booted the server...