Archive for the ‘MS Office SharePoint Server’ Category

Microsoft Office Web Apps for SharePoint 2013

November 11, 2014

Deploy Office Web Apps Server

http://technet.microsoft.com/en-us/library/jj219455(v=office.15).aspx

Configure Office Web Apps for SharePoint 2013

http://technet.microsoft.com/en-us/library/ff431687(v=office.15).aspx#Before

SharePoint reduce growing disk space by reducing WSS_LOGGING dbase size

November 1, 2014

WSS logging database grows very fast and it cause the storage problem most of the time in sharepoint server 2010.

To reduce the size of the logging database or to purge the old data from the logging database we can perform these steps.

Execute the following script:By Default the system retains 14 days of Usage data in this database. By following PowerShell command we can check and change the value of retention days of this database.

Add-PsSnapin Microsoft.SharePoint.PowerShellWrite-Host “Data retention policy, which is set to 14 days by default.Going to set it to 3 days.”

   1:  Add-PsSnapin Microsoft.SharePoint.PowerShell
   2:  Write-Host "Data retention policy, which is set to 14 days by default.Going to set it to 3 days."
   3:  Get-SPUsageDefinition
   4:  $defs = Get-SPUsageDefinition
   5:  
   6:  Foreach($def in $defs)
   7:  {
   8:  Set-SPUsageDefinition –Identity $def.Name –DaysRetained 3
   9:  }

write-host “Now, open Central Admin and choose, Monitoring > Configure usage and health data collection > Log Collection Schedule>.”

Write-host “Execute the two Timer jobs:”
Write-host “1)Microsoft SharePoint Foundation Usage Data Import”
Write-host “2)Microsoft SharePoint Foundation Usage Data Processing”
Write-host “The SQL logging database will now contain some free space”
Write-host “which your SQL DBA can ‘free-up’ within SQL Management Studio “
write-host “or running the ‘DBCC ShrinkFile’ T-SQL command.”
Remove-PsSnapin Microsoft.SharePoint.PowerShell

After that we need to run the two timer jobs to clean the old data ‘Microsoft SharePoint Foundation Usage Data Import’ and ‘Microsoft SharePoint Foundation Usage Data Processing’.Go to Sharepoint Central Administration -> Monitoring -> Configure Usage and health data collection-> Log Collection Schedule.

And it will take you to the timer jobs.

Now Click on both the Job Definitions one by one and hit ‘Run Now’ to run the timer jobs

Once the timer jobs is run you can check and confirm database has released the space.
You can shrink the database after this by using ‘DBCC ShrinkFile’ T-SQL command

Original Source: Binary Republik

SharePoint Designer 2013 “All Files” missing for SharePoint Foundation 2013

October 31, 2014

You can make yourself Admin by doing the following:

  1. Log into Central Administration
  2. Go to Application Management -> Manage web applications
  3. Click on the Web Application you want to become Admin
  4. From the ribbon bar click on User Policy
  5. Click on Add Users
  6. Select All Zones and click Next
  7. Add your user name and check Full control
  8. Click on Finish and you’re done.  You’ll now have admin rights and see All Files in SPD.

SharePoint 2010 how to reduce the size of logging database or how to purge the old data from Logging Database

October 15, 2014

WSS logging database grows very fast and it cause the storage problem most of the time in sharepoint server 2010.

To reduce the size of the logging database or to purge the old data from the logging database we can these steps.

To find the Logging Database Name go to following path:-

Login to Central Administration -> Monitoring -> Configure Usage and health data collection->

 

The Logging database stores the following things:-

  • ULS Logs from 14 Hive\LOGS
  • Raw Resource Usage Data

This data is used by Web Analytics in Sharepoint. Two timer jobs Microsoft SharePoint Foundation Usage Data Import and Microsoft SharePoint Foundation Usage Data Processing are used for importing and processing the raw data in the web analytics database.

By Default the system retains 14 days of Usage data in this database. By following PowerShell command we can check and change the value of retention days of this database. Get-spusagedefinition and Set-SPUsageDefinition

Try  Get-SPUsageDefinition

Now you need to find which table is taking most of the space inside the WSS logging Database.

 

