Forum Discussion
SQL logshipping
Hi Everyone, has any experience an issue whereby you setup log shopping from SQL 2014 to SQL 2022 , when you choose the paths for data and logs to be stored on destination server it defaults to s...
By default, SQL Server:
- Uses the file paths embedded in the backup
- or falls back to instance default data/log paths
You can check following:
- Select serverproperty('InstanceDefaultDataPath'),serverproperty('InstanceDefaultLogPath')
If Both point to same drive then both files land there.
2. Missing MOVE caluses during restore
Use Move clause during initial restore.
You can try following fix:
- Take FULL backup on primary
- ON Secondary, run restore statement with MOVE clause
- Configure log shipping without initialization
Tip(Based on experience): Always initialize secondary database manually.