.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

Powerhsell script for MOSS 2007 to get content database size

Posted By:      Posted Date: September 20, 2010    Points: 0   Category :SharePoint


Can you please provide me a script to get content database size in MOSS 2007.




View Complete Post

More Related Resource Links

Content Types in MOSS 2007

In this article I will try to describe the one of the best feature in Microsoft office Share Point 2007 called Content Types.

Content types are simply collection of contents.Each content in a Content type can have different settings.Basically it is a reusable collection of settings which you want to apply to a particular category of contents.

MOSS Content Database has more documents than what's seen on browser

I am not sure how sharepoint internally handles stuff, but this is what I see. I am a SQLDBA and one of my company sharepoint group re-organized a site, by moving some files from a document library to another document library. I think she used the content deployment.

When she see the number of documents in the document library it showed 700 documents. She moved only 50 of them. I went into the database and queried the Docs and DocStreams View and I get the list of all the those documents. I see both the ones that we see on the site as well as something that we do not see on the site.


ad.DirName, ad.LeafName, TimeCreated, ads.size/1024 as [Size(KB)], SetupPath

FROM Docs ad, DocStr

Ugrading Moss 2007 Content DB

Hi I have been trying to upgrade my Moss 2007 Content DB with no luck. I first test the content db with the powershell cmdlet Test-SPContentDataBase and I get the following error Category        : MissingWebPart Error           : True UpgradeBlocking : False Message         : WebPart class [1289ecb0-3c27-8b8b-1059-d2cf4d1a3993] is refer                   enced [2] times in the database [WSS_Content], but is not ins                   talled on the current farm. Please install any feature/soluti                   on which contains this web part. Remedy          : One or more web parts are referenced in the database [WSS_Con                   tent], but are not installed on the current farm. Please inst                   all any feature or solution which contains these web parts. In the past we ha

Update Title on Content Page(MOSS 2007)

I have multipal websites. I would like to update "Title" field in the content pages. How Can I do it using wsp/c#. For example.. I have site like http://www.something.com/pages/home.aspx . I this page I have "Title" field with value like "Something" now I want to change that to "Something else". Please help.    

MOSS 2007 Content Deployment Error

I have trouble with a staging environment that I recently set up.  I went through the error logs and finally got the staging environment functioning without errors, but previous to working through those errors, we successfully made a content deployment path and job and ran it.  Now, the Destination central Admin is giving permissions issues.  I changed and restarted some services and some component services..  Are there any specific things I should check related specifically to content deployment as far as services on the server? 



Either the URL for the destination Web application is not valid, or you do not have permissions to the Central Administration site on the destination server farm.

Error details: The remote Web service request failed with this message : 'Exception has been thrown by the target of an invocation.'.

Content Deployment in MOSS 2007


I am trying to Deploy the content from one site collection to another site collection in a different server.

My question here what kind of similarity has to be exists with both servers.

I have some custom webparts installed in one server and it is also used in the site collection do i have to install all those custom server in the destination server too. or while content deploying it does it automatically.

Failed upgrade from wss 3.0 to moss 2007. Cannot open database "ProjectServer-live_Published" reques


While trying to upgrade from WSS 3.0 to MOSS 2007 the process finished, but it stated that it completed with errors. Those errors seem to be causing problems within the Central Administration site. I will try outline the errors the best I can from the upgrade.log file and with the actions I've been attempting. THANK YOU in advance for any and all assistance.

[SharedResourceProviderSequence] [ERROR] [9/23/2010 11:15:03 AM]: Unable to locate SearchDatabase for the SharedResourceProvider Hyperion_SSP
[SharedResourceProviderSequence] [ERROR] [9/23/2010 11:15:03 AM]: Exception thrown was: System.ArgumentNullException: Value cannot be null.
Parameter name: No search database is associated with the search shared application, Hyperion_SSP
   at Microsoft.Office.Server.Search.Upgrade.SharedResourceProviderSequence.get_SearchDatabase()
   at Microsoft.Office.Server.Search.Upgrade.SharedResourceProviderSequence.AddNextLevelObjects()
[SharedResourceProviderSequence] [INFO] [9/23/2010 11:15:03 AM]: Re-run upgrade using stsadm -o upgrade to ensure the search database gets upgraded appropriately
[SharedResourceProviderSequence] [DEBUG] [9/23/2010 11:15:03 AM]: No search database was found, so skip upgrading it

As advised in the info section for this error I re-ran the upgrade

Move Single MOSS Content Database to Different SQL Server

We want to mmove the single database of MOSS on Network Test and Development to the Production SQL Server. But MOSS aplication server remains same!

So in this condition it points out for the two database servers at the same time.

Is it possible? Or I need to migrate the all concern databases to the another SQL Server?

Pls HelP!

Crawling does not happing on a content database from set of DBs of my Web Application (MOSS)


Hi Team,

This is regarding indexing in MOSS content sources. I have an MOSS application(web site) configured as Content source for crawling. A user reported that his is not able to search on the content uploaded to his site. After performing quite a few checks and investigatations. We found below info in crawl log, we suspect that this is  crawling of all sites in Content Database(i.e., non are crawled and searchable). Atleast that is what we understand by trying search of quite a few sites residing in the databse.

