As mentioned, you should be able to restart the restore.

The database can't be moved to norecovery or standby if recovery has been run.

The script is

alter database mydb

set encryption off

go

DROP DATABASE ENCRYPTION KEY

go

use master

go

drop certificate mycert

You'll need to change the names to match your db and cert.

Audit works well, and you can keep the data, but it's hard to parse. It's more like it was built to track things for a human to review, which is...

I've edited the question to state Management Studio 2016.

As Grant mentioned, this has nothing to do with SQL Server versions, but the tools version. However, since these were linked prior...

Sean Redmond (12/13/2016)

---

A senior developer who recently left our company expressed the opinion to me that the DBAs should be in charge of the Data Access Layer.

He was very definite...

Markus (12/14/2016)

---

GeorgeCopeland (12/13/2016)

---

The release cadence may be increasing but the issues remain the same. I recommend upgrading vigorously, say 3-6 months after a release so there is enough time to...

Fingers crossed. The projections have me losing, but hopefully Rodgers, KC, and Crabtree can do something for me since I lost my main RB.

Charles Kincaid (12/11/2016)

---

One possible downside of the fast release pace is the expense of upgrading. Paying new license fee each year or two is going to be very unattractive...

Haven't seen this, either. I would think that it's similar to what you'd do for on-premise for a restore to the same instance. If it's a DR to another instance,...

I was thinking that, or a TVP that takes a list of IDs and then joins to the...

https://voiceofthedba.com/2016/12/13/t-sql-tuesday-85-cross-version-restores/

and

https://msdn.microsoft.com/en-us/library/ms186858.aspx

Are you looking for general ideas here?

I'd make sure your backups are working well and meeting your RPO/RTO for each db. Script out logins, linked servers and jobs to be...

Ah, apologies. My fault. Didn't fix the answer correctly.

should be ok now

Friday, hectic day as I get ready for SQL in the City next week and a flight across the water on Sunday.

Then I'm off for a week, so if I'm...

Yeah, I think the initial note I got a couple weekw said that TDE would be included, but I realized this week it wasn't. Forgot to correct things.

Fixed and points...