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 ...
Waqas Sarwar MVP's user avatar
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 ...
P S's user avatar
  • 4,827
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 ...
Mohamed El-Qassas MVP's user avatar
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....
Benny Skogberg's user avatar
  • 25.5k
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 ...
Lugube's user avatar
  • 51
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 ...
Cornelius J. van Dyk's user avatar
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 &...
Waqas Sarwar MVP's user avatar
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 ...
Benny Skogberg's user avatar
  • 25.5k
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 ...
Andy Dawson's user avatar
  • 1,895
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 ...
Dylan Cristy's user avatar
  • 12.7k
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 ...
moe's user avatar
  • 5,267
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
Waqas Sarwar MVP's user avatar
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 ...
Mohamed El-Qassas MVP's user avatar
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 & ...
Waqas Sarwar MVP's user avatar
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-...
MHeld's user avatar
  • 5,123
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 ...
Waqas Sarwar MVP's user avatar
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 ...
Jack's user avatar
  • 31
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 ...
Ornery Walrus's user avatar
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 ...
Waqas Sarwar MVP's user avatar
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 ...
MHeld's user avatar
  • 5,123
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 ...
Mike's user avatar
  • 12.2k
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 ...
Waqas Sarwar MVP's user avatar
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 ...
Mohamed El-Qassas MVP's user avatar
3 votes
Accepted

What negative impact can occur if I detach a Sharepoint content database file location via SQL?

Once you detach the MDF file, SharePoint will unable to access the Database and throws the error (login failed for the app pool account or no data found or 404 error). all the site collections in that ...
Waqas Sarwar MVP's user avatar
3 votes
Accepted

uninstall SQL server 2008 r2 from SharePoint 2013 server

If the SQL server 2008 r2 is not connected to the SharePoint 2013 farm , it will not affect the sharepoint 2013 farm when you uninstall the SQL server 2008 r2 from the SharePoint server. You could ...
Amy_MSFT's user avatar
  • 2,956

Only top scored, non community-wiki answers of a minimum length are eligible