Wednesday, June 27, 2012

How to change Excel Web Access web part title

Today I came across a very small but very intersting stuff and I really didn’t aware abot this setting.
One of my user wanted to change the title of excel web access web part We changed it from Appearance > Title but it always took “ Excel Web Access – Title “which really irritated me
But finally I got the clue where to get this done as below
  • Click on Modify Shared Web Part
  • Under Toolbar and Title Bar uncheck Auto generate Web Part Title option and then change the name from Appearace > Title

  • This will allow you to change the web part title
 Hope this helps

Friday, June 15, 2012

Restore Web applicaton using SQL server tools in SharePoint 2010

There are some limitations to restore the whole web applicartion using SQL restore but we can use DB associated with Web Application using SQL tools

To restore databases associated with a Web application by using SQL Server tools

  1. The account must be a member of the sysadmin fixed server role.
  2. All stored procedures must be finished before a restore if any procedure is running stop SharePoint Timer service and wait for several minutes for any currently running stored procedures to finish.
  3. Do not restart the service until after you restore the databases.
  4. Now we are all set open SQL management studio and expand Database server
  5. Select the DB you want to restore > Right Click > Tasks > Restore > Database.
  6. In the Restore Database dialog box, specify all required information
  7. Open Options.
  8. In the Restore options section, select only Overwrite the existing database
  9. Recovery state section specify details as per your requirements
  10. Click OK

Restore a web applicaiton using Central Admin in SharePoint 2010

  1. Open Central Administration > Home page > Backup and Restore section > click Restore from a backup.
  2. The process consists of 3 steps
Step 1
Select Backup to Restore page > from the list of backups > select the backup job that contains the farm or Web application backup > and then click Next

Step 2
Select Component to Restore page > select the check box that is next to the Web application > and then click Next.

Step 3
Select Restore Options page > in the Restore Component section > make sure that Farm\<Web application>appears in the Restore the following content list.

3.      In the Restore Only Configuration Settings section, make sure that the Restore content and configuration settings option is selected.
4.      In the Restore Optionssection, under Type of Restore, select the Same configurationoption. A dialog box appears that asks you to confirm the operation. Click OK
5.      Click Start Restore.

Restore a Web application in SharePoint 2010 using Windows PowerShell

  1. Open SharePoint 2010 Management Shell.
  2. At the Windows PowerShell command prompt, type the following command:

Restore-SPFarm -Directory <BackupFolderName> -RestoreMethod Overwrite -Item  <WebApplicationName> [-BackupId <GUID>] [-Verbose]

3.      If you do not specify the value of the BackupID parameter, the most recent backup will be used.
4.      You cannot restore a Web application by using a configuration-only backup.
5.      You can view the backups for the farm by typing the following

Get-SPBackupHistory -Directory <BackupFolderName> -ShowBackup

Restore a site collection using Windows PowerShell in SharePoint 2010

1.      Open SharePoint 2010 Management Shell.
2.      At the Windows PowerShell command prompt
3.      Type the following command, and then press ENTER:
Restore-SPSite -Identity <Site collection URL> -Path <Backup file> [-DatabaseServer <Database server name>] [-DatabaseName <Content database name>] [-HostHeader <Host header>] [-Force] [-GradualDelete] [-Verbose]
4.      If you want to restore the site collection to a specific content database, use the DatabaseServer and DatabaseName parameters to specify the content database.
5.      If you do not specify a content database, the site collection will be restored to a content database chosen by Microsoft SharePoint Server 2010.
6.      If you are restoring a host-named site collection, use the Identity parameter to specify the URL and use the HostHeader parameter to specify the URL of the Web application that will hold the host-named site collection.
7.      If you want to overwrite an existing site collection, use the Force parameter.

Sunday, June 10, 2012

Restore databases instantly

When disaster strikes, it can take hours to restore a database from backup. New SQL safe withinstant restore technology makes it possible to bring a database back on-line in minutes, not hours. With SQL safe instant restore, you can:
SQL safe screenshot
Virtually eliminate costly application down-time
Avoid impacting end-user productivity
Maintain database availability while the full restore completes in the background
Plus, SQL safe delivers fast, compressed backups (up to 95% compression!) so you can save time and storage space. Learn more.
Download a free 14-day trial now

Friday, June 8, 2012

How to configure usage reporting in SharePoint ?

Before you enable usage reporting in a SSP, you have to first enable Windows SharePoint Services usage logging for the farm hosting the Web application containing the SSP.
Use the following procedure to enable usage logging for the farm.

Enable usage logging for the farm
1.      On the Central Administration home page, click Operations.
2.      On the Operations page, in the Logging and Reporting section, click Usage analysis processing.
3.      On the Usage Analysis Processing page, in the Logging Settings section, select Enable logging.
4.      Type a log file location and number of log files to create.
5.      In the Processing Settings section, select Enable usage analysis processing, and then select a time to run usage processing.
6.      Click OK.

Enable usage reporting
1        On the SSP home page, in the Office SharePoint Usage Reportingsection, click Usage reporting.
2        On the Configure Advanced Usage Analysis Processing page, in the Processing Settings section, click Enable advanced usage analysis processing.
3        In the Search Query Loggingsection, select Enable search query logging.
4        Click OK.

Activate usage reporting
After usage reporting is enabled for the SSP, site collection administrators must activate the reporting feature. Until the reporting feature is activated on a site collection, usage reports are not available.
Use the following procedure to activate the reporting feature.

1        On the Site Actionsmenu, click Site Settings.
2        On the Site Settings page,in the Site Collection Administrationsection, click Site collection features.
3        On the Site Collection Features page, click the Activatebutton for the Reporting feature.