You need to enable TDE on the subscriber if you want it encrypted. Enabling it on the publisher does not affect the subscriber.

Sue

It's in the documentation. One example in this link:

Frequently Asked Questions for Replication Administrators

How do I manage constraints on published tables?

There are a number of issues to consider regarding...

No. There is a parameter to disable then on the target instance using -DisableOnDestination but the entire job is copied.

Sue

You shouldn't need to kludge anything on a clean install. The first thing to check would be the logs from the installation - default location is C:\Program Files\Microsoft SQL Server\nnn\Setup...

The answer is pretty clear (and correct) when I read it:

Explanation

This is similar to another question (https://www.sqlservercentral.com/questions/get-the-datetime), but this time an error is returned. Addition is not allowed with the...

What would be the best way to achieve this considering the data being replicated is missing unique row ids and preferrably we would not wish the source tables to...

Could be the underscore in the directory name - Try enclosing the paths in double quotes.

Sue

Yes. There are additional ports you may need to open depending on what features are being used (service broker, debugger, url access, etc). The follow documentation is a good reference...

It's hard to tell which piece is missing - the configuration, connecting to listener, etc. This blog has a walk through on how this connection works - try going through...

Doesn't matter as a report still needs a datasource or it needs to be embedded in the report. I would check the reporting services log and see if there is...

Make sure you have uploaded the datasource for the report before uploading the report. If you are using a shared datasource that already exists, make sure it's referenced correctly in...

Create a role with the necessary permissions and add their logins to that role. Roles and groups are usually the easiest way to minimize overhead of maintaining user, permissions. Keep...

[SQLSTATE 01000] is normal to see with print statements executed through SQL Agent. You can ignore them.

Sue

Totally agree with Chris. Another set of scripts that are great for assessments would be Glenn Berry's diagnostic scripts. You can find the current scripts for your versions of SQL...

Yes. The difference is really why you want to change the nodes. Move and suspend are used for different things. If you need to failover, you use move. Drain was...