13.8. Database Management

The database management activities that are available within WSS beyond the initial creation of a database, whether at install or web application creation time, are focused primarily around backup/restore issues of sites. For anything above and beyond that, you are looking at management using SQL tools.

The backup and restore processes are covered extensively in Chapter 12, "Maintenance and Monitoring," so they won't be covered here. Our focus will be purely on understanding the options within STSADM, not necessarily when to use it.

Table 13.6 shows a list of database management operations.

Table 13.6. Database Management Operations Reference
Addcontentdb-url <web application url>

-databasename <database ...

Get Mastering Windows® SharePoint® Services 3.0 now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.