Skip to main content
Adding Tags to improve accuraccy. Clarifying english
Source Link
LowlyDBA - John M
  • 11k
  • 11
  • 45
  • 62

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

I am configuring Log shipping from 2008R2 to 2016 using NORECOVERY option with Log Shopping jobs, I have successfully configure Backup, Copy and Restore jobs. When I have perform restore standby database standby then Database file location change on standby site. like I was create standby database on D:<FOLDER> but after open the database on 2016 using Restore -> Database. THEN change location it to C:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\DATA

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.

Source Link

Database file location change on standby site after restore standby database

I am configuring Log shipping from 2008R2 to 2016 using NORECOVERY option with Log Shopping jobs, I have successfully configure Backup, Copy and Restore jobs. When I have perform restore standby database standby then Database file location change on standby site. like I was create standby database on D:<FOLDER> but after open the database on 2016 using Restore -> Database. THEN change location it to C:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\DATA