Questions tagged [database]

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

Filter by
Sorted by
Tagged with
0
votes
1answer
21 views

Sync SharePoint Online list to database (Mysql)

Is it possible to sync a sharepoint online list to a database like Mysql hosted on azure? If not, what is an alternative solution? Is a custom connector possible? Thank you for any help!
0
votes
1answer
22 views

Sharepoint 2013 foundation database compatibility

The company I am working for is considering updating to Sql server 2019, from reading the documentation, it says that the highest version that 2013 foundation works with is 2016. My question is, can I ...
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
1answer
19 views

How to get data from OracleDB to SharePointOnline List

I want to migrate data from Oracle DB to SPO list. What I can think of now is to export the data as a CSV file etc. and paste the data with a quick edit on the SPO list screen. But this method is very ...
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 ...
1
vote
3answers
168 views

Link lotus notes database to Sharepoint

I'm new to SharePoint. Is it possible to link lotus notes databases to SharePoint? If so, how is this done? Any assistance would be greatly appreciated.
1
vote
1answer
25 views

Why Database is in compatibility range and upgrade is recommended

This is more than a question than an issue, my question is why SharePoint Database get to this status. Database is in compatibility range and upgrade is recommended Regards
1
vote
1answer
119 views

Is it normal that our sharepoint on-premises 2013 does not have WSS_Loging database

we have a sharepoint farm 2013 (license type = SharePoint Server with Standard Client Access License) , now we are facing an issue that the "Usage reports" for our sites will always be empty (0 views)....
1
vote
1answer
244 views

“Database is too old and upgrade is required” on “technical” databases

An IT admin working for a client installed various Windows patches (along with SP patches available via Windows Update), and now two databases ("BdcServiceDatabase" and "StateDatabase") are showing ...
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
3answers
64 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.
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
354 views

System.Data.SqlClient.SqlError: The media set has 2 media families but only 1 are provided. All members must be provided. (Microsoft.SqlServer.Smo)

I want to Backup/Restore our managed metadata managed service's database from live to test which are both sharepoint 2013 farms. So i did these steps:- 1- Inside the live database i select the related ...
0
votes
1answer
16 views

Is there any restriction on backup-ing sharepoint databases using SQL management studio

We have SharePoint on-premises farm 2013, and per my knowledge that it is not supported to query the SharePoint databases. but is it a supported operation to select a SharePoint database (for example ...
1
vote
1answer
80 views

If we have a backup for all the sharepoint 2013 databases, can/how we restore a corrupted application server

One of our customers use to have a sharepoint enterprise farm 2013, with the following architecture:- windows 2008 R2 which contain sharepoint on-premises farm 2013. windows 2008 R2 which contain Sql ...
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
1answer
53 views

Does reading directly from the Project Server database void the warranty?

I know that in SharePoint, it's hugely frowned upon to access content databases directly, and in fact Microsoft will stop giving you support if they find out you've touched the databases. Is the same ...
1
vote
1answer
49 views

Which SP2013 database do workflows reside in?

We have an issue with a large records center site where workflows from the drop-off library are not working correctly. However we do know what date they were previously working. Is there a specific ...
0
votes
1answer
192 views

ERROR CanUpgrade [SPConfigurationDatabase] failed

The following errors are showing up in the logs a couple times per day: ERROR CanUpgrade [SPConfigurationDatabase] failed SharePoint Foundation Upgrade SPUpgradeSession ERROR Exception: Login failed ...
2
votes
2answers
535 views

“Databases running in compatibility range, upgrade recommended” when NeedsUpgrade=False

SharePoint Health Analyzer warning: Databases running in compatibility range, upgrade recommended. Explanation: The following databases have versions that are older than the current SharePoint ...
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 ...
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
1answer
42 views

SharePoint , Forms and Data Connections

Although I have done quite a bit of reading, site, page, list, web app creation etc to try and get a feel for this, I am struggling to understand clearly the basic principles of where best to start. ...
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
1answer
442 views

SharePoint 2013 - Large SharePoint_Config Database

I have what appears to be a large SharePoint_config database: SharePoint_Config.mdf = 99GB SharePoint_Config_Log.ldf = 14GB Is this normal? How can I decrease the size of this database?
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
0
votes
1answer
137 views

How to import data into Excel from MS Access?

If I put an MS Access database on Sharepoint or One Drive, how can I import/link the database table into Excel? My Excel will also eventually be on Sharepoint. Current as a PoC, I put the database on ...
1
vote
3answers
817 views

Issue with “Restore-SPEnterpriseSearchServiceApplication”

I am trying to restore the production farm Search Service Application to a pre-production farm. This is to preserve all customisations to Search. I have mounted a copy of each of the 4 databases (...
0
votes
1answer
41 views

SharePoint 2013 - Getting SPSite.Url from SharePoint DB

I'm working directly against the SharePoint DB (I know it is highly not recommended but I need to, for several reasons). I'm trying to get the SPSite.Url property ("http://baseurl/sites/somename") ...
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 ...
2
votes
1answer
19 views

Virtualizing Highly Available SQL Server database on SharePoint

I am planning on virtualizing my SharePoint environment. So, I am thinking on virtualizing all the roles (Application Server, Frontend, ...) including the Database. My question is: is it recommended ...
0
votes
1answer
663 views

Move SharePoint Search databases to new Search Application

I wonder whether it is possible to attach search databases to a new Search Application in same farm/different farm ? I found all Microsoft articles only mentioned attach Search Application to "renamed"...
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 ...
2
votes
3answers
804 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?
0
votes
1answer
1k views

Change User Profile Service Application database name

Due to some reason we are in need to rename the User Profile Service Application. Following the steps mentioned in below link, we started the rename activity: Move or rename service application ...
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 ...
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 ...
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
2answers
2k views

SharePoint 2013 list in SQL

I have a couple of questions: Where does SharePoint list stores data in SQL? Is there article for SP2013 on MSDN or TechNet? - I can find outdated articles which explain table structure for a list ...
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 ...
3
votes
3answers
2k views

Alternative Options to Access Web App

So In the past I have used Access Web Apps on SharePoint to act as a database to store the data related to all of the CAD workstations for my company. With the Access App, I was able to track ...
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 ...
0
votes
1answer
40 views

Managing Huge Site Collections

I have a situation in my company's environment where site collections are reaching a size of around 500GB. They are used as a repository for documents, so an application stores the documents in there ...

1
2 3 4 5 6