Attach existing Content Database to new SharePoint Site Collection

This blog will describe about how to attach , detach a content database.
Below is the scenario -

You created a new Site collection in SharePoint 2010.
Now you want this site collection to work with your existing Content database.

Simply you can be asked that you have existing content database and you need to attach it with new Site collection.




Solution:
So you have created a new Site collection and want to attach existing content Database.
Lets start this process.
First you need to Remove Existing Content database which is associated with your new site collection.

To do this, go to Central Admin

Application Management , under databases you will find Manage content Databases. click on that link.

Select your web application, your content database will be shown. click on Content Database. On new page you need to select a checkbox "Remove content database" and click on OK.


So you have successfully removed Content Database from new Site collection.

Next step is to attach existing content database to your new site collection.

There could be 2 scenario.


1. ) Your existing Content Database is associated with one site collection - In this case you need to run below command to detach this content database.

Dismount-SPContentDatabase "WSS_Content_Old"

You will be asked to confirm this, please type Y and hit enter. Then you may run Mount command.

2.) Your existing Content Database is not associated with any site collection - In this case no problem, no need to Dismount it directly you can run Mount command.

Mount-SPContentDatabase  "WSS_Content_Old" -DatabaseServer "DBServerName" -WebApplication "http://siteurl" -AssignNewDatabaseId

Here is output for this -

Id               : 2617bb2a-b21a-4f77-bcc4-539a987a9639
Name             : WSS_Content_Old
WebApplication   : SPWebApplication Name=SharePoint - 1000
Server           : servername
CurrentSiteCount : 1


Now you may restore a bak file to this site, if required. Also, you may deploy your WSP solution, if required.

So you are done with Attaching existing content database with new Site collection.



Protected by Copyscape

Comments

  1. Nice blog for upgrading content database.
    It helped me alot in my current task.
    Appreciated.

    ReplyDelete

Post a Comment

Popular posts from this blog

CAML Query in SharePoint 2010

In this blog I will explain  - What is CAML Query? and How to use CAML Query in real time development in SharePoint 2010?
CAML stands for Collaborative Application Markup Language. CAML query generally used on SharePoint objects like List, Library, List Template, Content Type etc. The most important topic to discuss in SharePoint 2010 environment is CAML Query.

Read more

Calling REST APi from server side code - C#

Hi,

I was working on a project where i got a web api url with parameters, i was asked to consume this api and get response from there.

I got below details:

Api urlparametersand response code eg 200 for ok, 404 for not found etc.
Here is the code which will consume the web api and will get response from there.
This is 100% working code.

public class Program
    {

        static void Main(string[] args)
        {
            Program.CreateObject();
        }

        private static void CreateObject()
        {

            string name = "jack";
            string phone= "0000000000";


            string URL = "http://myserver/api.php?name=" + name + "&phone=" + phone;
            string DATA = @"{""name"":""jack""},{""phone"":""0000000000""};

            HttpWebRequest request = (HttpWebRequest)WebRequest.Create(URL);
            request.Method = "POST";
            …
Keep reading

All about SharePoint 2010 Content Type Hub

Content type hub is a new feature which comes with Managed Meta Data Service in SharePoint 2010. I have worked with SharePoint 2007 and i know that there is a problem for creating an enterprise library and sharing them across the site collections. There were no out-of-box solution to share content type which is created under a single site collection.
New Managed Meta Data Service in SharePoint 2010 has overcome this problem. Using this new feature a content type which is created under a single site collection can be shared across multiple site collections.


1. So lets start content type hub by creating a site collection.

2.After creating site collection, go to Site Actions->Site Settings->Site Collection Feature (Under Site    Collection Administration)


3.Now go to Service Application in Central Admin. Select ManagedMetaData and click on Properties   in top ribbon. Enter the url of site collection you created in step 1.(enter url in below field)

4. Now select Managed Metadata Se…
Keep reading

SharePoint Interview Questions and Answers

Below are few SharePoint questions asked in Interview.

Q. Explain Below code

using (SPSite site = new SPSite(SPContext.Current.Web.Url))// Gets the absolute url of the website

using (SPWeb web = site.RootWeb) //  Gets the root website of site collection

using (SPWeb web = site.OpenWeb())// OpenWeb accepts either GUId of sites or site url, if parameter is blank means returns the site associated with the current url

SPWeb - Represents SharePoint service websites

SPSite -  Represents a collection of sites in a web application.

SPWebApplication - Represents and IIS web application.

SPWebCollection - Represents a collection of SPWeb object.

SPWebTemplate - Represents a site definition or site template that is used to create SharePoint sites.

SPList - Represents a list on SharePoint Site.

SPListCollection - Represents a collection of SPList object.

SPListItem - Represents a list item or row.

SPListItemCollection - Represents a collection of SPListItem object

Base class for Timer Job - SPJobDefinition
Base…
Keep reading

Calling ASP.Net WebMethod using jQuery AJAX

Jquery allow users to call server side code without any postback.
Follow below steps:

Create a table with below script:

SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[userTable](
[id] [int] IDENTITY(1,1) NOT NULL,
[name] [varchar](50) NULL
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO


Write stored procedure to save data into table:

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

CREATE PROCEDURE InsertData

@name varchar (50)
AS
BEGIN

SET NOCOUNT ON;
insert into [dbo].[userTable] (name) values(@name)
END
GO

AJAX Method to Call Web method

  function SaveData() {
            var name = document.getElementById('<%=txtName.ClientID %>').value;

            $.ajax({
                type: "POST",
                url: /MyFolder/MyAjaxPage.aspx/SubmitData",
                data: '{"name":"' + name + '"}',
                contentType: "application/json; charset=utf-8",
                dataType: "json",
   …
Keep reading