Aarat’s Blog

Want to migrate project server??

Here are the steps..

1.) Install MS project Server and Configure everything on other server on which you want to migrate.

2.) Backup Content database of old project server from SQL Server Management Studio. [ Incase you are migrating SQL server also, else this step is not required]

3.) Restore content db on New SQL Server.

4.) run stsadm -o addcontent db command on new project server and give the required paths of database and site.

5.) backup all the workspaces with stsadm -o export -url http://sitename

6.) import all the workspaces with stsadm -o import -url http://sitename

7.) Done, you are ready to migrate to new project server..

8.) Dont forget to check project resource kit.

Cheers.!!!

After weekend I am back to office and found our sharepoint server database to be suspect..

we use Sharepoint server 2007 and SQL server 2008 as a database provdier..

Following are the steps that one should follow to bring sharepoint database to normal..

1.)  Remember to take backup of the database once the configuration is over..

2.) Restore the database if you have backup..

3.) If you are not having backup of the database then it would be great trouble for you.

Steps to be taken in absence of backup.

1.) Put the database in to emergency mode by using command

alter database “Sharepoint_config” set emergency

[Note: "Sharepoint_config" is the database name of your sharepoint configuration database"]

2.) Take the database in single user mode by going to properties of database >> options >> Restrict Access >> Single User

3.) run query dbcc checkdb (‘sharepoint_config’, repair_allow_data_loss)

4.) Voila its up now.. Now u need to get the database in multi user again..

If Incase it stucks at single user prompt then just take the database offline and bring it back to online and then put it to emergency mode and then try to run dbcc command.

I am back to work again…

Rajkot I am coming,

Happy Independence day..

Just added software page to my site…

http://www.aarat.com/softwares/

Its more than a week of me having been to rajkot…

Oh i am missing you all…

I am loving windows seven…

Upgraded both home as well as office system with windows seven…

Just installed windows 7 on my HP Pavilion Laptop… Overall its really Fast operating system.. all the memory consumptions features were removed and made widows vista simple..

Things that i noticed:

1.) Removed Sidebar — Great Job (windows vista was chewing up the memory)
2.) Windows media player 12 — Really Great now comes with Dolby Digital.. Great sound quality.
3.) Renewed Task bar — Really Great concept, I just loved it..
4.) Great Speed — Really Optimized Speed then windows vista.
5.) Application Compatibility — Thats really Cool Feature (almost we can make run all the applications)
6.) Great Themes and Desktop Apperance — Really Themes are great and cool Desktop appearance.
7.) Very simple to manage User account control.
8.) Great Operating system for Touch enabled computers.
9.) Missed dreamscenes that where in windows vista.. although they were consuming memory
10.) Media player’s library not having directory addition feature.. what if my songs are stored in external or another partition??

I am coming Rajkot…

are you ready???