Questions tagged [database-server]
A server configured with a database administration role, such as SQL Server, that houses some or all of the databases used by SharePoint.
27 questions
1 vote
1 answer
17 views
create report from external big data at sql database at sharepoint 2016
I need to create a report from an external SQL database and run the report at SharePoint 2016. The SQL database size was big around 5 GB, How can I do it? I think to create a procedure at SQL database ...
0 votes
1 answer
54 views
External Application accessing a Sharepoint Server
I have a specific scenario, wherein I have an application built ASP.net MVC accessing a SharePoint server. Now my SharePoint server has a configuration where there are 2 Web Front End servers and 2 ...
- 53
0 votes
1 answer
47 views
Deploying application on with 2 Front End Server and 2 Database servers which are clustered
I have following questions with regards to multiple servers in Farm configuration. I want to create a web application , will it be created across both the Web Front End Servers? If I want to restore a ...
- 53
1 vote
2 answers
975 views
Sharepoint databases structure
I need to know how the structure of databases of Sharepoint works, what is any databases, when they are created and this kind of stuff... I'm using a Sharepoint 2016 on premises.
1 vote
3 answers
2k views
Sharepoint 2013 updating failure due to health usage log in mirroring mode
I have our environment setup where we aren't using health data logging however I continue to get messages that state that the health data database is in secondary mode when attempting to update. I get ...
- 21
0 votes
1 answer
489 views
change db server
What is the safest way to change SharePoint 2013 on premise DB Server from one name to another - I have alredy migrated all dbs from the old to the new I just want Sharepoint to now point to the new ...
- 301
2 votes
2 answers
530 views
Always on or fail over cluster in SP 2016 why?
I have a task to install SP 2016 farm 2 DB server, 2 wfe and app server! The 2 database in one Data center, Which installation type should I use for database server, always on or fail over cluster, ...
- 580
0 votes
1 answer
78 views
Move all SharePoint Databases to new SQL Server
SharePoint databases are running in a instance SP16 on Microsoft SQL Server 2016 (SP1) on a Windows Server 2012 R2 Datacenter at the moment. SharePoint is installed with 4 machine MinRole WFE-APP-...
- 1,107
0 votes
1 answer
443 views
how to check if SharePoint content databases are corrupt?
I have SharePoint 2010 and would like to check if the databases are corrupt or not. Can someone tell me how can I do that either via powershell or T-SQL without making any modifications to the ...
- 1,360
2 votes
3 answers
1k views
How to change Sharepoint database size?
Currently I'm facing an issue of insufficient size of my SharePoint database, and I need to edit the: Autogrowth of the db Maximum size file limit Where do I go to change these settings?
- 405
3 votes
1 answer
1k views
Installing SharePoint Server 2016 on a two-tier server farm
I am planning to install SharePoint Server 2016 on a two-tier server farm consisting of an Application Server and Database Server. While running the SharePoint Products Configuration Wizard, at the '...
- 103
1 vote
1 answer
46 views
SP2010 Database Server Shown in CA Not Found in Farm
Under 'Manage Content Database Settings' in Central Administration, where it says 'Database Information' on the left, is a name under 'Database server' on the right that I do not recognize, say DBCA. ...
- 23
2 votes
1 answer
2k views
Search_Service_Application_CrawlStoreDB size
Is it normal for the Search_Service_Application_CrawlStoreDB database to be ~185gb and Search_Service_Application_PropertyStoreDB to be 20gb (size of the mdf files, not counting any logs)? I feel this ...
- 254
0 votes
1 answer
99 views
Migrating SharePoint 2007 to servers on a new domain
I have 2 Moss 2007 SP3 (32 bit) servers on Server 2003 R2 (32 bit) that I would like to move to server 2008 r2 (64 bit) servers. There is one database server that will be upgraded to Server 2008 R2. ...
- 808
1 vote
1 answer
164 views
Are all databases updated when doing Cumulative Updates?
We are doing our first cumulative update on our SharePoint 2013 on-premise. I know that when doing an update the databases are also updated/modified. But in the interest of backups and storage, would ...
- 687