Tuesday, March 17, 2009

Detaching and Reattaching a Content Database

Detach

The easiest way to detach a content database is thru the UI in Central Administration.
Central Administration -> Application Management -> Content Databases
Click on the link for the Content Database you want to detach. Make a note of the name of the database. Check the 'Remove content database' checkbox. Click OK. This removes but does not delete the database.

Attach

If the Content database is larger, then attaching it is best done using stsadm. Login to the SharePoint server. Bring up a cmd window. Run the following command: stsadm -o addcontentdb -url [url] -databasename [database name]

You can also attach smaller databases using the UI in Central Administration.

Central Administration -> Application Management -> Content Databases

Click 'Add a content database'. Specify the database name you jotted down when detaching. Click OK.

Thursday, March 12, 2009

Configure SMTP for MOSS on Windows Server 2008

To configure SMTP for MOSS on Windows Server 2008 do the following:

Windows Server 2008 Configuration

  1. Add the SMTP Server Feature if required.
  2. Specify an E-mail address
  3. Use the 'Deliver e-mail to SMTP server' option
  4. Set SMTP Server to your Exchange server
  5. Click Apply

MOSS Configuration

  1. Central Administration -> Operations -> Incoming E-Mail Settings
  2. Enable sites on the server to receive e-mail
  3. Settings mode: Automatic
  4. SharePoint Directory Management Server: No
  5. E-mail server display address: Accept default
  6. Accept mail from all e-mail servers.

Email is written to various C:\Inetpub\mailroot\ folders during the life of an email transmission. You may be able to use these folders for troubleshooting.