Questions tagged [database]

A usually large collection of data organized especially for rapid search and retrieval (as by a computer).

63 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
6
votes
1answer
2k views

Remove and recreate all personal sites - mysites - remove them from DB without waiting ~25 days

Is there a easy way to remove (delete) all personal sites and recreate them all over again? I also want to delete them from the sql. I've tried to delete personal sites and run my site clean up job ...
2
votes
0answers
50 views

Access Database exceeds 5000 items and doesn't function in SharePoint because of that

I have a table in Microsoft Access that contains much more then 5000 items. In addition, I created a MS access form which I published in SharePoint. In this form, the users have to select some options ...
2
votes
0answers
147 views

Support for SQL Server 2016 Query Store on a SharePoint Database

SQL Server 2016 has a new performance tuning feature Query Store. Query Store must be enabled at database level. All Query Store information will be stored in the primary filegroup of the database. ...
2
votes
0answers
449 views

Integrate sharepoint with a NoSQL database?

I was wondering if it is possible to connect/integrate sharepoint with a NoSQL database (e.g mongodb, couchdb, etc)? I wasn't able to find any information on how this can be done. I did find ...
2
votes
0answers
126 views

File Linking: Excel to Access to Excel

My organization is small and uses SharePoint to store our shared files enabling us to access shared files from each of our desktops. However, when we link files while they are on our desktop they ...
2
votes
0answers
630 views

Best way to create a Relational Database App in SharePoint 2010

I have a company using SharePoint 2010 wanting a SharePoint based database and UI with about 10 tables, all linked with foreign key relationships. My preference would be to simply write a normal ASP....
2
votes
0answers
2k views

SharePoint 2013: Event ID 2: Session “SharePointDiagnostics” failed to start with the following error: 0xC0000035

We're on 2013 CU 3/15 and I'm seeing this error once/twice a day on one of our front end servers. Event ID 2: Session “SharePointDiagnostics” failed to start with the following error: 0xC0000035 I'...
2
votes
0answers
621 views

How SharePoint works with Infopath and an Access database?

I have a database already created in Access. It has a form which uses queries with macros to export an excel with the information chosen from the form. SharePoint would be the perfect tool to share ...
2
votes
1answer
1k views

Sharepoint 2010 Data Sources with Windows Authentication

This is two part questions: Does SharePoint 2010 support Trusted_Connection(Integrated Security=Yes;) when connecting to SQL Servers 2008/2012 for retrieving custom list? If it does how can I set it ...
1
vote
0answers
54 views

SharePoint Migration - Product / patch installation or server upgrade required

I migrated SharePoint from 2013 to 2016 and then 2019. I used the database prefix SP_Intranet. After migration to 2016, I removed SP_Intranet_Config and SP_Intranet_CentralAdmin + non-migrable ...
1
vote
1answer
32 views

How to add an editable Access Desktop Database to Sharepoint Server 2016

I'm a university student summer intern at a government agency, so sorry if this comes off as a dumb question or if I don't appear very knowledgeable, but our team of maybe 10-ish people uses an excel ...
1
vote
2answers
24 views

SharePoint Content Database on a non-SharePoint configured Database

Is it advisable to have a SharePoint Content Database on a SQL Database Server that is not specific for SharePoint?
1
vote
2answers
376 views

Best practice to bulk upload records to an existing list

I need to do a bulk upload over 10k records to an existing SharePoint list. I am using MS access and it is very slow and keep crashing. Is any better way of doing it? Thanks
1
vote
1answer
683 views

SQL database login for 'ConfigDB' on instance ' failed. + Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'

I know my question is very similar to this one; SQL database login for 'Config' on instance '' failed. Additional error information from SQL Server is included below However in my ...
1
vote
1answer
3k views

Export Sharepoint List to MS SQL Database

We would like to export our SharePoint Content to MS SQL Database. Do you please know about any tool that allow so? The purpose of this is to use MS SQL DB in our reporting tool which is easier and ...
1
vote
0answers
16 views

What makes search application download real content for crawling?

