If you are using a PostgreSQL database cluster, the chances of your database being down are rare in a production environment. If it does occur, the files added to the Alfresco folder on the desktop will be deferred.
In File Explorer/Finder, the file will show a blue icon and a notification is displayed.