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.
65
questions
0
votes
0
answers
24
views
MS Access backend database deleted data restored on its own
I'm not sure if this is a MS Access or SharePoint issue, I have a MS Access backend database sitting on SharePoint drive and the database stores some test data. As I approaching the end of the test, I ...
- 11
2
votes
1
answer
968
views
Is it ok to change drive names/labels (NOT Drive Letters!)
I realize this is likely a simplistic question but my searches only return results for Drive Letters or Database names if I include SQL Server. Please feel free to point me to existing articles or ...
- 31
-1
votes
3
answers
349
views
During upgrade, database raised exception 9002, severity 17, state 1. Use the exception number to determine the cause
I am trying to update the SQL Server 2014 to Service Pack 3 on my Windows Server Machine. After the updates from Windows update feature I am unable to start the SQL Server service and SQL Server Agent ...
- 99
0
votes
1
answer
209
views
Handling Reporting Services and SharePoint Integration considering deprecation
With one of our clients, we're currently faced with a dilemma. SQL Server Reporting Services Report Server (SharePoint mode) seems to have been deprecated, since the last version to support it is SQL ...
- 153
3
votes
1
answer
906
views
How can INDEX rebuilds be going parallel when MAXDOP is set to 1
I am periodically running into a THREADPOOL wait issue with a SharePoint data store of hundreds of databases using a SQL Server 2008R2 Standard Edition instance (recently migrated to an Azure VM). It ...
- 2,149
0
votes
1
answer
130
views
Design Sql Server physical configuration from existing VM
We have 4 virtual machines that we used to test our BI platform (PoC), the final dimensions are:
SSIS (16 vcpu), SSAS (8 vCPU), SSRS (4 VCPU) et Data Engine (24 vCPU)
What are the recommendations ...
- 1
0
votes
1
answer
35
views
Is it possible to migrate Sharepoint 2016 and all it's databases from SQL SERVER2012 to AZURE?
we are in a process to migrate our website to azure.
we have those tons of sharepoint databases :
Is it possible to migrate all user databases + sharepoint to azure?
I could migrate some user ...
- 7,344
0
votes
1
answer
45
views
Was SSRS installed in SharePoint Integrated Mode?
I've inherited an old QA database server with SQL Server 2008R2 (yes, yes, I know it's beyond EOL; there's nothing I can do about it!) and SSRS installed.
It's the back end of a SP server on a ...
- 606
0
votes
0
answers
109
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 ...
- 119
0
votes
1
answer
216
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 ...
- 1
2
votes
1
answer
711
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 ...
user57156
2
votes
1
answer
762
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 ...
4
votes
1
answer
3k
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 ...
- 2,149
0
votes
1
answer
37
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 ...
- 507
0
votes
1
answer
320
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 ...
- 1,774
2
votes
1
answer
2k
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
2
answers
2k
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
1
answer
123
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 ...
- 113
4
votes
4
answers
9k
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,973
1
vote
2
answers
2k
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 ...
- 25
1
vote
1
answer
1k
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 ...
- 691
3
votes
1
answer
102
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 ...
- 811
1
vote
1
answer
177
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 ...
- 593
2
votes
0
answers
630
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 ...
- 711
0
votes
2
answers
275
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 ...
- 711
0
votes
1
answer
68
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 ...
- 575
2
votes
0
answers
423
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 ...
- 303
4
votes
1
answer
435
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 ...
- 159
1
vote
1
answer
46
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 ?
- 363
0
votes
2
answers
66
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 ...
- 1,365
0
votes
1
answer
511
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-...
- 101
1
vote
1
answer
238
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\...
- 11
3
votes
1
answer
425
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 ...
- 454
2
votes
0
answers
1k
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 ...
- 1,353
2
votes
1
answer
496
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 ...
- 1,353
5
votes
1
answer
1k
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 ...
- 1,353
7
votes
2
answers
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 ...
- 73
3
votes
4
answers
389
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 ...
- 133
0
votes
1
answer
77
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
1
answer
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. ...
- 13
0
votes
1
answer
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 ...
- 143
0
votes
3
answers
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. ...
- 441
2
votes
2
answers
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 ...
- 163
0
votes
2
answers
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
1
answer
198
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'...
- 109
0
votes
1
answer
32
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?
- 21
0
votes
1
answer
66
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 (...
- 21
1
vote
1
answer
2k
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 ...
- 179
1
vote
2
answers
2k
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.
...
- 165
1
vote
0
answers
2k
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 ...
- 11