I am configuring Log shipping from SQL Server 2008R2 to 2016 using NORECOVERYNORECOVERY
option with Log Shopping jobs,. I have successfully configureconfigured Backup, Copy and Restore jobs.
When
When I have perform a restore on the standby database standby, then its Database file location changechanges on standby site. like
I was createcreating a standby database on D:<FOLDER>at D:\<FOLDER>
, but after openrestoring the database on 2016 using Restore -> Database. THEN change, the location itchanged to
C:\Program Files\Microsoft SQL Server\MSSQL13C:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\DATA
.MSSQLSERVER\MSSQL\DATA