Sharepoint 2010 Training培.ppt

* Objective: Discuss the types of databases that comprise a SharePoint implementation. Delivery Tips: Optionally, demonstrate the points on this slide by opening SQL Server Management Studio with the Run as another user option, specifying the user name CONTOSO\Administrator and the password, Pa$$w0rd. Point out the databases. Optionally, click the Content database link for a detail slide about content database tables. Course 10174B Module 2: Creating a SharePoint 2010 Intranet DO NOT PRINT Objective: Provide some insight into the content database. Delivery Tips: Optionally, demonstrate the points on this slide by opening SQL Server Management Studio with the Run as another user option, specifying the user name CONTOSO\Administrator and the password, Pa$$w0rd. Expand Databases, then expand WSS_Content_Intranet_IT. Point out the tables. Right-click dbo.AllUserData, and then click Select Top 1000 Rows. Scroll over to the nvarchar1 column, then scroll down to find the content of the default announcement on a team site: Get Started with SharePoint Foundation! FYI: A complete list of content database tables, from course co-author Chris Givens: AllDocs = All the item level data for folders and files AllDocStreams = the actual file itself (if unghosted) AllDocVersions = if versioning is turned on, versions of the file goes here AllLinks = table with links across the SharePoint site, helpful if you wanted to update links to files that have moved! AllLists = information about the lists for each site AllUserData = information about items in lists (basically list data) AllUserDataJunctions AuditData = information about all the events going on in the webs BuildDependencies Categories = associations among documents and there assigned areas CollationNames ComMd = document discussions ContentTypes = the content types that have been created on each site collection ContentTypeUsage = where global content types are used across the site collections Deps = document dependencies Disk