June 16, 2009 at 12:04 pm
hi,
We have MOSS 2007 databases in SQL Server 2055 EE ( SP3). My Question is:
Can we use the Maintenance plan task to Rebuild Indexes for all the user databases? or do we need to must use the procedure dbo.proc_DefragIndexes( reference:Database Maintenance for Microsoft® SharePoint® Products and Technologies ) for rebuilding indexes for all the databases OR this proceure is only to rebuild Content Database and for the rest we can use maintenance plan?
please clarify me
June 16, 2009 at 12:50 pm
Yes, we can put the Sharepoint Db's in our regular Maintenance plan's and DR Strategies like all other databases. (That is what i do for my sharepoint DB's)
I do indexes bi-weekly as my sites are used from moderate to heavy at times..
Maninder
www.dbanation.com
June 16, 2009 at 1:26 pm
Hi Mani,
As you said you are maintaining share point databases in sql server 2005, I have couple of questions.
1.What is your system database’s and user database’s collation settings?
2.Currently we have single data file and single log file. Now the content database size is 50GB and we want create multiple secondary data files. Could you please advise me how did you do that?
3.Does creating multiple secondary data files is supported for all share point databases?
4.In our environment, I’m taking the database backups from sql server side. But our share point admin also taking the backups from front end. (I have noticed in the error log). Does this allowed/supported? How is the scenario at our environment?
5.Are you using the rebuilding index task or reorganize index task? And is for all the databases?
6.Did you implement log shipping for the share point databases? If yes, please advice how to do that(any considerations compared to normal Log shipping)
I appreciate your help
thanks
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply