|
Written by Administrator
|
|
Monday, 30 August 2010 12:27 |
After using command stsadm –o mergecontentdb you are unable to shrink original DB for the space that should be already moved in another DB
The move works correctly and the “stsadm –o mergecontentdbs” command returns no error. Looking in the new content database you could see the data and an entry in the “sites” table. However you cannot shrink the old content DB as there is no free space in there.
So what was the problem?
|
|
Read more... [Unable to shrink database after stsadm -o mergecontentdbs]
|
|
|
Written by Administrator
|
|
Thursday, 15 April 2010 10:50 |
Once I had to check progress of my full crawl for WSS 3.0, and as there is no GUI for that as for MOSS i started to google.
Luckily for me I found perfect article how to find this one via SQL.
You can find full article here: http://blogs.technet.com/neerajr/archive/2009/08/17/how-to-find-out-the-crawl-status-in-wss-3-0.aspx
Example:
SharePoint web application URL : http://wsstest:90
WSS 3.0 Search database: WSS_Search
1. Query to check the last crawled URL's for the WSS 3.0.
SELECT [DocID],[AccessURL],[DisplayURL],[DisplayHash],[LastTouchStart],[LastTouchEnd]
FROM [WSS_Search].[dbo].[MSSCrawlURL]
where DisplayURL like '%wsstest:90%'
order by LastTouchStart desc
2. Query to check the crawl error for the SharePoint site in WSS 3.0.
select msscrawlurllog.lasttouchstart as Time, msscrawlurllog.displayurl as URL,msscrawlurllog.errorid as Error, msscrawlerrorlist.errormsg as Description
from msscrawlurllog
join msscrawlerrorlist on msscrawlurllog.errorid = msscrawlerrorlist.errorid
order by msscrawlurllog.lasttouchstart
3. Query to check the how many items has crawled for the SharePoint site in WSS 3.0.
SELECT [HostID],[HostName],[SuccessCount],[ErrorCount],[WarningCount]
FROM [WSS_Search].[dbo].[MSSCrawlHostList]
where HostName like '%wsstest:90%'
4. Query to find out the crawl 'Start" and 'completed" time in WSS 3.0.
SELECT [CrawlID],[RequestTime],[Status],[StartTime],[EndTime]
FROM [WSS_Search].[dbo].[MSSCrawlHistory]
order by starttime desc
Whole article including images you can find on original blog at: http://blogs.technet.com/neerajr/archive/2009/08/17/how-to-find-out-the-crawl-status-in-wss-3-0.aspx
Cheers KbNk;
|
|
Written by Administrator
|
|
Tuesday, 13 April 2010 13:25 |
I had to find out the sizes of all docuemnts uploaded to SharePoint and their location (works with MOSS and WSS)
Thanks to coleague of mine Martin B, here is the script that will query content DB you run in on and will show you nice table with Document name, Library name, Site Url and of course its size.
You can specify which files should be included and excluded in report and also from which size it should be reported (just modify last 0 in script)
SELECT Webs.FullUrl As SiteUrl, Webs.Title 'Library', DirName + '/' + LeafName
AS 'Document',
cast(round(cast(isnull(Size,0) as numeric(20,10))/1024/1024,2) as numeric(10,2)) as 'Size in MB'
FROM Docs INNER JOIN Webs On Docs.WebId = Webs.Id
INNER JOIN Sites ON Webs.SiteId = SItes.Id
WHERE
Docs.Type <> 1 AND (LeafName NOT LIKE '%.stp')
AND (LeafName NOT LIKE '%.aspx')
AND (LeafName NOT LIKE '%.xfp')
AND (LeafName NOT LIKE '%.dwp')
AND (LeafName NOT LIKE '%template%')
AND (LeafName NOT LIKE '%.inf')
AND (LeafName NOT LIKE '%.css')
AND cast(round(cast(isnull(Size,0) as numeric(20,10))/1024/1024,2) as numeric(10,2)) > 0
ORDER BY 'Size in MB' DESC |
|
Written by Administrator
|
|
Monday, 01 March 2010 21:25 |
You can find several articles how to remove server from farm (moss or wss) they all discusing about "best" option how to remove the server from farm. The Configuration Wizard method. BUT, this option is not present anymore, at least i was not able to find it anywhere. So best option for me is psconfig one, or if server is offline, the Central Administration one. Read more for details.
|
|
Read more... [Remove server from farm - MOSS / WSS]
|
|
Written by Administrator
|
|
Friday, 12 February 2010 11:06 |
It might happen that you have missing Windows SharePoint Services Help Search on your MOSS Farm service list. And you cannot search HELP content.
Before you start be aware of the bug in MOSS - when the service is stopped, it is labeled as "Windows SharePoint Services Search". Once the service has been started,the label changed to "Windows SharePoint Services Help Search"
Here is small overview about those two services, which one is used for what.
|
|
Read more... [SharePoint HELP content is not indexed]
|
|
Written by Administrator
|
|
Friday, 12 February 2010 10:38 |
In case you have users from several domains to be added to site (WSS/MOSS) you might get error when you search for them via people picker : No exact match was found.
This is because "security" of the WSS, to solve this issue you have to create and specify user that exists on those domains to allow search within those domains.
|
|
Read more... [People picker says: No exact match was found.]
|
|
|
|
|
|
|
Page 1 of 4 |
| 
| 
| 
| 