Exception from HRESULT: 0x81070504 (There is no Web named "/sites/020045t".)

Also we find the site only in SiteMap table in SharePoint config Database only. We tried deletesite command with -force and -siteid switch, both were unsuccessful. Can someone tell us how to remove this orphan site/ entry in sitemap table? We are hesitent to delete the row in sitemap table since we do not impact of doing it from backend.

Thank you,


Content Migration - DotNetNuke to MOSS 2007

Any Automation tool to migrate DotNetNuke site to MOSS 2007. The portal predominantly has content pages, document and photo library and few landing pages. Appreciate pointers for migration. ( 1000+ pages)

If custom soln to be built, how easy to read from DNN?

Reset all crawled content (MOSS 2007)


I Used the Reset all crawled content, but it broke my SSP (Search and UserProfile) in the Search i get:

Crawl status:

The search application for 'SharedServices1' on server MOSSSERVER is not provisioned. Confirm that the Windows SharePoint Services Timer service and Windows SharePoint Services Administration service are running on the server.

How can i get it to work again ?


MOSS 2007 Strange Problem with edit forms, content types and document library columns


I'm having a strange problem and have not been able to track down any useful answers over google.

I inherited a SharePoint site that I am now making some changes to.

I am having problems with one document library.  We had custom edit forms on this document library, which I was finding a pain to maintain so I reset them back to the site definition.  This edit form now shows only those fields that are associated with the Document content type (the only content type - I've deleted the others) on the document library.  There are other columns on this document library that are NOT associated with the content type that I would like to show on the edit form but they are not available when I try to add them to the content type via Settings > Document Content Type > Add from existing site or list columns.  The select columns from drop down is set to List Columns.  The Additional Authors column is just not there.

I CAN see this field on the all items view for the document library, it is there and populated with data.

Setting the Allow Managed content types radio button to NO does not have any impact on which fields are visible on the form- I still see those same fields that have been associated with the Document content type.

Has anyone else seen this or does anyone have any thoughts?? 

They will be muc

Easy way to migrate site columns and content types from moss 2007 to sharepoint 2010?

Easy way to migrate site columns and content types from moss 2007 to sharepoint 2010?

MOSS 2007 Content Deployment Issue Could not find Feature UsageReportingTemplateList



I am trying to deploy a site collection from our development enviroment into our live enviroment all our other sites site collections deploy fne apart from this one which we dont seem to have chnaged anything.

The deployment job is failing due to the below error

Could not find Feature UsageReportingTemplateList


Please help

Migrating MOSS 2007 installation from one database server to another - configuration database issue


The database server which our sharepoint installation is currently using is going to be shutdown and a new one is going to be put in production.

I read in some post that the configuration database cannot be moved (while the same operation type is documented for content database). Is this correct?

Isn't there a way by which I can modify my current moss installation to define the use of another sql server for configuration (and then later for content) databases?

Any other workaround or procedure?

Thank you!


Error upgrading MOSS 2007 SSP database/user profiles to 2010


I am trying to use the new-spprofileserviceapplication powershell script to do a db attach/upgrade of my 2007 SSP to upgrade the user profiles.

New-SPProfileServiceApplication -applicationpool User_profile_service_app_pool -Name "User Profile Application" -Profiledbname prodsspconfig2 -Profiledbserver dbname\int

It gets a certain way and then errors out with the following error:

[powershell] [ProfileDatabaseSequence] [ERROR] [10/22/2010 12:13:56 PM]: Action of Microsoft.Office.Server.Upgrade.ProfileDatabaseSequence failed.
[powershell] [ProfileDatabaseSequence] [INFO] [10/22/2010 12:13:56 PM]: ProfileDatabase Name=prodsspconfig2
[powershell] [ProfileDatabaseSequence] [ERROR] [10/22/2010 12:13:56 PM]: Exception: The INSERT statement conflicted with the FOREIGN KEY constraint "FK_ProfileTypePropertyAttributes_PropertyList". The conflict occurred in database "ProdSSPConfig2", table "dbo.PropertyList".
The statement has been terminated.
[powershell] [ProfileDatabaseSequence] [INFO] [10/22/2010 12:13:56 PM]: ProfileDatabase Name=prodsspconfig2
[powershell] [ProfileDatabaseSequence] [ERROR] [10/22/2010 12:13:56 PM]:    at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowE

MOSS 2007 - lowering maximum upload size


Hi everyone,

I’m about to lower the maximum upload size for one of my web application. I know there are few files already bigger than the new size I’m going to set. My sense is telling me the new lower size won’t affect the files already uploaded – but I thought I would ask in case anyone experienced anything unexpected?

Say my previous max upload size was 50 mb and now I’m going to set that to 25 mb and I already have files bigger than 25 mb sitting on my database. Do you see any problem with the new size would cause to the exiting files bigger than 25mb?

My environment is MOSS 2007 with SP2 applied and SQL server 2005 with SP3. All running on Windows 2003 Server with SP2.

Thank you in advance for sharing your experience!

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend