Select from following answers:- tempdb is re-created every time SQL Server is started
- Backup and restore operations are allowed on tempdb
- Operations within tempdb are minimally logged
- Temporary tables and stored procedures are dropped automatically on disconnect
- All Above
BACkup & Restore operations are not allowed for tempDB because tempdb is recreated when the SQL Server started...
so there is no need of taking backup & restore it again
Show Correct Answer
Asked In: Many Interviews |
Alert Moderator