9
votes
SQL Server 2016 as a Database Server for SharePoint 2010
It is not supported, sharepoint 2010 is not supported on even Microsoft SQL Server 2014.
If you read the software requirement MSFT give the equation which help to determine awl version support.
In ...
7
votes
Accepted
How to check if my SharePoint SQL server is a SharePoint web front end?
The service which makes a SharePoint server web front end is Microsoft SharePoint Foundation Web Application service. If it is started in a server, it becomes web front end.
The services will be ...
7
votes
Accepted
Is SharePoint 2016 & SharePoint 2019 supports SQL Server 2017 developer edition as backend SQL Server
Yes, SharePoint 2016 and SharePoint 2019 support SQL Server 2017 Developer Edition only for non-production use.
Check also
Supported SQL Server Version for SharePoint 2016
SQL Server Best Practices ...
6
votes
IS SharePoint 2007 compatible with SQL 2008 SP3?
Yes, It's compatible. Just make sure you use MOSS SharePoint Service Pack 3, and you should be just fine.
Also there's no difference to SharePoint concern whether you use SP2 or SP3 on the SQL Server....
5
votes
Request timeout error in large list
You can use
Caching a DataTable Object
The code in these examples suspends all other threads in a critical section running in IIS, and prevents other threads from accessing the cached object ...
5
votes
Is Sharepoint the right platform for my use-case?
1. A calendar that, when a user logs in, is filled with courses that the user is currently signed up for. The information is contained within a SQL database we keep on-prem (The server itself is ...
5
votes
As a Sharepoint Administrator, what I need to do during a SQL maintenance?
I agree with Trevor that you don't have to do anything however, generally if the SQL servers are going to be offline, it's a good idea to shut the SharePoint servers down before SQL goes offline and ...
4
votes
Accepted
Shared server farm: Possible to connect SharePoint 2010 local farm to Amazon EC2 SQL Server?
It is possible but it is not supported( if not meet the requirement). Your topology falls under the stretched farm which has very high requirement.
There is a highly consistent intra-farm latency of &...
4
votes
SQL Server Patching Impact on Sharepoint
I would install a new SQL Server to the level that you require, such as SQL Server 2008 R2. Tehn I would backup from source SQL and restore to destination SQL, with the same permissions and settings ...
4
votes
Accepted
SQL Server Patching Impact on Sharepoint
SharePoint 2010 is supported on SQL 20018 R2 SP3, so no, there shouldn't be any issue installing the service pack onto your SQL Server.
I'd test (if at all possible) on a test system first, simply to ...
4
votes
File location of a document in a document library
I think you answered your own question:
I see all of the documents in the database associated with the website
That's correct - the documents in a SharePoint document library are stored in the ...
4
votes
Accepted
IS SharePoint 2007 compatible with SQL 2008 SP3?
Yes, SharePoint 2007 is compatible with SQL Server 2008 Service Pack 3.
As your link covered the "Supported Combinations of SharePoint and Reporting Services Components", I'm assuming you are after ...
3
votes
Accepted
Is there any risks of upgrading our SQL server 2008 R2 from SP2 to SP2
There is no risk to applying the SP3 on the SQL server 2008. But you have to plan it.I would apply the patches in the following order.
Schedule a Downtime for the SharePoint
I will stop the IIS & ...
3
votes
Accepted
Get error after content database restore to another server
I resolved this problem, after restore content database and create web application, Mount restore content database to new web application.
Mount-SPContentDatabase "MyDatabase" -DatabaseServer "...
3
votes
SSRS & SharePoint 2013
Does SSRS need to be installed on a separate server in a SharePoint 2013 production Farm?
From Performance perspective , it's recommended to install SSRS SharePoint integrated mode to a sperate ...
3
votes
Is there any real benefit to upgrade a SharePoint 2013 Enterprise Farm from SQL Server 2014 to SQL Server 2016?
As far I know, Sql server 2016 is not supported with sharepoint 2013.
At this time, SQL Server 2016 RTM is not supported.
https://technet.microsoft.com/en-us/library/cc262485.aspx#section4
3
votes
Accepted
How to Flush Crawl Database Sharepoint 2013
You had to set the Recovery-Model of the Database to "FULL" to successfully implement AlwaysOn. RecoveryModel FULL also means, that the TransactionLog never gets cleared unless you do a TransactionLog-...
3
votes
Accepted
No help collection was found
1st you have to make sure the cab Files Exits.TO Check
go to the following path C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\15\HCCab\1033\ and make sure you have the cab ...
3
votes
How to proceed for Installation of SharePoint Server 2013
Look at this post concerning SharePoint 2013 requirements : Minimum real world requirements for SP2013
You should go for Windows Server 2008 R2 + SQL Server 2008 R2 that are a bit lighter than the ...
3
votes
Accepted
Prerequisites for content migration on MOSS 2007 SQL Express to SharePoint Enterprise 2013?
Given that you're aware of the necessity of the SharePoint 2010 intermediary farm, there are no "extra" steps involved specifically related to a migration from an Express edition to a Server edition ...
3
votes
SQL Server Patching Impact on Sharepoint
Upgrading / Patching of SQL server is not big issue as compare to patching the SharePoint server. You have to plan it properly.
First thing, you have to apply the patches in lower environment and ...
3
votes
Accepted
How to setup DR on SP2010 with SQL mirroring without witness?
I did not clearly get what you are trying to achieve. You have to distinguish between HighAvailability (HA) and DesasterRecovery (DR).
Important word in advance: Not SharePoint decides to bring ...
3
votes
Can there be two SharePoint 2016 Farms on same SQL Server?
If you are planning to do this, create separate SQL instances for each farm. I personally have run into issues with clients having two farms on one instance and not being able to quickly determine ...
3
votes
Accepted
Does SharePoint 2013 supports sql server 2016 or not
SharePoint 2013 will never be supported on SQL 2016. (with the exception of SSRS integration, keep reading for that).
SharePoint support generally works in the following way. A SharePoint release ...
3
votes
Accepted
Database server for SharePoint 2019
As a short answer, Yes SharePoint 2019 supports SQL Server 2016 with SP2.
As mentioned at the Hardware and software requirements for SharePoint Server 2019 documentation
The Minimum requirements ...
Only top scored, non community-wiki answers of a minimum length are eligible
Related Tags
sql-server × 499sharepoint-enterprise × 103
sharepoint-server × 94
2013 × 63
2010 × 45
sharepoint-foundation × 35
database × 29
content-database × 26
sharepoint-online × 25
sql × 25
2007 × 24
backup × 23
sharepoint-designer × 21
list × 21
reporting-services × 21
external-content-type × 19
development × 17
powershell × 17
2016 × 17
bcs × 16
migration × 15
installation × 14
infopath × 13
remote-blob-storage × 13
restore × 12