I have two Windows Servers with same SQL Server 2017 software and data model setups. The two databases have the same kind of file group structure too.
The goal is to be able to drop oldest quarter partitions on OLDB from source server and move them to target server on ARDB at the beginning of every new quarter.
Is there any chance to detach .ndf
from OLDB and attach to ARDB.?