The Stack Overflow podcast is back! Listen to an interview with our new CEO.

Questions tagged [sharepoint]

Microsoft SharePoint is a platform and a family of software products developed by Microsoft for collaboration and web publishing. Its capabilities include developing web sites, portals, intranets, content management systems, search engines, wikis, blogs, and other tools for business intelligence. For SharePoint-specific questions, please see the SharePoint Stack Exchange (http://sharepoint.stackexchange.com) site.

Filter by
Sorted by
Tagged with
0
votes
0answers
9 views

Does anyone know the SQL that the Sharepoint Audit Log Trimming runs?

I have a SharePoint database that is growing and found out from the SP admin that his Audit Log Trimming SP job has been failing. I've searched through the stored procedures in the database and found ...
0
votes
0answers
18 views

SharePoint changing statistics options daily

SharePoint switches OFF and ON options like AUTO_UPDATE_STATISTICS, AUTO_UPDATE_STATISTICS_ASYNC, AUTO_CREATE_STATISTICS, INCREMENTAL on SharePoint databases daily at 12 AM and that generates lots of ...
0
votes
1answer
80 views

Do you connect an application to the load balancer name or the cluster name?

My DBA delivered a 2 server WSCF for me to connect my sharepoint farm to. I have a load balancer name and a windows cluster name, and 2 server names. I realize I need to connect either to the ...
2
votes
1answer
218 views

SQL Server 2016 Standard or Enterprise for SharePoint 2016

I know that for SharePoint 2016 version we can go for either SQL server 2016 standard or enterprise. But just wanted to know are there any disadvantages of going for SQL server standard edition ...
2
votes
1answer
302 views

Update xml based off datatype

I need to update a value in my xml datatype column, currently I am able to pull specific values using Select AllUserData.tp_ColumnSet.value('nvarchar13[1]', 'varchar(max)') AS AssetId... My data in ...
3
votes
1answer
945 views

SQL Server instance running out of worker threads

I have a SQL Server 2008 R2 SP3 Standard Edition 64-bit instance on 8 cores (576 max worker threads) with 32 GB RAM (MaxMem = 28000). It is the data store for a SharePoint installation, with 218 ...
0
votes
1answer
22 views

Always On reaction in specific scenario

I need to upgrade my Sharepoint2013 Farm, and the SQL2012 servers are in AlwaysOn mode. I was wondering if I could use Always On in the following catastrophic scenario: Take a VM snapshot of ...
0
votes
1answer
237 views

Poor SSRS Rendering performance in SharePoint 2010

Compared to running reports locally (in Visual Studio) or in a Native installation of Reporting Services (SQL Server 2012 SP3) we are experiencing very frustrating performance issues when rendering ...
2
votes
1answer
949 views

Ola Hallengren Parameters for Index Rebuild/Reorganize on SharePoint

I plan on using the IndexOptimize script by Ola Hallengren to replace the SharePoint 2013 On Premise Defragmentation Timer Job. Anyone out there using it for this purpose? What params do you use and ...
0
votes
2answers
1k views

Recommendations to prevent failover (scheduled)

I have a two node SQL Server failover cluster with availability group. This is used for SharePoint. SharePoint rebuilds the indexes where necessary every night. This routinely causes failover. I can't ...
1
vote
1answer
80 views

High availability SharePoint farm with restricted conditions

Currently, our SharePoint farm has restricted conditions as below Shared folder is not allowed FTP/SFTP is not allowed SQL FILESTREAM is not allowed SMB protocol is not allowed Using Windows Server ...
4
votes
4answers
2k views

See who has access to databases via AD group membership

SharePoint has a button to "Check Permissions". Here you can select a user from Active Directory, and it will magically traverse groups and show you all the access the user has on the site based on ...
1
vote
2answers
1k views

Always On log files bigger than database files

We had SQL RAP and we got warning that Transaction log files larger than the database files. They advised me to remove databases from Always ON, change recovery mode to SIMPLE and then shrink log ...
1
vote
1answer
633 views

SSIS Package with SharePoint fails when scheduled, but runs fine manually from SSIS Store (SQL 2008)

I have an SSIS job that gets data from a SharePoint 2010 list that runs perfectly from Visual Studio and also if I trigger it manually from the SSIS store, but not when scheduled as a job in the SQL ...
3
votes
1answer
80 views

Questions Concerning Database Snapshots

One of our divisions is running SQL Server 2012 SP1 Enterprise edition for no particular reason (I know, I know... the decision was made before my time and they are resistant to change). What I'm ...
1
vote
1answer
147 views

How to backup Sharepoint databases

I am responsible for backups of normal DBs, but SharePoint is handled by others. Bit worried that we miss something here. Is SharePoint backup handled completely through some tool in SharePoint, or ...
2
votes
0answers
344 views

AD User does not inherit the permission from AD Group - for a LOGIN

I am having a very tough time figuring out the permissions in my database. My users gain access to the database through reports on SharePoint (via Impersonated authentication configured through ...
0
votes
2answers
240 views

Reporting Services in SharePoint Integrated Mode with SSPI/Windows Authentication Architecture

I have a confusion about the place of Reporting Services' installation in my current architecture. I have two servers, one where SharePoint is on, and another where my data resides. Both servers have ...
0
votes
1answer
49 views

Find the Sharepoint application server based on Sharepoint Databases

I'm doing some cleanup in my SQL Server farm and I found on one of our SQL servers (2012) several databases that I believe belong to a Sharepoint server. No one knows in the company what is the SP ...
2
votes
0answers
322 views

Stolen Server Memory on SQLServer that hosts Sharepoint databases

On one of our servers we have problems with high stolen server memory (around 70% as reported by SCOM). There are Sharepoint databases on the server and there are 2 extended events sesions called ...
3
votes
1answer
276 views

SQL Server High Availability and Sharepoint - log file grows when no database activity

Just started as a dba with a company running SQL Server 2012 High Availability and SharePoint. Short description: Database with no user activity still has growing log file. Long description: They ...
1
vote
1answer
44 views

Why SSRS use Share point server for deployment of reports?

I switched from Oracle platform to Microsoft SSRS. Currently I am working on SSRS. What is the use of Share point server for deployment of SSRS reports ?
0
votes
2answers
49 views

SharePoint Database Creation Failure

I wonder if this question will need to be moved to the SharePoint SE site, but I believe this could be a simple a SQL Server security fix. A little back story: Back in April we upgraded our ...
0
votes
1answer
375 views

Clear out remnant LDF log files of Sharepoint DB not visible on SBS 2008 Domain Server?

Typical ways for dealing with LDF files that take up a lot of space, recommend these processes to shrink/ eliminate the drive space being occupied. http://www.sharepointboris.net/2008/10/sharepoint-...
1
vote
1answer
115 views

Getting DPM Alerts for Failed Recovery Point for Database that has Been Deleted

Deleted a defunct database in SharePoint, now getting alerts from DPM saying: The following alert occurred at 2/16/2016 12:16:54 PM. Status: Active Data source type: Data source: SharePointServer\...
3
votes
1answer
313 views

Reduce impact on SQL logs

Sharepoint and SQL Server issue as below When we change setting on SharePoint (Get-SPEnterpriseSearchServiceApplication).QueryLogSettings.CleanupDays = 30 we basically tell SharePoint to purge all ...
2
votes
0answers
893 views

How can I have long waits on Tracewrite, when I haven't run Profiler?

I recently setup a SQL Server which is used only ot run a sharepoint Server. I love to query my wait stats, just to see what we are waiting on. Most of the wait stats are fine, and I know where they ...
2
votes
1answer
390 views

Having Sharepoint on a different Collation than the system Databases?

After installing Sharepoint I realized that the collation of all Sharepoint databases is Latin1_General_CI_AS_KS_WS while my server collation is Latin1_General_CI_AS. From official documentation I see ...
5
votes
1answer
896 views

Why is a max degree of parallelism 1 recommended and used for Sharepoint in SQL Server?

I am new to Sharepoint, but I used to work with SQL Server a lot. I realized that Sharepoint changes some of the SQL Server settings to non default values. One is the max degree of parallelism, why ...
7
votes
2answers
2k views

SharePoint 2013 Database encryption

I'm using SharePoint 2013 with SQL Server 2012 as persistence layer. I need to encrypt the data stored in the database. I stumbled upon the SQL Server feature Transparent Data Encryption (TDE). What ...
3
votes
4answers
291 views

SQL Server 2008 backup script

I have a lot of SharePoint 2013 databases to backup and if update fail to restore, so I want to automate this operations. ALTER DATABASE [TEST_1] SET OFFLINE WITH ROLLBACK IMMEDIATE GO BACKUP ...
0
votes
1answer
55 views

Shrink configuration & content database in Sharepoint DBs

There was some argument between me and a college about for how we should shrink DBs. We knew that shrinking should be manual and only if required. We run in a case that configuration DBs reached to ...
1
vote
1answer
1k views

How do I reduce SharePoint 2010 SQL server log files? [duplicate]

I have a work place portal built on SharePoint 2010 and the SQL Server drive space is full. I am using SQL Server 2008 R2. Of the 800 GB disk space, the log files have taken approximately 730 GB. ...
0
votes
1answer
5k views

Allow access to enter data through forms, but not full database access

Using Access 2013 or Sharepoint 2013 is it possible to give someone access to data entry forms that work with a back-end database whether Access database or Sharepoint SQL. But from everything I've ...
0
votes
3answers
1k views

Login failed for user even though it has read access

I have a SharePoint server which is using service account "spsharepoint". For some reason this user has started giving 'Login failed for user DOMAIN\spsharepoint' when I checked SQL Server logs. ...
2
votes
2answers
4k views

2 SSRS Instances, one in native mode and one in sharepoint integrated mode with PowerPivot and PowerView on same server

Wanted to know if I can have two SSRS instances on the same server, one in native mode and one in SharePoint integrated mode. I have one SSRS instance in native mode on a SQL server default instance ...
0
votes
1answer
2k views

What are the problems with sharing an Access database through online storage service, like Dropbox?

I have a desktop database I created in Access. I'd like to share the database with a single collaborator, who can have full privileges to the database (table access). However, my collaborator is much ...
1
vote
1answer
181 views

Stored Procedure Performance Issue in Sharepoint Report

We have a report stored procedure that runs in about 1 minute in production; however, when executed from the Sharepoint it populates, it rus for over 20 minutes, with exactly the same parameters. We'...
0
votes
1answer
30 views

SSRS 2012 and SharePoint 2010 Standard

Is it possible to use Report Builder Model, Report Builder Report, Report Data Sources with a Sharepoint Standard 2010 edition?
0
votes
1answer
65 views

Deploy SSRS 2012 report to a distant Sharepoint 2010 server

My installation : - SQL server 2008 r2 + Sharepoint server (main farm) = VM1 - SQL server 2012 + SSRS 2012 (not native mode) = VM2 I would like, if possible , make my SSRS configuration manager (...
1
vote
1answer
1k views

Dealing with large transaction logs in a cluster

Disclaimer: I'm a dev, not a DBA. I've gleaned what I can from MSDN, but could do with some expert guidance! I'm working with a SharePoint 2013 installation on a SQL Server 2012 cluster of two DB ...
1
vote
2answers
1k views

Migrate sharepoint database from SQL Server 2012 express to SQL Server 2012 Standard

My sharepoint is using SQL Server 2012 R2 Express as a database Server, and I already have reached the limit of space (10GB). In the other hand I have a SQL Server 2012 Standard with proper license. ...
1
vote
0answers
1k views

SSRS 2008 report fast in test, slow in production: parameter sniffing problem?

We recently had an issue with reports running in an integrated SharePoint environment where the report runs fine in development, test and staging, but very slow (times out) in production. Running ...
6
votes
1answer
4k views

High CPU in SQL Server supporting SharePoint databases while running FAST search crawl

I have a a SQL Server 2012 (SP1) #cu5 (X64) instance used as SharePoint 2010 back end and for the most part use only 10 - 30% CPU but there is a high CPU usage when running FAST search crawl(both ...
2
votes
2answers
1k views

SQL Server and SharePoint time problem

I have created a SharePoint application which has a specific time zone. The Windows server where SQL Server and SharePoint are installed are using same time zone. When I create a new item in list ...
7
votes
1answer
3k views

Extremely Slow StatMan query issue with #SP2010 farm

The issue I’m experiencing is explained in a blog-post I created for this, (easy to refer to and to manage the responses / solutions in 1 location) which can be found here: http://schoennie.blogspot....
0
votes
1answer
819 views

Where to install Oracle client software on SharePoint 2010 Server

We have our ASP.net web application hosted on a SharePoint Server 2010. Our application uses oracle database to save and retrieve data.For our application to work on SharePoint server we need to ...
-1
votes
1answer
1k views

Directory lookup failed during log shipping

I have configured log shipping for all our SharePoint 2010 databases. All worked well since Friday and today Monday I ran this query: SELECT * FROM [msdb].[dbo].[sysjobhistory] WHERE [message] like '...
0
votes
0answers
931 views

Getting UserInfo data out of Sharepoint via OPENROWSET

The query below returns most of the data from the SharePoint list that my customers want: SELECT * FROM OPENROWSET ('Microsoft.ACE.OLEDB.12.0', 'WSS;IMEX=1;RetrieveIds=...
9
votes
2answers
8k views

SELECT/INSERT Deadlock

This instance hosts the SharePoint 2007 databases (SP). We have been experiencing numerous SELECT/INSERT deadlocks against one heavily utilized table within SP content database. I have narrowed down ...