Thanks Lowell.

When you say:
So if I clone VMOriginal as VMNew, when i connect to it and select @@servername, it will return the wrong name...'VMNEW'
Do you mean...

Thank you, the job history for those failed job had already deleted.

What I found is:
Yesterday, I disabled the schedule ( plus previously disabled job), then solarwinds no longer...

Thanks, I know either of job or schedule is disabled, the job will not run.

The reason I asked is we have solarwinds monitoring the server, the job ran...

Thanks got it. It is Ok for legitimate user to import data.

Also I just tried to restore the encrypted database on another SQL 2016 SP1 standard edition, and...

Also since I am experiment TDE, I would like to remove it  totally after I experiment.

I think the process is :

1. disable encryption on the encrypted...

Thanks everyone.
One more question related this,  I know the TDE purpose is to protect the data of rest. that is encrypt the mdf, ldf, and backup file so that...

I also found this restriction is a little hard to deal with:
The target cannot have a FOREIGN KEY constraint, or be referenced by a FOREIGN KEY constraint.

That is good to know, thank you!

Currently it returns 0. Possibly nobody is using the site.
I believe there is no way to find out the connections at a particular past time.

THanks

Thank you all.
Does TDE more widely used on Datawarehouse databases than OLTP databases?

Thank you, that answers my question

I did an experiment, -- restore a copy of backup from production to test server, then do a log backup for the test server database, then restore again from the database...

I say test server, in our case it is both dev/test server, I make it full recovery mode, in case we need to do a point of time restore.

I am using full backup recovery model on both test and production server.

What does  'A log backup required that a full backup has been taken.' mean?

What...

For example I restore a database on a test server from a full backup of production server.