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.
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.Sign up to join this community
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)?