Msg 3147, Level 16, State 3, Line 1
Backup and restore operations are not allowed on database tempdb.
This error message appears when you try to backup or restore the tempdb database.
The T-SQL statement can be parsed, but causes the error at runtime.
Errors of the Severity Level 16 are generated by the user and can be fixed by the SQL Server user. The statement cannot be executed this way. You cannot backup or restore the tempdb database.
All versions of SQL Server.
BACKUP DATABASE tempdb TO DISK = ‘D:tempdb.bak’;
In the above example we try to backup the tempdb database. This raises the error.