Just get back to this. Thanks, I will explore the third party tool.

I wonder if any DBA implement TDE on many servers of many databases. How do you maintain them?...

Thanks for the article, but I don't see anywhere in your process you deleted the transaction log.

Thanks that is good to know.

Indeed when our cyber support to ask to encrypt all the databases on all the sql servers, I feel this got to have better ways.

For...

Perry, for above statement: yes back up the DMK and store it, there aren’t many cases to restore it but always keep backups and details of the pwd used to...

Thank you Perry, sorry for the typo, corrected.

This answers my question clearly, I see some articles asked to backup DMK and save it to a safe place, not sure why...

Thanks, that is a good resource I will take a look

Hi Perry and others,

So it sounds we just create DMK on each server instead of using restore backup of DMK from another server? since you mentioned ensure the DMK are...

• This reply was modified 8 months, 1 week ago by sqlfriend.
• This reply was modified 8 months, 1 week ago by sqlfriend.

Do not perform a Tail log backup if you just need a transaction log backup !!

A tail-log backups only purpose is that you can restore the original database...

And I was a little confused about this with oracle level 1 differential incremental backup, I think that one has to depend on the most recent level 0 or  level...

• This reply was modified 10 months, 3 weeks ago by sqlfriend.
• This reply was modified 10 months, 3 weeks ago by sqlfriend.

Thank you, got it.

So the transaction log backups can be used with any full backup done earlier as long as the backup chain is not broken.

Differential backup is based on...

Found out it is Azure Arc,   it is part of our server monitoring and Microsoft defender; an agent that is installed by infrastructure team on all servers

Thanks, I know this query,

But when I run it , it returns 0.

How can I keep track of it , and what query to use to find out what caused...

• This reply was modified 11 months, 4 weeks ago by sqlfriend.
• This reply was modified 11 months, 4 weeks ago by sqlfriend.

Actually I found it is on almost all of our SQL servers, I checked service, could not find anything particular, and it is running on NT AUTHORITY\SYSTEM, could that be...

Log shipping is also database based, so 100 db, we need to create 100 jobs on primary node, then copy, restore jobs for each database, that is 2x100 jobs on...

I did not download ACE on server, instead running the sql agent job in 32 bits, then it works.

But download that is good option too.

I don't want to download sql...

• This reply was modified 1 year, 6 months ago by sqlfriend.