User, group, or role already exists in the current database

You moved the database to another instance and created a new login for this database instead of moving the login from the old instance to the new instance. I recommend that you read my article “How To Move Logins To Another Instance(sp_help_revlogin)”. You may receive this error when you want to authorize the login that you created for the database… Leer más »

 rsync runs by using a lock file crontab

You can ensure that only one instance of that rsync runs by using a lock file. util-linux includes a file locking wrapper called flock, which you can use in your crontab like so: