Tag Archive for Administration

Default Content Database

Nothing too complicated today but something that some people aren’t aware of and ask if it can be done – having more than one content database so they can, for example, keep sensitive data separate from their general day to day content.

It’s simple enough to create multiple content databases in Central Administration:

Within Application Management, click the Manage Content Databases link. This will take you to the /_admin/CNTDBADM.aspx page.

From that page, click the Add a content database link. Ensure the Web Application is set to the one where you want new site collection to be created in, fill in the new content database form and click OK. After a short while your new content database will be ready to use.

There are a couple of ways to setup the content database as the default database for new site collections. The first is:
Read more

Move SharePoint Database

Before attempting to move the databases associated with your SharePoint instance, make sure you backup your farm before continuing. For example, the following PowerShell script performs a full backup of the farm:

Backup-SPFarm -Directory c:\backuppath -BackupMethod Full

Depending on the size of the databases, this may take some time to complete.

One thing to check before starting the move is that the version of SQL is identical for both the source and target servers.

Once your happy that SharePoint has been backed up, the first thing to do is stop all SharePoint and Internet Information Services (IIS) services on the server that is running the Central Administration Web site. Do this by opening the Services snap-in from the Microsoft Management Console.
Read more


Get every new post delivered to your Inbox

Join other followers: