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.

Filter by
Sorted by
Tagged with
1 vote
1 answer
11 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 ...
Hayat Mazyad Dabjan's user avatar
0 votes
1 answer
36 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 ...
Pankaj Dalvi's user avatar
0 votes
1 answer
32 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 ...
Pankaj Dalvi's user avatar
1 vote
3 answers
482 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.
Pedro Henrique Silva's user avatar
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 ...
Tyler Walton's user avatar
0 votes
1 answer
244 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 ...
Saz Mifsud's user avatar
2 votes
2 answers
494 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, ...
Fabio's user avatar
  • 580
0 votes
1 answer
59 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-...
PhilFancy's user avatar
  • 1,107
0 votes
1 answer
377 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 ...
Burre Ifort's user avatar
  • 1,337
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?
Denise's user avatar
  • 405
3 votes
1 answer
963 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 '...
synthesis's user avatar
  • 103
1 vote
1 answer
29 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. ...
Echo Train's user avatar
2 votes
1 answer
1k 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 ...
Syntax Error's user avatar
0 votes
1 answer
77 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. ...
spex5's user avatar
  • 808
1 vote
1 answer
129 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 ...
Maureen's user avatar
  • 697
1 vote
1 answer
2k views

SharePoint 2010 Content DB rapidly increasing in Size

SharePoint Health Analyzer rule detected the unused free space in WSS_Content Database, so to free up the space I had to shrink the Database. Before shrinking, the size of content DB was 259 GB. After ...
Bhargava's user avatar
  • 135
1 vote
1 answer
182 views

How can I control a content database size in sharepoint 2013

My case is I have one web application which has only one site collection, for example, http://examplesite . This site collection has a content database, for example, wss_content. Then I created a new ...
XHM's user avatar
  • 133
1 vote
1 answer
177 views

Any possible problems when migrating SharePoint 2007 databases from SQL 2005 to 2012

Due to SQL Server 2005 EOL, we plan to migrate all SharePoint 2007 and 2010 content databases to SQL Server 2012 (or SQL 2008). I wonder if it will be safe to migrate, and any possible points to be ...
ExceptionalException's user avatar
0 votes
1 answer
931 views

Changing SharePoint Database and File location!

I create a SharePoint 2013 environment with SQL 2012. Issue is that SQL is installed on the OS driver (C drive). Now we want to move the location of SQL database and Log File from OS drive to Other ...
cjs's user avatar
  • 1,204
0 votes
2 answers
4k views

Using SQL Alias to change Database Server name for SP2013 Farm

I need a temporary workaround, I have a farm SharePoint configured and running, it's pointing to DNS name of a Database Server, let's say server01.domain.com. I need the farm to point temporarily to ...
Mafalda89's user avatar
  • 127
0 votes
0 answers
142 views

STSADM.EXE -o restore options

I'm moving some moss databases from one database server to a new one. I've been following the steps outlined in this technet On step 13. Restore an SSP to the new location. I'm coming across some ...
spex5's user avatar
  • 808
1 vote
1 answer
5k views

How to bring down/reduce the SharePoint DB Server memory usage?

For our SharePoint 2013 application, we are using 2 Web Servers 2 APP 2 DB One of the DB server memory usage is about 78%. (Windows Server 2012 with 16 GB RAM, where sqlserver.exe takes upto 9 GB) ...
Manivannan Nagarajan's user avatar
0 votes
3 answers
253 views

SharePoint SQL Server Databases are "Suspect" on every shutdown or reboot

I'll use this article: http://sharepointchips.com/recover-sharepoint-2013-databases-from-suspect-mode/ As a reference point. What is happening is as described in the article, my SharePoint 2013 SP1 ...
tekiegreg's user avatar
  • 1,671
0 votes
1 answer
294 views

Business Connectivity Services vs. ADO.NET

Why should I prefer Business Connectivity Services (BCS) over plain ADO.NET, if all I want are simple CRUD operations on an external database (e.g. remote Oracle Database), which are made from a ...
Tom Bola's user avatar
  • 381
2 votes
1 answer
2k views

How to auto truncate transaction log of SharePoint Database?

We need to auto truncate the transaction log of SharePoint Database in our server as it gets full and as a result it does not accommodate any data further received from the lists. Hence, need how to ...
Priyanka Rajput's user avatar
3 votes
2 answers
61 views

Migrated 2010 Databases, but some DBs can no longer be pointed to due to alias

Here's our scenario. We successfully migrated our SharePoint 2010 Foundation databases to another server using this method and this article. The key point is that we set up an alias from our existing ...
Alex's user avatar
  • 1,089
1 vote
2 answers
9k views

moving content db for a site collection to another db server

Is it possible to move a content database from one db server to another db server? I read an an article stating it's not possible you can move contend db within the same database server. Can anyone ...
Maria Burton's user avatar
  • 1,242