Though the whole SharePoint Server or a whole portal site is selected for backup, only a site-collection level of backup will be done. Hence, to restore all the site-collections under a portal site, you need to restore the site-collections under that portal site one by one using STSADM.EXE. Scheduling - which tool are you more comfortable creating a scheduling mechanism for backups with: PowerShell and Scheduled Tasks in the case of SharePoint backups and Maintenance Plans (or your existing SQL Server backup tool) in the case of SQL Server. If you already have a backup tool for SQL Server it may make more sense to integrate into. SharePoint Server supports the following primary, built-in recovery options: Restore from a farm backup that was created by using built-in tools. Restore from the backup of a component taken by using the farm backup system. Restore from a site collection backup. It is important to back up and restore the data on the SharePoint Portal Server 2001 computer to another computer before upgrading to SharePoint Portal Server. This computer must have the same version of SharePoint Portal Server 2001, including service packs, updates, and language packs.
- Sharepoint Portal Server Backup Restore Tool Windows 10
- Backup A Sharepoint Site
- Microsoft Sharepoint Backup
- Backup And Restore Sharepoint Site
- Backup Sharepoint Online
- Sharepoint Portal Server Backup Restore Tools
SharePoint users often experience failure or crash due to various reasons. Such an inappropriate action certainly causes corruption in the SharePoint database. You can’t open or access a corrupt database file until you repair it. In a case of severe corruption, repairing the database might be challenging. In such a situation, you must use a smart SharePoint Server Recovery tool to restore SharePoint Server data.
Microsoft SharePoint Server
Microsoft SharePoint is a popular web-based application integrated with the Microsoft Office suite. It was first launched in 2001, and it has been commonly using for document management and storage system since then. SharePoint is highly popular among large customer/consumer organizations. Such organizations use SharePoint to create websites.
You can use SharePoint as a secure place where you can store crucial/confidential data and information. Also, you can organize, share and access the stored information from any device (almost all). The only thing what you actually need is a web browser; you can use any like Internet Explorer, Chrome or Firefox.
Microsoft SharePoint provides different editions which have different functions: SharePoint Server, SharePoint Standard, SharePoint Enterprise, and SharePoint Online. Here in this post, we’ll discuss the most common reasons for corruption in SharePoint Server. Also, we’ll learn how to repair SharePoint database and perform SharePoint Server recovery.
Some common SharePoint benefits are:
- Microsoft SharePoint Server allows users to create online content such as web pages, wiki’s, blogs, etc.
- Microsoft SharePoint Server helps you manage and control the entire content of your business. If you’re running a business, you must know how painful security violation or hacking can be as it may put your invaluable data at high risk. Such action can definitely cause a great deal of damage/loss to the company. SharePoint Server contains various tools which help you track the online content and streamline various business processes with ease.
- Microsoft SharePoint Server has an ability to organize documents and edit them quickly and easily. There are a number of different criteria to organize documents in SharePoint. Also, collaborative editing is possible using the applications available with the software.
- You can also use SharePoint platform to access documents and workspaces which you need to share with a number of individuals, such as databases, commonly used forms, etc.
Though SharePoint Server has many advantages, on the other hand, you may experience some serious issues like Server crash and corruption.
Corruption in SharePoint Server
Mistake #1 –SharePoint has low RAM or hard disk space
SharePoint Server works as hard as possible to keep its users happy, although it has limited resources. If it has low RAM or hard disk space, it causes serious issues to users. Due to low RAM or disk space, it starts shutting off the functionalities in order to get fit into the available space. Also, it starts caching less in the web application pools and recycles them more often. Since SharePoint must compile the same ASP.NET code persistently, actions of less caching and more recycling will result in degraded end-user experience.
Solution: The easiest solution to resolve this issue is to add more RAM. Also, make sure you’re having enough free space on your hard disk, especially on C Drive.
Mistake #2 –Use of virtualized Microsoft SQL Server
Though virtualization is not bad, make sure you do that very smartly without sacrificing the ability of SharePoint Server. But sometimes aggressive virtualization may cause serious issues. It allows administrators to make mistakes on a huge level. Just for an example, you’re using virtualized MS SQL Server. Sometimes the action of virtualizing SQL Server starts over-committing the host through RAM, CPU, or hard disk space. Since everything of SharePoint is stored in SQL Server, slow SQL Server will cause slow SharePoint.
Solution: The obvious solution to resolve this issue is to move the SQL Server to a physical box so that there’s no need to share resources. It’s all easy to move SharePoint’s SQL Server instance.
Mistake #3 – Incorrect URL during Content Web App’s creation
Generally, SharePoint Server and Microsoft Internet Information Services (IIS), formerly known as Internet Information Server, face communication problems. When you make any changes to a web app, there’s no way for SharePoint to tell IIS about this change after its creation. Just for an example, you create an Alternate Access Mapping (AAM) for a web app in Central Administration. You’re not done yet. You still need to go to AAM to add the host header to the new address. Generally, SharePoint administrators give their web apps short URLs like https://portal, in order to avoid more typing. Since the web app needs a fully qualified URL, such short URLs fail to route across the Internet. Though it’s not that big deal, sometimes it may cause serious problems.
Solution: Make notes of all your web app settings. Avoid using short incorrect URLs. Make sure you enter the correct, fully qualified URL in the Host Header box.
Mistake #4 – Running Web or Service Apps in separate App Pools
An application pool runs Web apps and other service applications inside it. It’s a W3WP.exe process that runs on your SharePoint Server. Make sure you run all SharePoint web apps inside one application pool. And the very same thing goes for service applications as well. Using multiple application pools will cache the same content multiple times. If you run each web app in its own application pool, it makes inefficient use of the Server’s memory for sure. Sometimes it may cause some serious problems.
Solution: The best way to resolve this problem is to run web and service apps in a single app pool so that Server consumes less memory.
Mistake #5 – Use of single account for almost everything
Security is always complicated, even in SharePoint Server. Using a single account for everything looks okay, but many of you don’t know it’s a bad idea. Why? If you’re using a single account, this may cause several security issues in SharePoint Server. How? Anyone who knows your account password can make unnecessary changes to SharePoint Server. Also, you can’t verify what changes have been made and by whom. And if you change the password of that single account more than often, this may put SharePoint’s uptime at high risk.
Solution: First of all, avoid using a single account for everything in SharePoint Server. Don’t forget to add the sp_webapps and sp_serviceapps accounts as managed accounts. On the Search Service Application page, you can change the default content access account for the Search service application. Also, you can change the accounts which are used by other processes as well (Under Central Administration, Security, Configure Service Accounts).
Mistake #6 – Enable default SharePoint database settings
Keeping default settings for SharePoint database might be risky sometimes. When SharePoint Server starts creating its multitudes of databases, it may cause some severe issues. Just for an example, if you enable the “autogrow” setting option, this will let the database files grow by 1 MB. This means with every upload, the database files will auto-grow. It can slow down SQL Server as well as SharePoint. Also, it may cause some issues in database files which are spread all over the drives in small parts (1 MB).
SharePoint creates most of its databases (especially Config and Content) with the recovery model set to Full by default. Although it’s helpful in recovering data, you must manage this whole process correctly. Otherwise, those LDF files will fill your hard disk slowly. When SQL Drives are full, SharePoint stops completely or starts crashing frequently.
Solution: To resolve this issue, you can set the “autogrow” setting in such a way that doesn’t let the database files grow frequently. It’s strongly recommended that you should change the auto-grow setting from 1 MB to 500 MB or 1 GB. Also, make sure that your recovery model setting is consistent with your disaster recovery plans.
Mistake #7 – Use of Farm Configuration Wizard
Sometimes using the Farm Configuration Wizard may cause some serious issues. All the database files created by Farm Configuration Wizard, contain bad globally unique identifiers (GUIDs) at the end of their names. Also, it creates a content web app, at https://servername, which fails to scale well. The situation becomes much worse when the wizard creates your My Site host on that same web app, at https://servername/my.
Also, the wizard encourages you to create service applications which you may not use in actual. The Farm Configuration Wizard can create a mess on SharePoint, and it may become a challenge to fix that.
Solution: To resolve the issues caused by Farm Configuration Wizard, you can take the following measures:
- First, you should start with your web apps – Create a web app for My Site and provide a fully-qualified domain name(FQDN), such as mysites.company.com. Now create a host, My Site, at the web app’s root. Move any My Site to one content database by using Windows PowerShellcmdlet Move-SPSite. After that, attach this content database to your new web app. Also, you need to adjust your User Profile Service in order to tell your new My Site location.
- Clean up your service applications – Go to your list of service applications and delete/remove those which you don’t use anymore. There’s no need to keep the service applications which you aren’t going to use for another six months. Once you successfully delete/remove all the unnecessary service applications, you should stop the associated service instances. If it’s possible to remove the GUIDs from the service application database names, then do that.
Mistake #8 – Disable Blob caching
Should SharePoint work slow or fast? What do you think? Most of us want SharePoint to get files to the users as quickly as possible, and BLOB caching plays an important role in that. It’s one of the easiest and least expensive ways which can help you improve SharePoint performance. But if the BLOB caching is disabled, you may come across to some serious issues related to SharePoint performance.
Solution: Make sure the BLOB caching is enabled because it helps SharePoint to get files to users more quickly, Also, it eases the burden on SQL Server.
Mistake #9 – SharePoint Server doesn’t point at itself
If SharePoint is working perfectly, it’s great for users. But if it doesn’t work due to any reason, it’s not less than a nightmare for anyone. Therefore, troubleshooting in a timely manner becomes mandatory. Make sure that every server in the SharePoint farm is pointing to itself for all web apps instead of pointing to others. It’s highly beneficial. How? If sometimes SharePoint fails to respond, you can easily use Remote Desktop Protocol (RDP) to log in to each server and try to fix SharePoint. There’s one more advantage of pointing Search index at itself. It can improve SharePoint’s performance.
Solution: The only fix for this problem is to point your Search indexer at itself. This will help you get the correct LOG files quickly. And the more quickly you get the LOG files, the more quickly you can resolve the errors.
Mistake #10 – No use of PDF iFilter
In most organizations, SharePoint stores a large number of PDF files containing invaluable information. Users are able to access the information stored in PDF files via SharePoint Search. Generally, SharePoint Server is a great way to get users excited about SharePoint. You must install PDF iFilter, it’s easy and very useful. Adobe provides a free PDF iFilter which you can use here. Make sure you install iFilter only on those SharePoint Servers which run the Search Index role. But if you don’t use any PDF iFilter, this may cause serious troubles.
Solution: The only possible solution to this problem is PDF iFilter. Make sure you’re using PDF iFilter. If you have a large farm in SharePoint and you want to reduce the time needed to index PDF files, you should try PDF iFilter provided by Foxit. It’s better than Adobe iFilter and provides you excellent performance (but it’s not a freeware).
Aforementioned reasons cause failure in SharePoint Server and lead to corruption in its database. You’re lucky if you have the backup. Backup has the ability to restore what you lost due to accidental deletion or corruption. Also, you can create a new database with the backup at the time of SharePoint Server failure or crash. This is the main reason why backup is strongly recommended by computer experts and professional users. Don’t forget to take backup of your data. Also, do practice your restore procedures regularly even before you actually need to. Refer to this article to know how to backup and restore SharePoint.
Interested users may find this useful – Repair SQL Database File Via SQL Server Management Studio
Fix SharePoint Server corruption manually
In case you don’t have any backup, you’re in deep trouble. Fortunately, SharePoint Server 2010 provides you a feature to restore the configuration database and thus you can restore the farm configuration. And if you’re using SharePoint Server 2013 or 2016, you have no need to restore configuration database since you can directly restore farm configuration.
Important note: Before you can restore farm configuration, make sure:
- You must be the member of the Farm Administrators group on the system, which is running the Central Administration.
- Also, you must have permissions for the sysadmin server role on the database server, which contains all the databases.
Follow the points given below:
Step #1: First of all, go to Central Administration’s home page. Now click Restore from a backup in the Backup and Restore section.
Step #2: On the “Restore from Backup” screen, choose Backup to Restore page. Now select the backup job and click Next to continue the process.
Step #3: Choose Component to Restore page, and click the checkbox shown next to the farm. Click Next to continue the process.
Step #4: In the “Restore Component” section, choose Restore Options page from Restore from Backup option. Make sure the Farm appears in Restore the following content listing.
Step #5: In the “Restore Only Configuration Settings” part, make sure that Restore content and configuration settings preference is selected.
Step #6: Choose Type of Restore preference in the Restore Options section. Use Same configuration settings. Click OK button to confirm this operation. Then click Start Restore option.
You can see the status of all SharePoint repair jobs.
Professional SharePoint Server Recovery Software
Unluckily if you fail to restore farm configuration manually, there’s an effective way to perform SharePoint Server recovery via a professional recovery solution. You must try something that can restore SharePoint Server data from the MDF database. There are many software vendors in the market which provide professional recovery solutions for SharePoint Server. Download free SharePoint Server Recovery software to recover SharePoint data without causing any alteration or modification to their originality.
Important note: I strongly recommend my readers to evaluate the SharePoint Server Recovery software before purchasing its licensed version. Download its free demo version first to see what you can possibly recover from the database. If you’re satisfied with the results, then only you should purchase the licensed version of SharePoint Server Recovery software.
What you get in this SharePoint Server Recovery software:
- Smart support for Complete Database Recovery or Document Recovery;
- Intensive scanning of the corrupt database in just no time;
- Dual recovery modes, standard and advanced for handling the different level of corruption;
- Define collation type for the selected database before the recovery process;
- Tree-structure preview of recovered database objects before saving them;
- Easy-to-use application, i.e. it requires no prior technical expertise for SharePoint Server recovery.
Watch the online video tutorial below
-->You can back up a Search service application in a farm by using the SharePoint Central Administration website, Microsoft PowerShell, or SQL Server tools. Which backup tool you use depends on what kind of environment you have deployed, what your backup schedule requires, and what service level agreements you have made with your organization.
Before you begin
Sharepoint Portal Server Backup Restore Tool Windows 10
We recommend that you regularly back up at the farm level. However, business or IT requirements might require you to back up the search service and related resources. Regularly backing up the search system reduces the possibility of data losses that might occur from hardware failures, power outages, or other problems. It is a simple process that helps make sure that data and configurations that compose the search system are available for recovery, if that is required.
Before you begin this operation, review the following information:
You must create a folder on the local computer or the network in which to store the backups. For better performance, we recommend that you back up to the local computer and then move the backup files to a network folder.
You cannot use SQL Server tools or Data Protection Manager to back up all of the search components.
Backing up search does not affect the state of the farm. However, it does require resources. Therefore, backing up search might affect farm performance while the backup is running. You can avoid performance issues by backing up search during hours when farm use is lowest.
Back up a thesaurus file
Backup A Sharepoint Site
Thesaurus files are used to specify synonyms for words or phrases that occur in search queries. You create and maintain the thesaurus files in systems external to SharePoint Server before you import them into SharePoint Server to make them available to the search system. The thesaurus files are therefore not included in the SharePoint Server search backup procedures outlined below.
To back up your thesaurus files, you need to make sure that they are included in the backup procedures for the external system you are using to create and maintain the thesaurus files.
Use PowerShell to back up search in SharePoint Server
You can use PowerShell to back up search manually or as part of a script that can be run at scheduled intervals. This procedure backs up all of the search components including the databases, the search service configuration, and all of the index files.
To back up search by using PowerShell
Verify that you have the following memberships:
securityadmin fixed server role on the SQL Server instance.
db_owner fixed database role on all databases that are to be updated.
Administrators group on the server on which you are running the PowerShell cmdlets.
Farm Administrators SharePoint group.
An administrator can use the Add-SPShellAdmin cmdlet to grant permissions to use SharePoint Server Products cmdlets.
Note
If you do not have permissions, contact your Setup administrator or SQL Server administrator to request permissions. For additional information about PowerShell permissions, see Add-SPShellAdmin.
Start the SharePoint Management Shell.
At the PowerShell command prompt, type the following command:
Where:
<BackupFolder> is the path of the folder that you use for storing backup files.
<SearchServiceApplicationName> is the name of the Search service application that you are backing up.
Note
If you are backing up the farm for the first time, you must use the Full option. You must perform a full backup before you can perform a differential backup. To view the progress of the backup operation, use the Verbose parameter. The Differential option only applies to the search databases. The search index files are always fully backed up, even when you use the Differential option.
For more information, see Backup-SPFarm.
Note
We recommend that you use Microsoft PowerShell when performing command-line administrative tasks. The Stsadm command-line tool has been deprecated, but is included to support compatibility with previous product versions.
Use Central Administration to back up search in SharePoint Server
You can use Central Administration to back up search. This procedure backs up all of the search components including the databases, the search service configuration, and all of the index files.
To back up search by using Central Administration
Verify that the user account that is performing this procedure is a member of the Farm Administrators SharePoint group.
Start Central Administration.
In Central Administration, on the home page, in the Backup and Restore section, click Perform a backup.
On the Perform a Backup — Step 1 of 2: Select Component to Back Up page, in the list of components, expand Shared Services and then expand Shared Services Applications to view the list of service applications in the farm. Select the search service application from the list of components, and then click Next.
Note
The search service application might consist of several components. You must select the top-level component. By default, the service application is named 'Search Service Application'.
On the Start Backup — Step 2 of 2: Select Backup Options page, in the Backup Type section, select either Full or Differential.
Note
If you are backing up search for the first time, you must use the Full option. You must perform a full backup before you can perform a differential backup. The Differential option only applies to the search databases. The search index files are always fully backed up, even when you use the Differential option.
In the Backup File Location section, in the Backup location box, type the path of the backup folder, and then click Start Backup.
You can view the general status of all backup jobs at the top of the Backup and Restore Job Status page in the Readiness section. You can view the status for the current backup job in the lower part of the page in the Backup section. 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 might take several seconds for the backup to start.
If you receive any errors, you can review them in the Failure Message column of the Backup and Restore Job Status page. You can also find more details in the Spbackup.log file at the UNC path that you specified in step 6.
Use SQL Server tools to back up search
You cannot back up the complete SharePoint Search service application by using SQL Server tools. However, you can use SQL Server tools to back up the databases that are associated with the Search service application. To back up the complete Search service application, use either PowerShell or Central Administration.
To use SQL Server to back up the databases that are associated with the Search service application, you must follow these steps:
Pause the Search service application.
Back up all the Search service application databases with SQL Server tools.
Resume the Search service application.
To pause the Search service application by using PowerShell
Verify that you have the following memberships:
securityadmin fixed server role on the SQL Server instance.
db_owner fixed database role on all databases that are to be updated.
Administrators group on the server on which you are running the PowerShell cmdlets.
An administrator can use the Add-SPShellAdmin cmdlet to grant permissions to use SharePoint 2016 cmdlets.
Note
If you do not have permissions, contact your Setup administrator or SQL Server administrator to request permissions. For additional information about PowerShell permissions, see Add-SPShellAdmin.
Start the SharePoint Management Shell.
At the PowerShell command prompt, type the following command:
Where:
- <SearchServiceApplicationName> is the name of the Search service application that you are backing up.
Microsoft Sharepoint Backup
To back up all the Search service application databases by using SQL Server tools
Verify that the user account that is performing this procedure is a member of the SQL Server db_backupoperator fixed database role on the database server where each database is stored.
Start SQL Server Management Studio and connect to the database server.
In Object Explorer, expand Databases.
Right-click the database that you want to back up, point to Tasks, and then click Back Up.
In the Back Up Database dialog, confirm the database name.
Next, select the kind of backup that you want to perform from the Backup type list. For more information about which backup type to use, see Recovery Models (SQL Server).
In the Backup component area, click Database.
Either use the default name that is provided or specify a name for the backup set in the Name text box.
In the Destination area, specify where you want to store the backup.
Click OK to back up the database.
Repeat steps 1-10 for the following databases:
Backup And Restore Sharepoint Site
Search Administration
Analytics Reporting
Crawl
Link
To resume the Search service application by using PowerShell
- Verify that you have the following memberships:
securityadmin fixed server role on the SQL Server instance.
db_owner fixed database role on all databases that are to be updated.
Administrators group on the server on which you are running the PowerShell cmdlets.
An administrator can use the Add-SPShellAdmin cmdlet to grant permissions to use SharePoint Server cmdlets.
Note
If you do not have permissions, contact your Setup administrator or SQL Server administrator to request permissions. For additional information about PowerShell permissions, see Add-SPShellAdmin.
Start the SharePoint Management Shell.
At the PowerShell command prompt, type the following command:
Where:
- <SearchServiceApplicationName> is the name of the Search service application.
Backup Sharepoint Online
See also
Sharepoint Portal Server Backup Restore Tools
Concepts