Looks like there was a security patch 13.0.4206.0 released Aug 8 KB4019091 for SQL 2016, SQL2014, SQL2012.

So I set up a test and in simple terms this is what I did and it worked! The master key and certificates are stored in the master database....

So if I want to restore an encrypted backup from one server to another and I already have a master key on the target server for whatever reason. Do...

Thanks for replying. So I can use a different certificate for each database I want to encrypt. What about the master key. Is that the same for...

What I don't understand is do I need to Drain the role of ServerA before I run ALTER AVAILABILITY GROUP MyAvailGroup FAILOVER?

This link explains how to restart a node...

When I built the first logshipping job it defaulted to LSAlert_SQLMon01. When I tried to build a second it did the same and dropped and rebuilt LSAlert_SQLMon01 with my...

So can I just rename the current log shipping job and add the new one. Or when I build the new log shipping job can I change the default...

Thanks for all the advice. Saving the scripts is a really good idea.

Terrie

Thanks, that is helpful. Another question. What I thought I read about the master service key is that it's not created until a database master key is created....

I'm just trying to make sure I understand. So shrink with notrucate moves the pages to the front of the file and does not release the space to the...

Thanks for all your replies. One shrinks a database to recover space. What does shrink with notruncate accomplish?

Terrie

So a shrink with no_truncate would improve performance? The company is.... Symantec.

Terrie

Gail, Thanks for you quick reply. Glad to know my gut was right, I just needed validation.

Terrie

I have a similar situation but to install SQL 2008 R2 64 bit with Reporting Services 32 bit. The link is very helpful but is for SQL 2005. ...

Multiple people are working on the different projects and switching back and forth between production and deployment. It looks like an all eggs in one basket to me.