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

I'm with Jeff, and I'd toss in a few other suggestions as well...

First, pick up or download (hey, it's free!) a copy of "Troubleshooting SQL Server A guide from the...

Castle

You're quite welcome!:-D

Short answer:

Nope.

😀

Long answer:

The only way to "break" the TLog backup chain would be to switch the DB to Simple recovery and back to Full. If you had a full...

Ed Wagner (6/19/2014)

SQLRNNR (6/19/2014)

Stuart Davies (6/19/2014)

Sean Lange (6/19/2014)

SQLRNNR (6/19/2014)

JAZZ Master (6/19/2014)

SQLRNNR (6/19/2014)

Ed Wagner (6/19/2014)

crookj (6/19/2014)

Ed Wagner (6/19/2014)

djj (6/19/2014)

Visual...

Quite possible, and relatively easy to do.

Just keep this guide handy:

http://msdn.microsoft.com/en-us/library/ms143799(v=sql.105).aspx

and you shouldn't have any problems.

Of course, you also need to change the connection on the workstations, which depends on...

Well, the log results are in, and the cause of the time increase?

The Index rebuilds. They're around 1/2 (maybe a bit more) of the total time for the SSIS...

That explains the deja-vu when I saw the same person walk past...

That explains the deja-vu when I saw the same person walk past...