What happens if the location of the database changes after creating the automation?

If you move the database and keep the same sharing, nothing changes, and the automation keeps running.

If you move it to a different teamspace or workspace, or its sharing changes, 2sync loses access and the sync pauses.

Re-add the 2sync connection on the database in Notion, then open your automation and click Reconnect to resume. If the database was duplicated or replaced, that is a new database, so create a new automation for it.