Skip to main content
Sign Out

Welcome to Dell

My Account
  • Place orders quickly and easily
  • View orders and track your shipping status
  • Enjoy members-only rewards and discounts
  • Create and access a list of your products
  • Manage your Dell EMC sites, products, and product-level contacts using Company Administration.
Sign In Create an Account Dell Financial Services Premier Sign In Partner Program Sign In
Contact Us

Your Dell.com Carts

Dell EqualLogic Host Integration Tools for Microsoft Edition Version 5.4 Release Notes

PDF

VSS Does Not Allow Backup and Restore Operations on tempdb

Each time the SQL Server is started, a clean copy of the system database tempdb is recreated. This database minimally logs operations such as temporary tables and stored procedures. This logging enables transactions to be rolled back.

The VSS does not allow backup and restore operations to work on tempdb. After the current SQL Server session disconnects, and no other connections are active at system shutdown, the temporary tables and stored procedures are automatically dropped from the database. Because no type of data is permanently stored in tempdb from one SQL Server session to another, the database does not need to be saved.

For more information about the tempdb system database, see the Microsoft Knowledge Base article at msdn.microsoft.com/en-IN/library/ms190768.aspx.

Rate this content

Accurate
Useful
Easy to understand
Was this article helpful?
0/3000 characters
  Please provide ratings (1-5 stars).
  Please provide ratings (1-5 stars).
  Please provide ratings (1-5 stars).
  Please select whether the article was helpful or not.
  Comments cannot contain these special characters: <>()\