I am configuring Log shipping from SQL Server 2008R2 to 2016 using
NORECOVERY option with Log Shopping jobs. I have successfully configured Backup, Copy and Restore jobs.
When I perform a restore on the standby database, then its Database file location changes on standby site.
I was creating a standby database at
D:\<FOLDER>, but after restoring the database on 2016 using Restore -> Database, the location changed to
C:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\DATA.