1. Set up a Staging environment to restore the PROD backup;

2. Develop a scrubbing procedure to erase those sensitive data/columns with some random data on the Staging DB

3. Backup the...

Is the Clustername pingable? if it is, try this? Go to Server Property-->Connections

...

My Active/Passive Cluster SP3 installation was smooth and successful.

1. Connect to Active node, Install SP3 on Active node (with everything running, no failover, no shutdown)

2. when finished on Active...

Sometimes, when I deploy report or try to connect to the reporting server, it failed to connect it.

Then it caused the database connection failed too. then sometimes caused the...

Connect SSIS (default instance) from the Object Explorer and click Filesystem and import the package from the Filesystem (your path).

Then run it from there and see how it goes.

If this...

If the job was created from maintenance plan, you should be able to drop the job by dropping the maintenance plan which created that job.

When you set up the Subscription, it would ask you to provide the UserName and Password to access the fileshare.

You only need to make sure the fileshare folder is really...

ROBOCOPY is not the sole cause in my case, but it's a major one. I have a job copying backup files over to another server using robocopy. Many times,...

It should if restarting SQL services is all that it needs to get working.

BTW, I am having same errors as you were trying to fix. but our SQL is Standard...

failover from Active to passive will restart the services on the passive node;

failback from THEN_passive_Now_Active to Then_active_now_passive node will restart the services on the Then_active_now_passive node.

Did you see any blocking?

How about the Exec Plan?

SELECT Count(*) FROM sys.COLUMNS

Where object_name([object_id]) = 'TABLENAME'; --without DBO

Is the Created/modified date of the TUF file same as or close to your last LOG file? ( the TUF file should be in your logcopy folder by default)

If...

Is the Profile set as Public and Default?

If nothing helps, Restart the server/services, which probably will help.

Sometime the security/permissions won't take effect until after a restart.