Use program to create attach\detach script file

If you are working on MOSS Large farm then i think you will need to create some script to detach\attach your content DB.

As i have share before the step by step to deploy MOSS SP2 blog have share about the great coding to help us to generate the share file. After try on this , i feel great!! is really very simple and usefull code for us to generate the batch file for script. Thanks to CJG.

The reasons i like to use to detach and attach the DB becuase :

1. Is a very faster way to get the latest update information at our farm
   
2. Auto generate the latest script ( no need manually create the script one by one)
3. with the simple coding we can edit it accordingly to our need
   

You can also create a command line utility to do this:

• Open Visual Studio
• Click “File->New Project”
• Select “Console Application”
• For name, type “ContentDetachAttachScript”
• Copy the following into the program.cs file:


using System;
using System.IO;
using System.Collections.Generic;
using System.Text;

using Microsoft.SharePoint;
using Microsoft.SharePoint.Administration;

namespace ConsoleApplication1
{
class Program
{
static void Main(string[] args)
{
TextWriter tw = File.CreateText("C:/detachall.bat");
TextWriter tw2 = File.CreateText("C:/attachall.bat");

SPFarm farm = SPFarm.Local;
SPAlternateUrlCollectionManager mgr = farm.AlternateUrlCollections;

foreach (SPAlternateUrlCollection altColl in mgr )
{
foreach (SPAlternateUrl url in altColl)
{
if (url.UrlZone == SPUrlZone.Default)
{
try
{
SPSite site = new SPSite(url.IncomingUrl);

SPWeb root = site.RootWeb;
if (root.WebTemplate != "CENTRALADMIN")
{
//get the web application for the site collection
SPWebApplication webApp = site.WebApplication;

foreach (SPContentDatabase cd in webApp.ContentDatabases)
{
tw.WriteLine("stsadm -o deletecontentdb -url " + url.IncomingUrl + " -databasename " + cd.Name + " -databaseserver " + cd.Server);

tw2.WriteLine("stsadm -o addcontentdb -url " + url.IncomingUrl + " -databasename " + cd.Name + " -databaseserver " + cd.Server);

//Console.WriteLine("Content Database [" + cd.Name + "] was detached");

//cd.Delete();

}
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
}
}

tw.Close();
tw2.Close();

Console.WriteLine("Press enter to close");
Console.ReadLine();

}
}
}

• Compile the program, press F6
• Copy the executable to your SharePoint Farm
• Run the executable
• Open the C:\detachall.bat file , this file will contain all the stsadm commands that will detach all your content databases
• Open the C:\attachall.bat file, this contains all the stsadm commands to reattach your databases (NOTE: you should attach one at a time in the later steps).

Improve the upload/Download speed for MOSS at diffrent Location

Recently have faced one problem...maybe cannot say is problem... Let me share with you the scenario here. Let say you have one MOSS server at US, then the client upload/Download file from US is slower than the client from Europe user. DO you think this is problem ?

After do some investigation, just found out our organization is add in Steelhead to our WAN system. The steel head help alot as what you see the testing report at below.

	do not have steelhead	steel head available
Upload	8m above( cause respond time out)	22s
Download	5m17s	11s

*this testing is base on 45M notepad file
*respond time out due to take too long to upload ( you can change the setting and web config ) or you can use the multiple upload file to resolved this issues.

**steelheed conside as one of the tool for WAN optimization or accelerator.