Monday, July 27, 2009

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.

Sunday, May 24, 2009

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.