stsadm preparetomove

[Clay Aiken]

I am using Office Sharepoint. I am suggested to run stsadm -o preparetomove command while trying to share from 1 farm to another. Does this will create any problem to it???

[Milton.J]

This is due to several reasons, the main being IT WILL break the relationship between your shared service provider and your database. This relationship can be repaired but it essentially means losing the part of your search index that relates to that database.

The full command is below.

stsadm -o preparetomove
           {-ContentDB <DatabaseServer:DatabaseName> |
       -Site <URL>}
           [-OldContentDB <uniqueidentifier>]
           [-undo]

For detaching databases cleanly from the farm we really only care about the first 2 switches. So your command might look like this.

stsadm -o preparetomove -contentdb SQLSERVER:DBNAME -site http://www.techarena.in

[Spyrus]

I have given you the syntax in the below Code :

Syntax :

stsadm -o preparetomove

   -contentdb <server name: database name>

   -site <URL name>

   [-oldcontentdb] <unique identifier>

   [-undo]

[Snake08]

The sync job will continue to sync the user profiles against the content DB if you don't do that perparetomove and could impact server performance on the existing farm.