Basic

Microsoft SQL Server 2012 backup and restore supports

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.

microsoft sql server 2012 backup and restore supports

What are system databases in Microsoft SQL Server?

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.