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 1 week, 3 days ago by  sqlfriend.
• This reply was modified 1 week, 3 days 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 1 month, 2 weeks ago by  sqlfriend.
• This reply was modified 1 month, 2 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 7 months, 3 weeks ago by  sqlfriend.

Thank you that is good to know about the Azure featured packs.

For my question particular I am interested how the drivers are installed, I think I figured it out, for...

Any other options if want to for example to synchronize the database every 1 hour. The reason we do this is because we have another database in oracle end, they...

• This reply was modified 8 months, 2 weeks ago by  sqlfriend.

Thank you!

Thanks so much, I will give it a try.

May come up with more questions

Hi Thank you, Brian.

We do have version control for reports.

This backup is on our test server, the project is to convert projects from our existing build software to free version...

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

Hello, thanks all.

I was suspect VS 2019 or files it used got changed somehow, because it was working before, a few months ago.

We have office 365 keep updated in our...

Thanks Jo, that worked!