I don't use Solidworks electrical myself but I have several colleague's that do.
Does anyone have any recommendation or SOP to make the archiving happen automatically, for instance once a week?
I do mean of the entire database (archive environment) not just 1 project.
ps: we don't have any PDM system nor are we planning on getting one
I don't use electrical either.
If you are looking for a tool to archive SQL database, Microsoft SQL Server Management tool can do it. And it's free.
You can download it from Microsoft Download page.
You can easily add different schedules to backup your database at different periods.