Microsoft Office SharePoint Server 2007 includes the Stsadm tool for command-line administration of Office SharePoint Server 2007 servers and
sites. Stsadm is located at the following path on the drive where SharePoint Products and Technologies is installed: %COMMONPROGRAMFILES%\microsoft shared\web server extensions\12\bin. You must
be an administrator on the local computer to use Stsadm.
Stsadm provides a method for performing the Office SharePoint Server 2007 administration tasks at the command line or by using batch files or scripts.
Content database Operations:
Add content db:
stsadm.exe -o addcontentdb
-url <url>
-databasename <database name>
[-databaseserver <database server name>]
[-databaseuser <database username>]
[-databasepassword <database password>]
[-sitewarning <site warning count>]
[-sitemax <site max count>]
Database repair:
stsadm.exe -o databaserepair
-url <url>
-databasename <database name>
[-deletecorruption]
Delete content db:
stsadm.exe -o deletecontentdb
-url <url>
-databasename <database name>
[-databaseserver <database server name>]
Set config db:
stsadm.exe -o setconfigdb
[-connect]
-databaseserver <database server>
[-databaseuser <database user>]
[-databasepassword <database user password>]
[-databasename <database name>]
[-exclusivelyusentlm]
[-farmuser]
[-farmpassword]
[-adcreation]
[-addomain <Active Directory domain>]
[-adou <Active Directory OU>]
Delete config db:
stsadm.exe -o deleteconfigdb
Merge content dbs:
stsadm.exe -o mergecontentdbs
-url <url>
-sourcedatabase <source database name>
destinationdatabasename <destination database name>
[-operation <1, 2, or 3>]
[-filename <file name that is saved from the stsadm -o enumsites operation>]
Where operation is:
1. Analyze (default)
2. Full database merge
3. Read from file
Trim audit log:
stsadm -o trimauditlog
-url <URL name>
-enddate <YYYYMMDD>
-databasename <database name>
[-databaseserver] <database server name>
| November 2009 | ||||||||||
| M | T | W | T | F | S | S | ||||
| 1 | ||||||||||
| 2 | 3 | 4 | 5 | 6 | 7 | 8 | ||||
| 9 | 10 | 11 | 12 | 13 | 14 | 15 | ||||
| 16 | 17 | 18 | 19 | 20 | 21 | 22 | ||||
| 23 | 24 | 25 | 26 | 27 | 28 | 29 | ||||
| 30 | ||||||||||
|
||||||||||