Log Shipping back up location to a network share instead of clustered file share

Posted on

Question :

Below is my current cluster set up

  • Node 1 – Active
  • Node 2 – Passive

While doing Log SHipping can I save the back ups to a network share instead of a clustered file share?

The service account will have read/write permission on the network share.

Answer :

Log shipping backups aren’t anything special under the hood, they run an executable (sqllogship.exe) that fires off a standard BACKUP LOG. They can be configured to point anywhere the service account has write access to (and since this is a FCI, anywhere that is reachable from both nodes).

What’s the point of writing these to a network share? Reduce the shared storage requirements (presuming there’s no direct attached storage you can easily use)?

Leave a Reply

Your email address will not be published. Required fields are marked *