Assume that you use an Always On availability group together with automatic seeding in SQL Server 2017. When you add a new database to the Always On availability group and set different default directories between the database and log, the automatic-seeding function fails.
To work around this issue, do one of the following:
- Use the same directory layout for every replica in the Always On availability group.
- Configure the log default directory to the same location as the database default directory.
- Use manual seeding.
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.