.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

Spliting Content DB - mergecontentdbs Vs Admin tool kit

Posted By:      Posted Date: October 26, 2010    Points: 0   Category :SharePoint

Hi All,

Which of the above two spliting content db process is safe and easy to achieve?

What are the draw back of using either?


View Complete Post

More Related Resource Links

One for the Experts! Is it supported to use stsadm -o mergecontentdbs with mysite/ssp admin content




I've inherited rather a mess, the situation is as follows:

1 web application named home.company.com

containing 2 databases:

db_1 - contains:

  • Intranet site collection - http://home.company.com/
  • Used for mysites - http://home.company.com/personal/*
db_2 - contains
  • equal number of mysites to db_1 (about 2500 in each)
  • /MySite - my site host site collection?
  • /SSP/Admin - SSP admin website site collection?

I propose to do the following:

Rename home.company.com web app to ssp.company.com, including hostheader/DNS etc

create fresh home.company.com web app

Move pre-existing home.company.com/ site collection to new web app/database with stsadm -o mergecontentdbs specifiying the one site collection in a file.

merge the remaining 2 contentdbs ENTIRELY in the ssp.company.com web application

The bit I'm not sure about is the last sentence - is it supported to merge these contentdbs as they contain mysites and ssp admin site.

THe ssp admin database itself used for storing the ssp configuration info is obviously a seperate DB.

Why do I want to sort all this out?? Because I need to upgrade the profiles/My Sites to 2010, and to do this I need to attach the relevant databases! As well as th

Web Site Admin Tool - cannot establish connection



I have a question with this tool.  I have a database listed in the App_folder, and the database has a connection in Server explorer.  The connection string is listed in the web.config file, and I am able to add users and roles with the Web Admin Tool.  However, when in the Web Admin Tool, under Configuration tab, I receive an error when I click on the "test" button.  The error reads

 " Could not establish a connection to the database.
If you have not yet created the SQL Server database, exit the Web Site Administration tool, use the aspnet_regsql command-line utility to create and configure the database, and then return to this tool to set the provider."

How can this be, and how do I correct this?



Error deleting sites from Content and Structure Tool


I get the following error when trying to delete a site and its subsites from the Site Content and Structure tool:

 Site Content and Structure: Delete 2 26/10/2010 4:37 PM Operation to Delete '/Site/Subsite' failed     <error><message>The attempted operation is prohibited because it exceeds the list view threshold enforced by the administrator. </message><full>Microsoft.SharePoint.SPQueryThrottledException: The attempted operation is prohibited because it exceeds the list view threshold enforced by the administrator. ---&gt; System.Runtime.InteropServices.COMException (0x80070024): &lt;nativehr&gt;0x80070024&lt;/nativehr&gt;&lt;nativestack&gt;&lt;/nativestack&gt;The attempted operation is prohibited because it exceeds the list view threshold enforced by the administrator. at Microsoft.SharePoint.Library.SPRequestInternalClass.DeleteWeb(String bstrUrl) at Microsoft.SharePoint.Library.SPRequest.DeleteWeb(String bstrUrl) --- End of inner exception stack trace --- at Microsoft.SharePoint.SPGlobal.HandleThrottleException(COMException comEx) at Microsoft.SharePoint.Library.SPRequest.DeleteWeb(String bstrUrl) at Microsoft.SharePoint.Publishing.Internal.WebControls.DeleteRecursive.DeleteOp(ObjectSerializer objser) at Microsoft.SharePoint.Publishing.Internal.WebControls.S

Need help creating an admin tool to reset password without question/answer



I'm dealing with a scenario where a legitimate user doesn't have a clue about his password, secret question or the answer. So, I was trying to create an admin tool that would help me in situations like these where the admin should be able to type in username and reset the password without having to know/enter answer to secret question. I understand that I need to make some changes to the web.config for this to work. I thought I made all the changes but my ResetPassword() requests are still not working.

Here's my web.config settings for the provider.

<membership defaultProvider="AspNetMembershipProvider">
      <add connectionStringName="MyConnectionString" 

Web Site Admin Tool problem in VS2005


When I create a new project and try to use the WSAT security tab, I get the following :

