SQL Server Backup Topics

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.

SQL Server Backup is a professional backup and restore utility for Microsoft SQL Server 7.0 ,2000 , 2005,2012 , MSDE , WMSDE , SQL Server 2005 Express. It's a user-friendly wizard and rich features make it perfect for both beginner and expert SQL Server administrators. This program runs on Windows NT/2000/XP/2003/2008/win7/win8.

• Windows 2003/XP,2008, Vista , Win7, IE4.0 or later for Backup Manager.
• Windows 2003/XP,2008, Vista , Win7, IE4.0 or later for Backup Agent and Storage Server.
• 500 MHz or higher CPU .
• 64 Mb or More RAM.
• 50 Mb at lease free hard disk spaces.

Yes. Microsoft SQL Server provides standard interfaces to third-party software vendors to perform backups and restores. SQL Server Backup uses exactly the same interfaces.