Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

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.

1
vote
3answers
59 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 ...
0
votes
1answer
35 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 ...
2
votes
2answers
134 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, ...
0
votes
1answer
49 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-...
0
votes
1answer
91 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 ...
2
votes
3answers
323 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?
3
votes
1answer
538 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 '...
1
vote
1answer
22 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. ...
2
votes
1answer
445 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 ...
0
votes
1answer
62 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. ...
1
vote
1answer
89 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 ...
1
vote
1answer
1k 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 ...
1
vote
1answer
129 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 ...
1
vote
1answer
161 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 ...
0
votes
1answer
606 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 ...
0
votes
2answers
3k 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 ...
0
votes
0answers
57 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 ...
1
vote
1answer
4k 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) ...
0
votes
3answers
205 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 ...
0
votes
1answer
283 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 ...
3
votes
1answer
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 ...
3
votes
2answers
59 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 ...
1
vote
2answers
8k 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 ...