You Can check the same from the SQL Server

Login to Sharepoint Management Studio -> Select your logging Database (Right Click) -> Reports- > Standard Reports -> Disk Usage by Top Tables.

 

Say RequestUsage* is taking most of the space inside WSS Logging database so  you can bring down the retention period of  Page Request Event.

Or if you want you can bring down the retention period for all the Events for any number of days from 14 to 1.

Use the following command to do so.

Set-SPUsageDefinition -Identity”Page Requests” -DaysRetained 3

Run the same Power Shell command again to cross check “Get-SPUsageDefinition” and check the Retention period is changed or not.


After that we need to run the two timer jobs to clean the old data ‘Microsoft SharePoint Foundation Usage Data Import’ and ‘Microsoft SharePoint Foundation Usage Data Processing’.

Go to Sharepoint Central Administration -> Monitoring -> Configure Usage and health data collection-> Log Collection Schedule.

And it will take you to the timer jobs.


Now Click on both the Job Definitions one by one and hit ‘Run Now’ to run the timer jobs

 

Once the timer jobs is run you can check and confirm database has released the space.

Original Source: Manhar Sharma

Why does /_layouts/15/start.aspx appear as part of my SharePoint 2013 Site URL ?

October 2, 2014

The URL path of a newly created site collection will include “/_layouts/15/start.aspx” To avoid this it is necessary to deactivate the following site feature:

1. Go to Site Settings – Site Features page.

2. Deactivate the “Minimal Download Strategy” feature.

Why is the Minimal Download Strategy available by default on various site collection templates including the Team Site? This is a new feature for SharePoint 2013 that is designed to increase the performance of the SharePoint site.

The start.aspx page has a specific JavaScript object asyncDeltaManager (defined in start.js). This parses the URL, looks for the # sign and takes the path following that and dynamically loads that page.

Subsequent requests to pages are dynamically loaded through the asyncDeltaManager object. Once a link is clicked it will invoke a method in the JavaScript object which creates the MDS URL and appends the query string parameter AjaxDelta=1. A request is created and downloaded asynchronously and only the “delta” is returned to the client and assembled and rendered using JavaScript.

For a full explanation please read Wictor Wilen’s Blog post here: http://www.wictorwilen.se/sharepoint-2013—introduction-to-the-minimal-download-strategy-mds

Enable iFilter for TIFF OCR in SharePoint Foundation or SharePoint Server

October 1, 2014

In some companies, paper documents are scanned into TIFF formats and stored electronically.  To search for them, you’ll need to enable the TIFF OCR iFilter to allow SharePoint to index TIFF documents.

1. Install Windows Server feature Windows TIFF IFilter:

clip_image002

2. Enable OCR filter

clip_image002[7]

 

clip_image002[10]

3. You may need to restart the machine

4. Force SharePoint to perform a full crawl from Search Administration

5. Search for your file – here, I’m searching for “Therefore”

tiff-ifilter2

Source and original post

Tips for SQL tuning for SharePoint

September 24, 2014

Part 1 – MAX DOP:

http://blogs.technet.com/b/sqlpfeil/archive/2012/02/01/four-tips-for-sql-tuning-for-sharepoint-part-1.aspx

Part 2 – Shrink DB:

http://blogs.technet.com/b/sqlpfeil/archive/2012/03/03/four-tips-for-sql-tuning-for-sharepoint-part-2-shrink-db.aspx

Part 3 – TEMPDB:

http://blogs.technet.com/b/sqlpfeil/archive/2012/07/14/four-tips-for-sql-tuning-for-sharepoint-part-3-tempdb.aspx

SharePoint Foundation 2013 Language Packs with SP1 downloads

September 5, 2014

SharePoint Foundation 2013 Language Packs with SP1:

SharePoint Server 2013 Language Packs with SP1 downloads

September 3, 2014

SharePoint Server 2013 Language Packs with SP1:

SharePoint 2013 SP1 language pack

September 1, 2014

One missing piece in the SharePoint 2013 SP1 release were slipstream installation files for the language packs.

These should be available soon on download center on the following link:


Follow

Get every new post delivered to your Inbox.

Join 29 other followers