Basic

SQL Server Backup is able to back up and restore the latest Microsoft SQL Server 2012. When you configure the backup instance, please select a correct SQL server edition.

And this software is also able to restore SQL server 2005 and/or 2008 backup to SQL 2012 server, it is very easy to do that, just define a new restore job to migrant an early version database to SQL 2012 server.

Yes , SQL Server Backup supports backing up the latest Microsoft SQL Server 2008. In sql server instance configuration window , you 'll see this features :

Key words SQL Server 2008 and Express backup and restore

Tempdb database doesn't and shouldn't ever be backed up. Actually, it is recreated every time SQL Server is started.

System databases of SQL Server includes master , model , msdb , distribution.

The model database is a template, used by SQL Server when creating other databases, such as tempdb or user databases. When a database is created, the entire contents of the model database are copied to the new database.

The msdb database is used by SQL Server, SQL Server Enterprise Manager, and SQL Server Agent to store data, including scheduling information, and backup and restore history information.