No tempdb Backups

The Database Health Reports don’t have any backup information for tempdb since backups are not allowed, and would not even makes sense for tempdb.

Tempdb as its name implies is temporary data that is created and recreated on the fly as queries are being run and as the system starts up.  There is nothing here to really miss if it was lost, so backups aren’t allowed in SQL Server for tempdb.


Enroll Today!
SteveStedman5
SteveStedman5
Steve and the team at Stedman Solutions are here for all your SQL Server needs.
Contact us today for your free 30 minute consultation..
We are ready to help!

Leave a Reply

Your email address will not be published. Required fields are marked *

*

To prove you are not a robot: *