HiveBrain v1.2.0
Get Started
← Back to all entries
patternsqlMinor

Is it possible to use just one shared folder for log shipping?

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
sharedlogjustpossibleonefolderforshippinguse

Problem

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:

Solution

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.

Context

StackExchange Database Administrators Q#240633, answer score: 6

Revisions (0)

No revisions yet.