Sync: Stsadm operation (Office SharePoint Server)

Updated: March 22, 2007

Applies To: Office SharePoint Server 2007

Updated: 2007-03-22

Operation name: Sync

Configures the Windows SharePoint Services 3.0 synchronization job. Normally, this operation is used in conjunction with the preparetomove operation.

Syntax

stsadm -o sync

   -excludewebapps <Web applications>

   -synctiming <schedule>

   -sweeptiming <schedule>

   -listolddatabases <days>

   -deleteolddatabases <days>

Parameters

Parameter Value Required? Description

excludewebapps

A valid URL, such as "http://server_name"

Yes

Comma-delimited list of Web application URLs to exclude from consideration in the synchronization process. The values specified delete any existing values set.

synctiming

Yes

Sets the schedule for the main synchronization job. "M" denotes every n minutes (for example, “m:5” means every 5 minutes). "H" denotes every n hours (for example, “h:1” means every 1 hour). "D" denotes the number of times per day (for example, “D:3” means three times per day).

The default is once per hour.

Note Note:

You can use the SPSchedule.FromString() string method to pass in the strings, “every 5 minutes” or “weekly xxxxxxx”. For additional information about the SPSchedule.FromString method, see SPSchedule.FromString method1 (http://go.microsoft.com/fwlink/?LinkId=85966&clcid=0x409).

sweeptiming

A valid time value in the form of minutes, such as "1"

Yes

Performs the same tasks as the synctiming parameter. However, the sweeptiming parameter sets the schedule for the “sweep” job. The sweep job is driven by the Windows SharePoint Services 3.0 change log and is used as a lightweight way to capture new users added. For example, you might have a fully synchronized site, but then a user is added to the site. The sweep job ensures that the incremental newly added user gets the user profile properties replicated quickly.

The default value is every 1 minute.

listolddatabases

A valid number of days, such as "2"

Yes

Lists content databases that have not been synchronized since n days. The presumption is that they have been deleted or moved.

deleteolddatabases

A valid number of days

Yes

Performs the same operation as the listolddatabases parameter, except it deletes old records corresponding to these databases. It does not delete the databases themselves.

Links Table
1http://msdn2.microsoft.com/en-us/library/microsoft.sharepoint.spschedule.fromstring.aspx
Community Content Add
Annotations FAQ
not required
And why does it say all of those parameters are required when they're not? If you run "stsadm -o sync" it runs fine.

[tfl - 05 12 09] Hi - and thanks for your post.You should post questions like this to the Technet Forums at http://forums.microsoft.com/technet or the MS Newsgroups at 

http://www.microsoft.com/communities/newsgroups/en-us/. You are much more likely get a quick response using the forums than through the Community Content. For specific help about:
Exchange : http://groups.google.com/groups/dir?sel=usenet%3Dmicrosoft.public.exchange%2C&
SQL Server : http://groups.google.com/groups/dir?sel=usenet%3Dmicrosoft.public.sqlserver%2C&
Windows : http://groups.google.com/groups/dir?sel=usenet%3Dmicrosoft.public.windows%2C&
Windows Server : http://groups.google.com/groups/dir?sel=usenet%3Dmicrosoft.public.windows.server%2C&
Virtual Server : http://groups.google.com/group/microsoft.public.virtualserver/topics?lnk
Full Public : http://groups.google.com/groups/dir?sel=usenet%3Dmicrosoft.public%2C&


RE:[tfl - 05 12 09]
RE:RE:[tfl - 05 12 09] Hi - and thanks for your post.You should post questions like this to the Technet Forums at http://forums.microsoft.com/technet or the MS Newsgroups at - comment from moderator.

Isn't the purpose of the documentation explain those kind of thing so one does not need to ask the forums?

[tfl] if you have specific content to add that helps to 'explain those kinds of things' then feel free to add comments here. This is not, however, a support forum and support questions should be asked in the forums or newsgroups. HTH
-AggressiveMySiteCleanup <0 or 1>
What is the purpose of this parameter?

[tfl - 12 07 10] Hi - and thanks for your post.You should post questions like this to the Technet Forums at http://forums.microsoft.com/technet or the MS Newsgroups at http://www.microsoft.com/communities/newsgroups/en-us/. You are much more likely get a quick response using the forums than through the Community Content. For specific help about:
Exchange : http://groups.google.com/groups/dir?sel=usenet%3Dmicrosoft.public.exchange%2C&
SQL Server : http://groups.google.com/groups/dir?sel=usenet%3Dmicrosoft.public.sqlserver%2C&
Windows : http://groups.google.com/groups/dir?sel=usenet%3Dmicrosoft.public.windows%2C&
Windows Server : http://groups.google.com/groups/dir?sel=usenet%3Dmicrosoft.public.windows.server%2C&
Virtual Server : http://groups.google.com/group/microsoft.public.virtualserver/topics?lnk
Full Public : http://groups.google.com/groups/dir?sel=usenet%3Dmicrosoft.public%2C&


IgnoreIsActive explanation
The IgnoreIsActive flag allows you to choose which profiles to sync. By default, only the active profiles in a content database get sync'ed. An active profile is one of a user who has contributed something to the site. If you want to sync all users in the site, you can choose to trigger the execution of the sync job via STSADM with the IgnoreIsActive flag set to 1, and it will sync every profile.
Duplicate Site ID Error in application Event log

Hi,

I am getting "Duplicate Site ID Error in application Event log". This is logged every hour.

Will this slows down the server performance?

Please suggest a solution for this.

Thanks

Vinay


Use the preparetomove switch like it says at the top of the page! http://technet.microsoft.com/en-us/library/cc262122.aspx

What is the purpose of the parameter "-ignoreisactive"

Can you provide detailed information on the parameter "-ignoreisactive ", including the default value

Thanks

  

stsadm -help sync
stsadm -o sync
{-ExcludeWebApps <web applications> |
-SyncTiming <schedule(M/H/D:value)> |
-SweepTiming <schedule(M/H/D:value)> |
-ListOldDatabases <days> |
-DeleteOldDatabases <days>
-IgnoreIsActive <0 or 1>}