> Is there a list of servers that dont work somewhere for this field?
No, it actually has to do with the server configuration.
By default, all web servers (Apache, LiteSpeed, IIS, NginX, …) forward the Host HTTP header to PHP. This is the header sent by the client trying to access your site and has your site's domain name. This is used by Joomla to determine the domain it is running on.
Some servers are configured to not forward this, in a wrong attempt to address the issue addressed by Admin Tools' Allowed Domains feature — check its documentation to understand the problem. These servers won't work without setting the $live_site. They were incredibly rare in 2001 when this feature was introduced; think about one in 100,000 or less. They are even more rare now.
> I have done a few with this method and if I recall corectly then I dont need to delete the live site folders and files
As long as you stick to the same Joomla version family (major and minor version, e.g. 4.2) and you do not remove or update any extensions: you don't need to delete anything. If you changed the Joomla version family and/or removed or updated any third party extensions you'll need to delete existing files and folders. Remember that extracting the backup can only add and overwrite files; it will not remove files by default.
> One other question comes to mind for post restoration, if it fails or I want to restore the previous live site is there a method to do that
Using Kickstart. It's documented and we also have video tutorials (Restoring on Any Site).
The whole point of an Akeeba Backup archive is that if your server burns down —as it literally happened with OVH a couple years ago!— all you need to restore your site is the Akeeba Backup archive and the free of charge Kickstart you can download from our site. Akeeba Backup was designed as a site transfer and disaster recovery tool from its very beginning in 2006, when it was called JoomlaPack.
> I assume when I do the restoration it will overwrite all the Akeeba backups that were there and replace them with only the ones from my dev site?
Backup records? Yes. Backup files? No.
Hint: you can always completely exclude the #__akeebabackup_backups and #__akeebabackup_profiles tables from the dev site's backup profile. Restoring the backup with the same database table name prefix you were already using on your live site will not delete or replace the contents of these tables which hold the backup records and backup profiles respectively. Therefore you're not losing your backup definitions and backup history upon restoration.
Nicholas K. Dionysopoulos
Lead Developer and Director
🇬🇷Greek: native 🇬🇧English: excellent 🇫🇷French: basic • 🕐 My time zone is Europe / Athens
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!