There is a problem with your selected data store. This can be caused by an invalid server name or credentials, or by insufficient permission. It can also be caused by the role manager feature not being enabled. Click the button below to be redirected to a page where you can choose a new data store.

The following message may help in diagnosing the problem: Unable to connect to SQL Server database.

I am using VS2005 beta2 with a local copy of SQL Server Express.

I am new to all of this so a little help would be great


Site Admin Can't Delete Content In Document Library



I am the admin of a site and need to delete a version of a document someone else uploaded into a document library. In other libraries, when I hover over the document, I get the drop-down which contains the "Edit Item, Open In... and Delete". In the particular library, I don't get that menu. Any ideas why?


3rd Party Content Deployment Tool?


We're using SP Foundation 2010, SQLExpress, single server installation. We're looking to perform Content Deployments from a staging site to a production site, both hosted on the same server. Content Deployment does not seem to be a feature of Foundation's CA.

Any recommended 3rd Party Deployment tools? Any workarounds?


SharePoint Tutorial - Content Types

SharePoint content types provide users with a way to manage and organize content in a more meaningful way. It's a reusable of settings you want to apply to a particular type of document in a library or item in a list.

Visual Case Tool - UML Tutorial

The Class Diagram

The class diagram is core to object-oriented design. It describes the types of objects in the system and the static relationships between them.

Enabling Users to Maintain SharePoint Content

When SharePoint is installed as a corporate intranet, there is a considerable amount of effort involved in maintaining the content to keep the site relevant. As we discussed in the first few parts of this series, SharePoint has many built-in features to reduce the burden on the site administrator.

Some areas of the site usually contain less-dynamic information. Internal memos and corporate policies are common examples of this information. One option for this information is to post these documents in a document library. Documents in a library are often stored in a few different formats: Word, Acrobat (PDF), or HTML. Each of these formats has its drawbacks.

Application Vs. Content Pages in SharePoint

SharePoint has two types of ASPX pages. One type is the application page, also known as a _layout page. The other type of ASPX page is a content page, also known as a site page. Each of these page types is stored in a different location in SharePoint. When developers create custom ASPX pages, they must decide on the page type.

Enabling Users to Maintain SharePoint Content

When SharePoint is installed as a corporate intranet, there is a considerable amount of effort involved in maintaining the content to keep the site relevant. As we discussed in the first few parts of this series, SharePoint has many built-in features to reduce the burden on the site administrator.

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.

Content Query Web Part missing in SharePoint 2010

If you don't see content query web part listed in the web parts list, this is because you have not enabled "Search Server Web Parts" feature in site collection features. Enable this feature and content query web part will show in the list of web parts.

WPF Geometry Transformation Tool

The geometry transformer is a simple tool I wrote to scale-, translate- and rotate-transform a geometry in the path mini language.

Unique content within master page based on conditions met


 Hi all-

I would like to present users with unique content based on certain conditions being met as they land on the home page (default.aspx).  The condition logic will be in the VB code behind Page Load event. The content will go in a content placeholder as specificed from the master page. 

However, the content change wouldn't be something small (ie making a panel or label visible or not) but rather it will be different HTML,  Divs and databound gridview content.  The HTML content will be stored in the database.

Can someone point me in the right direction for best practices on how to accomplish this?


Passing Linq Statement between master and content page


I usually work with windows forms, and am just starting to work with ASP.Net, so appologies if this is a dumb question!

I have a master page which has a search button on it. The results of this are built up using a Linq statement and if there are any results, I want to display the results in a contents page.

On the masterpage, I have the following code:

Private _res

    Public Overridable ReadOnly Property SearchRes()
            Return _res
        End Get
    End Property

 Private Sub DoSearch()
   'some code to get a linq result

    If res.Any Then
            _res = res
            Server.Transfer("SearchResults.aspx", True)
            'no results
            LabelNoRes.Visible = True
        End If
 End Sub

On the SearchResults.aspx page I have this code.

Dim m As pxSite = CType(Page.Master, MasterPage)
        If m.SearchRes IsNot Nothing Then
            Label1.Text = "Results found = " & m.SearchRes.Count
        End If

m.searchRes is always nothing. 

What am I doing wrong here?


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