1.Tempdb is re-created every time SQL Server is started so that the system always starts with a clean copy of the database.
2.Temporary tables and stored procedures are dropped automatically on disconnect.
So, Backup and restore operations are not allowed on tempdb
No comments:
Post a Comment