SharePoint database growing too big.

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

SharePoint database growing too big.

Author

Topic

suresha_b
Yak Posting Veteran

82 Posts

Posted - 2009-05-25 : 02:17:27

One of the SQL Sever has SharePoint database.
A database called SharedServices1_Search_DB has grown to 130 GB size.
It has a table called MSSCrawlURL. This table is consuming 125 GB space and has over 100 million rows. How to purge this table? Any help will be highly appreciated.

Thanks

nr
SQLTeam MVY

12543 Posts

Posted - 2009-05-25 : 02:39:53

Have a look at
http://social.technet.microsoft.com/Forums/en-US/sharepointadmin/thread/0d87daf0-df8f-44a7-9009-34b82322e0a1

Here's an explanation of what it's used for
http://admincompanion.mindsharp.com/BillBlog/Lists/Posts/Post.aspx?List=2d22afa2%2D592b%2D471a%2D9cd1%2D4e8de8a2abc0&ID=83

==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

suresha_b
Yak Posting Veteran

82 Posts

Posted - 2009-05-25 : 08:38:30

Thanks NR for the quick reply.

I looked at the links. It needs to be handled from SharePoint. So, I have requested one of the team members to fix it.

Regards

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources