add content db to sharepoint 2010

You can add an existing content dB to an existing site collection

Once this activity is done, SharePoint creates the Url buy default and you can just navigate to the Url and check if the content dB has all the data and verify is this was successfully done.

  

Adding content dB to site collection:

1)      Go to central Administration

2)      Application Management

3)      Databases à Manage content database à Add a content database

4)      Check Database server name(this would populate automatically, just verify)

5)      And give Database name – this would also populate or have a name by default BUT we need to CHANGE this

the Database name has to be a name of an existing DB which you want to add to the site collection.

You really don’t have to worry about all the other default options

6)      Select Windows Authentication if not selected.

7)      No other changes.

8)      OK

9)      It will show the database in Add a content database screen.

Check Point

1) Go to Central Admin à Application Management.

2) Site Collections à View all site collections

3) This will take you to a screen where you can see the Url of your site collection corresponding to the DB that you attached to the site collection.

Make sure you select the correct Url of your site collection

4) Click on the Url to see other details

5) Browse the url/_layouts/settings.aspx to see the data in the DB.

In my case it is  à http://myserver01:9999/sites/Team/_layouts/settings.aspx