Data Storage

Data Storage

Data stored in the Sitecore Master Database

  • All versions of all content items
  • All versions of all definition items and metadata
  • All versions of all media items (most media items are unversioned)

Data stored in the Sitecore Web Database

  • The highest numbered publishable version of published content items
  • The highest numbered publishable version of published definition items and metadata
  • All published media items that are unversioned
  • The highest numbered publishable version of published media items that are versioned

Data stored in the Sitecore Core Database

  • All users, roles and profiles in the ASP.NET membership schema
  • All previously deleted items now in the Recycle Bin
  • All previously archived items now in the Archive
  • Configuration settings for the Sitecore UI
  • Configuration settings for the Rich Text Editor toolbars

SQL Authentication Modes supported by Sitecore

  • Mixed Mode
  • Windows Authentication Mode
  • (SQL Mode is not supported)