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.
You need to be signed in and under a current maintenance contract to view premium knowledge articles.