Sorry but I'm building software for running web sites not for backup of file systems or database management. There are ample tools available for that and most web hosts provide tools for it. No tools that I could build would be better than tools already available so if your host is not able to do backups and restoring of databases correctly using tools designed for that what would make you think the CMS software can do better at solving those problems that are outside the scope of what it is designed for?
The database have stored procedures that just wouldn’t be backed up.
That is not true, SQL Server Management tools can backup and restore a database correctly and nothing about a stored procedure will cause any problem. The only problems would be if you back it up on a newer version of sql server then you can't restore it on an older one. But in that case there are tools that can do it correctly, free tools such as this, or paid tools such as the Red Gate SQL bundle. These tools can script off the tables procedures and the data so that one can run the script on a new database.
If one wants very simple backup they could use the SQL CE version of mojoPortal which is a file based database so if you backup the web site files the database is also backed up. However SQL CE is not as robust, myself I'd rather have a SQL Server database and optimize my site for performance rather than optimize it for easy backup.
To mitigate against environmental catastrophes one should copy the backups to an off site location, ie download it to your local machine so that if something major happens you still have a recent copy.