I have a Windows Server 2012 server with SharePoint Foundation 2013 and the latest CU from September 17. This front end server is connected to a sql 2008 r2 server. I have 4 sharepoint applications ...
1
vote
0answers
75 views

Business Connectivity Service on Sharepoint online-How to link with external data source?

We have a sharepoint online(O365) solution,now we are maintaining all our dept user data in a virtual db in our dept itself,i just want to know how to connect our sharepoint site to that data source ...
1
vote
1answer
808 views

Cannot deploy farm solution retract solution and feature not installed

I'm having some trouble for deploy a farm solution from Visual Studio 2012 Ultimate: The error says: Error occurred in deployment step 'Retract Solution': Object reference not set to an instance ...
1
vote
0answers
601 views

ReportingService Databases running in compatibility range, upgrade recommended

We are running a stand alone SharePoint 2013 install. I have gotten the following message regarding various databases within the install on different occasions and I am always able to resolve them ...
1
vote
0answers
161 views

What do I need to set up a Entity Framework 6 Database on Sharepoint 2013?

I'm new to Entity Framework and Sharepoint so bare with me. I'm currently making a website for my work where users would be able to store entry information of their contacts and tasks. These entries ...
1
vote
1answer
50 views

Build web service to retrieve from DB

I want to build a web service to get data from database and be consumed from a SharePoint application. I am thinking of using Web API for that, but my question is, do I add a new project to my ...
1
vote
0answers
35 views

Multiple content databases and Multiple search agents

