From the maintenance plan wizard you will need to create a task to cleanup your old backups using the task "maintenance cleanup task".  This will delete old backups and retain...

Looks like you have never done this before so I'll give you the easiest way.  Create a maintenance plan using the wizard for each or create on Plan with multiple...

Depends on your company needs.  I perform nightly full backups of all SQL servers since activities for SQL servers are lower during non-business hours.  Transaction log backups is dependent on...

We don't have SQL server 2019 but if you are accessing data from SQL server 2019 it should be backward compatible.  Using linked server to access data from one server...

Yes since the view track changes is at the dB level and the specific needs is that.  If you are able to give read access at the sql level then...

• This reply was modified 5 years, 7 months ago by  Brian.Tran.

OK I am clear with what you need now.  The only way that you can do this in one shot is to assigned the rights View Change Tracking permission on...

• This reply was modified 5 years, 7 months ago by  Brian.Tran.

If you grant users at the top level Security\Logins, Under User mapping, select the DB to map and grant the access as db_datareader (read only permission to the DB).  Regardless...

Thanks Sue.  I just saw an article for that.

So SQL systems on 2016 SP1 are not vulnerable to the attacks?

So SQL systems on 2016 SP1 are not vulnerable to the attacks?