I wonder if it is possible to use one shared folder(only in source database) instead of two (one in source db and another in destination db). That's Server1 will store its t-log backups there and Server2 will restore those backups from the same folder. Please see images below to understand what I mean:
Log Shipping – Is It Possible to Use One Shared Folder?
log-shippingsql serversql server 2014ssms
Related Question
- SQL Server Log Shipping – Guide for SQL Server 2012
- Sql-server – Log Shipping always fails, after a while
- SQL Server 2012 – Should Both Transaction Log Backups and Log Shipping Be Used
- SQL Server – Log Shipping Restore Job Completion in Standby Mode
- Sql-server – Adding another Secondary Log Shipping location
- “Pausing” log shipping to allow normal DB use. Is this process valid
- Sql-server – Can two SQL “Always on” nodes have different datafiles position on disk
Best Answer
Yes you can, I remember a shop where we had this kind of setup in that case even the copy job was disabled because there were no need to copy the files. You just need to be sure your file retention is ok and the Share is available at all the times. You don't want your share folder go offline during a long weekend or something and your transaction log on prod gets full.