How to backup tempdb? Tempdb does not display in Maintenance Plan create GUI
Whether backup is run via command line or script in Query Analyzer, the result is the same for native or LiteSpeed:
BACKUP DATABASE is terminating abnormally.
Backup and restore operations are not allowed on database tempdb.
The backup and restore operations cannot be performed on the tempdb database - this is a Microsoft restriction of SQL Server
WORKAROUND:
None.
This is a restriction of Microsoft SQL Server. Backup and restore operations are not allowed on database tempdb. For additional info, see: http://msdn2.microsoft.com/en-us/library/ms190768.aspx
Also see Solution 19248 https://support.quest.com/SUPPORT/index?page=solution&id=SOL19248