So I have one big database which is over 1 TB now, and also this is my content database which is connected to SharePoint 2010. Although full and incremental crawl go well and search works(also i am ...
1
vote
0answers
43 views

Transaction log file for FAST Search

I have a FAST database that has a transaction log file that is growing at an unusually high rate, possibly after applying the FAST SP2 update. It ends up taking up the whole volume within a few days. ...
1
vote
0answers
982 views

Clean WSS_Logging database

Altough the logging of my SharePoint 2013 has been completely disabled a few months ago, I still find entries from April 2015 in the db today (2015-11-12). Checking with Get-SPUsageDefinition all ...
1
vote
0answers
250 views

Migrate Workflow Manager 2013

Anyone can provide an official article / good resource on how to migrate SharePoint 2013 workflows from one farm to another?
1
vote
1answer
381 views

How do I create a column that auto generates a number in sequence?

There are multiple users key-ing information regarding candidates on our Recruitment Database. However, I want a "Candidate number" field automatically generated every time a new line item is created. ...
1
vote
1answer
391 views

Infopath Form does not work in Sharepoint

I have a form that has 3 Data Connections. Main Data Source (Active Directory) Secundary Data Source (SOAP Web Service) Secundary Data Soruce (SQL Database) I fetch data from AD, from a Web Service ...
1
vote
0answers
312 views

Using InfoPath inBrowser forms, create reports from captured data, and present those reports back in SharePoint

I'm using SharePoint 2010 and I have access to InfoPath and BCS services. I’m looking to use InfoPath forms that are accessed IN-BROWSER through SharePoint to capture data, and use that data to ...
1
vote
0answers
26 views

Re-using SQL instance for multiple farms

During a transition phase of indeterminate length, I will be hosting the databases for a SP2012 farm and an unrelated SP2013 farm on the same physical hardware. I know that the guidance for mixing SP ...
1
vote
0answers
61 views

What is a SPPersistedUpgradableObject and the IUpgradable interface mean?

SPPersistedUpgradableObject is a SPPersistedObject that implements the IUpgradable interface. The MSDN is seriously lacks any documentation other than it: Provides members for managing an ...
1
vote
0answers
32 views

Editing a Dataview from a joined list

I think I want to do something simple, but it seems maybe I am not doing it the way you are supposed to. I need to use Sharepoint Designer 2007 to create a website, code behind is highly likely to be ...
0
votes
0answers
15 views

Data Base in Read-only mode when creating a SharePoint application

We created out new SharePoint 2019 Farm of 3 SharePoint Servers and 2 SQL Servers (Cluster). When I try to create a new web application I get an error: Cannot update database on SQL Server instance ''....
0
votes
2answers
21 views

Restore SharePoint database with metadata

I have a question - When you restore a SharePoint database what will happen to original metadata, such as Created by, Created and Modified by and Modified? Regards
0
votes
1answer
79 views

Download a specific file from SharePoint (CSOM) using C#

I'm developing a C# based application that requires to download, checkout, upload, check in on a specific file from/to Sharepoint with CSOM. So I have two questions here: Firstly, on download, is ...
0
votes
1answer
20 views

SharePoint Content Database issue

I have 3 Databases for our SharePoint environment, however when I run power shell script to show my content database its only show the 2, and when I go to Manage my content database from CA I can see ...
0
votes
1answer
28 views

Set Simple recovery model before shrinking SharePoint database

I read several articles recommending switching to Simple recovery model before shrinking dbs. Here, here and here. Please explain me - Why it is needed. I also read the white paper about Maintenance ...
0
votes
1answer
21 views

Is it possible to connect SharePoint to an Access database without having information stored in a list?

It would ideally work like this. A user fills out a form in sharepoint and the information captured from the fields would be stored in a Microsoft access database and not in a sharepoint list. The ...
0
votes
1answer
72 views

SharePoint 2013 Site Collection Databases Swelling too big over night

I upgraded SharePoint 2010 Farm using database attach method to SharePoint 2013. I have many site collections with their own databases. Overnight randomly one site collection database becomes huge ...
0
votes
1answer
25 views

How to log data to a database using javascript?

I am to track who viewed a specific document in a document library, I found out that there is no Item Viewed event or similar event in the SPEventReceiver class. SO I developed a spfx solution that ...
0
votes
2answers
28 views

Is there a sotfware to create, manager and CAML query SharePoint Lists without having SharePoint installed on a computer?

I'm working on a SharePoint site at work, however due to PCI compliance I am not able to access SharePoint at my house, I was trying to find a software on which I can be able to create lists and use ...
0
votes
1answer
49 views

Difference in database size between SharePoint 2007 and 2013

We're migrating a system that includes a reasonable chunk of docs in SharePoint 2007. The docs have been migrated into SharePoint 2013 and now the migration has completed, it appears that the ...
0
votes
1answer
126 views

How can SharePoint hosted App be connected to Sql Database

I am creating a SharePoint hosted App where I need some data from SQL table. As my major work is on SharePoint list only,hence I don't want to go for Provider hosted App. Could you please provide me ...
0
votes
0answers
90 views

How to query SP logging database for most clicked items and how long

I am currently playing around with the SharePoint logging database (by default [WSS_UsageApplication]). What I want to know are two things: how I can query for most visited list items how can I query ...
0
votes
1answer
80 views

Is it possible to have an user-interface and macros on sharepoint?

Context I'm making a project on a company that must have an user interface and a database or work directly over an excel. Also I need this on SharePoint. Info The problem is that in the company, ...
0
votes
1answer
36 views

SharePoint 2013 / Data Scrubbing

After you delete an item or document from a list or library, and then the recycle bin and secondary recycle bin, does the data remain in the database for a certain amount of time? .. or forever unless ...
0
votes
1answer
116 views

Mount/dismount database for migration

I'm mirgrating from one domain to another. Finally managed to get the new sharepoint version to match (infact, its actually a little newer than the original now!). I have exported the databases ...
0
votes
1answer
121 views

Sharepoint 2010 Database version

We have an weird error we cannot find out why this happened. We have some content database that are showing : SharePoint database is in compatibility range and upgrade is recommended But the what is ...
0
votes
1answer
65 views

Activating BCS in sharepoint 2013

I'm wanting to use BCS in my SharePoint environment and i came to the problem of the database. Can we connect multiple databases on different servers? Can we select the database from its IP ...
0
votes
1answer
303 views

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

Screenshot of files, location & DBs in Microsoft SQL Server Management Studio Express GUI: I've looked at several answers and tutorials on how to clear out the LDF via GUI and SQL commands, but ...
0
votes
1answer
108 views

How to make web database that will collect data from sharepoint calendar in real time?

I want to make database out of data users' input in project calendar. Basically every user types in working hours in project calendar (how many hours each day they had worked on that specific project) ...