One of the most requested features for a long time has been the ability to select availability groups. Database Backup @Availability Groups = 'AG1, AG2', @Directory = 'C:\Backup', @Backup Type = 'FULL' EXECUTE dbo.
Database Backup @Availability Groups = 'ALL_AVAILABILITY_GROUPS, -AG1', @Directory = 'C:\Backup', @Backup Type = 'FULL' Now what if you want to select all user databases that are not in availability groups?
My friend Ola has done a better job on these scripts than I’ve seen anywhere else, hands down.” Sign up for the newsletter to be alerted about updates to the solution. Database Backup @Availability Groups = 'AG1', @Directory = 'C:\Backup', @Backup Type = 'FULL' EXECUTE dbo.
Ubuntu (apt), Cent OS, Fedora and Red Hat (rpm/YUM) Linux server administration and desktop systems adminstration are covered in this tutorial.
Windows Servers should be set to the correct time zone when possible.
You can use Power Shell to set the time zone, but it is overly complicated in my opinion.
This Tech Net blog outlines how to set it via Power Shell, which can be launched through Group Policy.