How to Restore a Site Collection directly from SQL Content DB

How to Restore a Site Collection directly from SQL Content DB

Here is how you can restore a site collection directly from a SQL Content DB

  • Restore a backup of the SQL database to your SQL server, add this DB to the SQL server using a different name.  do not use the production name (will explain later)
  • Run this stsadm command: 
    • stsadm -o  addcontentdb -url http://temp_web_applicaion -DATABASENAME name of your_restore_DB
    • Note:  I recommend you add this DB to a temp web application, back it up, and then restore it to its properly location.
  • If you browse to your Central Admin and click on Site Connections list for the web app http://temp_web_application, you should see that all the site collection in this DB will not be available.
  • Run a backup using: 
  • Restore it back to its properly location by running a restore using: 
    • stsadm -o restore -url http:// web_applicaion/sites/site_youwant_to_restore -filename c:\restore.cmp

Manually add agent to DPM Server

Here are the steps to manually install and add agent to DPM server

Copying the agent install files over:

– You should be able to find it on your install CD at in the Agent folder

– if you have SP1 or other version install, you can find the newer version of the agent on your server locally:  <drive letter>:\Programs Files\Microsoft DPM\DPM\Agents\

If you are installing the agent for the first time:

– (x64) DPMAgentInstaller_amd64.exe <DPM server name>

– (x86) DPMAgentInstaller.exe <DPM server name>

Depends on the version of the agent you are installing, your .exe might be different, for example:

– (x64) DPMAgentInstaller_KB959605_amd64.exe <DPM server name>

– (x86) DPMAgentInstaller_KB959605.exe <DPM server name>

If you already have the agent install and want to change/modify/add the DPM Server

SetDpmServer.exe –dpmServerName <DPM server name>

Example:  SetDpmServer.exe –dpmServerName DPMServerName

On the DPM Server using DPM Management Shell, run the following command:

Attach-ProductionServer.ps1 <DPM server name> <production server name> <user name> <password> <domain>

Note:  you don’t really need username, password, and domain if you don’t want to, DPM will ask you for those info after the command.

Example:  Attach-ProductionServer.ps1 DPMServerName NameOfServerWithAgent

How to set up SSO in SharePoint

How to set up SSO in SharePoint

Was having problem setting up SSO.  Keep getting error.  Here is what I did to get it setup properly (I notice there are post out there in the internet, but some are missing some information:

1.  Create a domain service account (ex: moss_sso)

2. OPTIONAL: Create a domain security group with “Global” and with “Group Type” as “Security”.  Add the moss_sso service account to this group.  (you can create two group, one for Definition Administrator and one for SSO Administrator)

3. Add the domain services account (or security group) to the local administrators group on all SharePoint servers.

4. Log into the server that is running “Central Administration” web site.

5. Navigate to “Central Administration -> Operations -> Service Accounts” and double check the “Single Sign-on Service” credentials, set the services to run from the domain services account (moss_sso).

6. Also add the domain service account used to run the service to the Farm’s administrators group

7. Start the “Microsoft Single Sign-on Service” in the Windows Services under Manage.  Set the services to start “Automatic”.  Run the service under a domain service account (moss_sso).  Start the service. (if not already started)

6. Repeat 6 on all server except server which will only act as WFE.

7. In SQL, set the domain service account (moss_sso) running the Microsoft SSO service has the following roles assigned on SQL Server:  dbcreator and securityadmin

8. Log into the server that is running “Central Administration” web site.  NOTE:  make sure you log using the New Services account (moss_sso)!!!  This is the part that give the issue when I was trying to set this up.

12.Navigate to “Central Administration -> Operations -> Manage Single Sign-On -> Manage Server Settings” to setup SSO for SharePoint

12.1 Single Sign-On Administrator Account: Domain Group or the Services account moss_sso

12.2 Enterprise Application Definition Administrator Account: Domain Group or the Services account moss_sso

12.3 Database Server Name (use netbios naming convention)

12.4 Database Name

12.5 Timeout settings (I used Default)

12.6 Ok.