December 18, 2009 at 8:32 am
Probably like many companies, Sharepoint was installed without much if any DBA planning or input. Now I see one of it's tables has 68 million rows and may be starting to cause performance problems. I don't see any constraints or foreign keys on the table so probably could just delete records over a year old, but there is a command line tool STSADM for trimming the audit log. I have no idea how or where to run that.
Anyone know if it's safe to just do straight sql deletes from this table -- it's in one of the WSS_content databases. Don't you just love how Sharepoint creates databases where there is a GUID string in the name?
December 18, 2009 at 8:41 am
Struggling myself with that some myself. Personally, use the utility. Can I tell you where to run it, not to be a smart alec, but from the command line. I don't think you need to be in a specific directory, except maybe where the utility resides if not in your PATH.
It took me a while to figure out how to automate SharePoint backups using the utility.
December 18, 2009 at 10:22 am
As far as the stsadm tool, I'm guessing it's only accessible from the Sharepoint web server which I don't have access to, yet. As far as using it for backups? Do you mean backups of the sql databases, because I would always use sql server agent for that since it includes logging and email alerts for the DBA.
In general I don't like the idea of databases that are "managed" outside Sql mangement studio. If the Sharepoint admin folks can take care of it 100%, fine, but they are usually more GUI/Browser/Front end people -- I know that's the case here.
Again the root problem is installing an application that creates it's own databases, but apparently does not also set up maintenance/backup/reindexing jobs. Seems like the authors of Sharepoint ( Microsoft?) should include a warning on the box not to install this without having someone become proficient in Sharepoint admin, and to include your database staff in planning. CRM is another one with the same issues.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply