Hi, How to create multiple secondary data files and log files for Content database. As there is special stored procedures to create secondary datafiles and move the tables for Search database(from the link http://blogs.msdn.com/enterprisesearch/archive/2008/09/16/sql-file-groups-and-search.aspx, we have two stored procedure named MoveTableToFileGroup.sql and MoveCrawlTablesToFileGroup.sql). So I followed this link created multiple secondary files and moved the data using these stored procedures. Similarly is there any method or procedure to create multiple secondary data n log files for Content Database 2.How to reorganize/rebuild indexes of sharepoint databases to defragment? From the link http://support.microsoft.com/kb/943345/, there is stored procedure which reorganize/rebuilds the indexes of Search,Profile and Content databases. So my question is do we need to create this Stored proc in each if these 3 databases? or can we create this Stored procedure in master database and schedule job(how to do this) 3.These databases indexes are getting fragmented rapidly and I checked the fill factor, it is the default value 100? So can we change the fill factor server level to 70? and is this improves the performance? how actually you are dealing with this 4.If you are created multiple secondary data n log files for content and search databases, how you are taking backups and restores 5. We have 8 processors but have only 5 disks C (OS), D (Primary data files), E (Secondary data files), F (Log files), and G (TempDb). SO I can create only one secondary data files. Is it OK to have 2 data files for 100 GB Content database? 6. We have TempDB on separate Disk but with only one .mdf & one .ldf files. No multiple secondary data files. Thanks