Migrating WSS 3.0 intranet or internet to Sharepoint 2007

Step 1 : BACKUP Backup Database for Site 80 of WSS 3.0. Do below steps on WSS 3.0 server ( SESIS01.domain.com).How to find which database need to take backup for Sharepoint 80? See below

Database name is WSS_Content and copy from below location

Step 2 : RESTORE
· Install fresh Sharepoint Portal Server 2007 on Windows 2008
· After installation copy the database backup to the server running Sharepoint 2007
· Restore the database backup onto the SQL server 2008 – SESOP04.
· Open the Sharepoint 3.0 Central Administration site. This can be located at Start->Administrative Tools->Sharepoint 3.0 Central Administration.
· Click on the Application Management tab at the top of the screen
· Go to "Create or extend Web Application" under the "Sharepoint Web Application Management" section.
· Click on "Create a new Web application" to create the new Web Application where we are going to restore our Sharepoint 2003/WSS V2.0 site to.
· Fill in the appropriate information to create a Sharepoint 2007/WSS V3.0 Web Application in your environment and click "OK"
· Once the "Operation in Progress" screen has disappeared and the create operation is completed you will be taken to the "Application Created" screen. Do not go to "Create Site Collection".
· Open a command prompt.
· Run the Sharepoint stsadm tool with the following command line:

stsdm -o addcontentdb -url http://sesop05/ -databasename wss_content -databaseserver sesop04
NOTE: We need to use the stsadm command line tool to add the new content database because the web application may timeout if you use it to add the content database.

· Click "Enter" and the content database will be added to the site.
· Return to the Sharepoint 3.0 Central Administration application and click on the "Application Management" tab.
· Click on the "Content databases" link under the "Sharepoint Web Application Management"
· You will be redirected back to the "Content databases" screen
· Make sure that the Web Application you just created is selected in the drop-down list of Web Applications.
· Click on the content database that was initially created when you created the web application.
· On the screen that appears click the check box next to "Remove content database".
· Click "OK". This will remove the initial database from the SQL Server.
· Your site is not ready to access. However if you are moving to a machine that has different user accounts you may have a problem logging into the new site. If you do follow the rest of the steps in the article.
· Go to the "Application Management" tab in the Sharepoint 3.0 Central Administration application.
· Click on "Site Collection Owners" located under "Sharepoint Site Management"
· Make sure the correct Web Application is selected in the drop-down
· Set the Primary and Secondary site collection owners to the correct user accounts and click "OK"
· Your site will now be ready to access with primary or secondary site collection owner account.

How To shutdown and restart DATA CENTER

How To shutdown and restart DATA CENTER

Please follow below procedure to shutdown datacenter.

1. Shutdown all application server like development and staging servers, application servers like Sharepoint portal server, Adept, Estate Master, Cougar, Microsoft CRM, Timerline, ERP software related servers, blackberry server etc.
2. Shutdown all servers like database servers, exchange server, enterprise vault servers, all virtual machines, infrastructure management server
3. Shutdown all vmware host, then domain controller & dhcp servers
4. If you have any storage solution like, SAN or NAS then need to shutdown all related appliances
5. Shutdown network, routers and firewall including cisco switches, routers, cisco ASA etc
6. then UPS
when you need to restart data center, please follow step from number 6 to 5 then 4 and onwards.

Once you will start domain controllers and dhcp servers, please test with some workstation before you will start the process of other servers.

How To shutdown and restart EMC CLARiion SAN – CX 300, CX 500 etc.

How To shutdown and restart EMC CLARiion SAN – CX 300, CX 500 etc.

Before you will start the process of shutting down EMC SAN, you need to be sure attached host to SAN should be disconnecting from storage.

What means of disconnecting from storage?

You need to be sure, all attached host likes windows 2000, 2003 or 2008 based SQL server, fileserver, application servers, net backup server or vmware server, cluster nodes which storing their respected data, should be shutdown before you will start to shutting down EMC SAN.

After performing above step, you can start to shutdown SAN devices in below sequence.

1. Switch off SPS A and SPS B, one by one. As show on figure 1.
2. After five minutes, pulling out all power cable from disk enclosure or DAE2P ( Disk Array Enclosure 2 Gigabit Point to Point Disk Array Enclosure )
3. Then you need to shutdown SAN switch and then SAN router ( if you have )

Restart EMC SAN devices

1. Turn it on SAN router and then SAN switch and check its connectivity with other host is up
2. Then plug in all power supply to disk enclosures one by one and wait until all drive shows green light. Just check for all hard drives on enclosure has green light
3. Then switch it on SPS A and SPS B one by one. Sequence number is not important for switch off or on of SPS.

Outlook Signature with VB scripts

Outlook Signature:
Now a day, it is a common requirement from company to have a corporate outlook signature with standard format across the board.

But it is not common and straight forward to create outlook signature for system administrator in hybrid IT infrastructure.
Here I have spent some time to create outlook signature for my current company.

This outlook signature has been implement with VB script and Group policy. This vb script you can assign to OU basis or also can assign to root level of active directory.

You definitely spend some if you want to add, modify or delete some fields from this script. But it is not difficulty if you have some basic understanding of AD Schema.

When you will run outlook signature script will create OutlookSignature folder on following location.

If you will run this scrip on your local workstation, will create folder under below path

C:\Documents and Settings\rparikh\Application Data\Microsoft\OutlookSingature

And if you are looking to create outlook signature for AD based users, it will create under below path ( roaming profile path )

\\fileserver\home\%username%\Documents and Settings\rparikh\Application Data\Microsoft\OutlookSingature

This script will create six different files under above directory.

Three for new email signature and three for reply email signature including one for .HTML format, one for .RTF format and one for .TXT format

File names should be as below

usernameOutlookSignature.html
usernameOutlookSignature.rtf
usernameOutlookSignature.txt

ReplyusernameOutlookSignature.html
ReplyusernameOutlookSignature.rtf
ReplyusernameOutlookSignature.txt

This signature is compatible with Outlook 2003 or Outlook 2007. Below attached script is compatible with outlook 2003. If you want apply this script to outlook 2007, you need to change value of “Office\11.0” to “Office\12.0” on two different location.
In future, when new version of Office will introduce, you just need to change above location of new version of office.