SharePoint Performance Monitoring with Idera SharePoint diagnostic manager

SharePoint Performance Monitoring with Idera SharePoint diagnostic manager

How to back up a User Profile Service application using SQL Server in SharePoint 2010 ?

• Open SQL Server Management Studio
• Connect to the database server.
• Expand Databases.
• Right-click the database that you want to back up, point to Tasks
• Then click Back Up.
• In the Back up Database dialog box,
• In the Source area, select the backup type that you want to perform
• User Profile Service application always requires a full backup, so select Full backup
• In the Backup component area, click Database.
• Provide the name to the backup
• We can set an expiration date to make this back up available till desired date.
• By default its 0, means no expiration date
• Provide the path where you want to store this back up under Destination
• That’s it we are done with user profile backup

A very good article available @ http://technet.microsoft.com/en-us/library/gg576965

Back up in SharePoint Server 2010

Backup in SharePoint 2010

Basically there are 3 types of backup methods used in SharePoint server 2010

·         Using Windows PowerShell

·         Using SharePoint 2010 Central Admin

·         Using SQL server

Use Windows PowerShell to back up a farm in SharePoint

You can use Windows PowerShell to back up the farm manually or as part of a script that can be run at scheduled intervals.

1.      Click on the Start menu

2.      Click All Programs.

3.      Click Microsoft SharePoint 2010 Products.

4.      Click SharePoint 2010 Management Shell.

5.      At the Windows PowerShell command prompt, type the following command: 

Backup-SPFarm -Directory <BackupFolder> -BackupMethod {Full | Differential} [-Verbose]

Use Central Administration to back up a farm in SharePoint

You can use Central Administration to back up the farm.

1.      In Central Administration, on the Home page > Backup and Restore > Perform a backup.

2.      On the Perform a Backup — Step 1 of 2: Select Component to Back Up page, select the farm from the list of components, and then click next.

3.      On the Start Backup — Step 2 of 2: Select Backup Options page, in the Backup Type section, select either Fullor Differential.

4.      In the Back Up Only Configuration Settings > Back up content and configuration settings.

5.      In the Backup File Location section, type the UNC path of the backup folder, and then click Start Backup.

6.      You can view the general status of all backup jobs at the top of the Backup and Restore Status page in the Readiness section. You can view the status for the current backup job

7.      in the lower part of the page in the Backupsection. The status page updates every 30 seconds automatically. You can manually update the status details by clicking Refresh. Backup and recovery are Timer service jobs. Therefore, it may take several seconds for the backup to start.

Use SQL Server tools to back up a farm in SharePoint

Using SQL server you can back up site content DB only, this is not useful when we have to take a full farm backup.

1.      Open SQL Server Management Studio

2.      Connect to the database server.

3.      Expand Databases

4.      Right-click the database that you want to back up, point to Tasks, and then click Back Up.

5.      In the Back Up Database dialog box, in the Sourcearea, select the kind of backup that you want to perform from the Backup typelist.

6.      In the Backup component > Database.

7.      Either use the default name provided or specify a name for the backup set in the Name text box.

8.      Specify the expiration date for the backup set. This date determines how long, or when, the backup set can be overwritten by any later backups that have the same name. By default, the backup set is set to never expire (0 days).

9.      In the Destination area, specify where you want to store the backup.

10.  Click OKto back up the database.

11.  Repeat steps 1-10 for each farm database.

Ref: http://technet.microsoft.com/en-us/library/ee428316.aspx

Configure managed accounts in SharePoint 2010

•  Open Central Administration and click Security.
•  Navigate to General Security > Configure managed accounts.

 

  

 

• On the Managed Accounts page > Register Managed Account.

• Enter the service account credentials in the Account Registration section
• Mark Enable automatic password change check box in the Automatic Password Change section
• Also select Start notifying by e-mail check box which will send email notification before automatic password change takes place

• Click OK.

Access Errors Publishing or Exporting to SharePoint when Attachment File Name is Invalid

Issue:

You receive one of the following errors when you attempt to export a Microsoft Access table to a SharePoint list:

There was an error copying data to a SharePoint list. The Microsoft Access database engine encountered an error while communicating with SharePoint. More detailed information: "

-OR-

There was an error copying data to a SharePoint list. Network I/O error.

You receive the following error when you attempt to publish a Microsoft Access 2010 database to a SharePoint Server:

Publish Failed. Your application has encountered errors while attempting to publish. The publish operation has failed and the target site has not been created.

When you click to view the details for the message, the first error entry is:

"There was an error uploading the data in the tables being created on the server. The Microsoft Access database engine encountered an error while communicating with SharePoint. More detailed information"

Resolution:

1. Open the table in datasheet view in Microsoft Access
2. Open the Attachments window
3. Select the file that contains the invalid characters
4. Click Save As.
5. Save to your desktop
6. Remove the file from the Attachments list
7. Click ok
8. Save the table
9. Rename the file you just exported to your desktop
10. Add the file back to the record

Ref: http://support.microsoft.com/kb/2711562