Apple is only recommending Time Machine to backup a Photos Library incrementally. Time Machine can handle the internal links in the Photos Library properly and reconnect them properly, when we restore a library from a backup.
We can also make copies of the Photos Library to an external drive, as long as the external drive is compatible with Photos. It needs to be correctly formatted and must not be a network share or have backup software installed. Using an incorrectly formatted drive or accessing it over the local network can break the internal links. If the external drive is used for backups, Photos may not be able to open the libraries on the external drive because of problems with the file ownership. One big advantage of PowerPhotos is that it has been designed to understand Photos Libraries and the most recent version will also handle iCloud Photos Libraries well. It will give us a warning, if the library is incomplete and originals cannot be downloaded from iCloud.
Back up the library in Photos on Mac – Apple Support (UK)
I have been using Carbon Copy Cloner to make copies of my Photos Libraries. It has been working well, as long as I treated the destination volume strictly as a backup and never opened the libraries on this volume with Photos. Once I opened a backup on the backup drive in Photos the next CCC syncing damaged the library.
I am now using PowerPhotos to merge changes from one drive into the library on the second drive.
With PowerPhotos I can get a kind of archival backup. I want my additional copies of the Photos Libraries on the external drive to be an archive of all photos, also the ones I deleted from my main library, so I can recover older photos, if I accidentally deleted them.