If you don't already know, you can't treat SharePoint databases like any other database in regards to SQL Server. Here's a listing of articles that talk to what you can do. Before doing any maintenance, PLEASE read these articles. Index fragmentation is a big hotspot for alot of SQL DBAs.
Database maintenance for Office SharePoint Server 2007 (white paper)http://technet.microsoft.com/en-us/library/cc262731.aspx
How to defragment Windows SharePoint Services 3.0 databases and SharePoint Server 2007 databases http://support.microsoft.com/kb/943345
Information about the Maintenance Plan Wizard in SQL Server 2005 and about tasks that administrators can perform against SharePoint databaseshttp://support.microsoft.com/kb/932744/
You experience issues with portal alerts in SharePoint Portal Server 2003 or with search performance in SharePoint Server 2007 after you create SQL Server 2005 maintenance planshttp://support.microsoft.com/kb/930887
Support for changes to the databases that are used by Office server products and by Windows SharePoint Serviceshttp://support.microsoft.com/kb/841057/
PingBack from http://informationsfunnywallpaper.cn/?p=2499
SQL Maintenance for SharePoint Databases SharePoint databases are NOT like any other database in regards...
If someone would be intersted, you can see possible improvement results on typical actions in SharePoint after using proposals from Microsoft.
Hello, are you going to write anything on sharepoint 2010 and db perf and maint?
Here's how I shrink my WSS 3 log file.