Hello, all: We have WSS2.0 serving our intranet team sites. it as one unique Content DB which is already over 500g under almost only one site collection ! - Other several site collections have quite small data size. Now, we would like to clean and re-structure our SharePoint sites: 1. Create (SQL?) scripts to analyze existing content, and delete unnecessary sites/data. how can I fulfill this request? - Find empty sites and their administrators - List all sites with their administrators and possibly latest content modification date for later use. 2. Split database we would like to split current unique Content DB into several small ones while the site URLs are not altered! "pick up sites from this huge site collection and migrate to the new small DBs". However, WSS2.0 official tool only supports to migrate sites from DB to DB on site collection level as I investigated. We have about 450G site data in one unique site collection at moment, that we do need to split it... Is there a tool avai that can help on this case? for instance, http://spsitemanager.codeplex.com/ ?? I do appreciate any comments on this headache! Best regards, MyST from Finland :D

1. Create (SQL?) scripts to analyze existing content, and delete unnecessary sites/data. Ans: there is a feature in SPS 2003, unused websites use that, also you can write queries to fetch last modified date of a document library and delete using the date. 2. Find empty sites and their administrators Ans: we used object model webpart for this 3.List all sites with their administrators and possibly latest content modification date for later use. Ans: we used object model programming to display all the sites/sub sites and their Admins but we can also use SQL query to get the results. for sites info go to AllUserData table and for Admins go to UserInfo table

1. Create (SQL?) scripts to analyze existing content, and delete unnecessary sites/data. Ans: there is a feature in SPS 2003, unused websites use that, also you can write queries to fetch last modified date of a document library and delete using the date. ---- Do you mean this feature only exists in SharePoint Server 2003, not in Windows SharePoint Service 2.0? 2. Find empty sites and their administrators Ans: we used object model webpart for this ----- I guess this is a customized webpart you are referring here rather than a default one. Am I correct? Hi, SridHarS: Thanks for your answer, I added my comments above. Thank you and best regards, MyST from Finland :D

hi, 1.ya the un used websites feature is there in SPS 2003 only not in WSS 2.0. 2. yes its a customized webpart only by Out of the box we dont have in SPS 2003. but you can query from content DB for last modified web and its admins.