Log shipping transferring the log files under /database/log from the primary server to the secondary server was working fine. Someday the log files permission was changed and only Administrator had the rights now, causing the process to fail to copy over to the secondary server.
As usually I will login with local account as administrator to access the system and setup the log shipping, now it fails since the log files generated only permits to Administrator ID.
Why does the permissions change suddenly to only Administrator? Previously the log files was assign to several account. Is there a way to change the settings of the file permission to reset back as per multiple user instead of only Administrator upon file creation?
Changing from advanced security do not work as the log file will generate every 1MB file size, and only Administrator having the permissions.
