Questions tagged [database]
A usually large collection of data organized especially for rapid search and retrieval (as by a computer).
305
questions
0
votes
1
answer
18
views
converting a semi-structured excel database into a sharepoint database
Our company has an excel customer-record cheat sheet. we're trying to integrate that cheat sheet into SharePoint. However, the sheets in the excel cheat sheet are not relational structured data. Some ...
- 1
0
votes
0
answers
120
views
Connect an on premise Oracle Database to PowerApps
I have an Oracle Database created using Oracle Express Edition 18c and Oracle SQL Developer. It's name is 'my_powerapps_connection' and created a table named 'EMPData'.
For the connection properties ...
- 33
0
votes
0
answers
20
views
Dynamic content generation out of multiple modules and variables stored in a database/list
I'm essentially trying to achieve two things:
I want to create multiple text modules (in a list, database, or something else) and insert placeholders inside these text modules. These placeholders ...
0
votes
1
answer
43
views
Secure the SharePoint lists from allowing Project Manager to add users inside a Projects the PM is not defined inside it
We are in the Design phase of a Project Management system, and we have 2 technical approaches to follow:-
SharePoint as the Back-end + Power Apps & Power Automate
SQL server as the Back-end + ...
1
vote
0
answers
22
views
Parsing SharePoint's WebPart UserProperties - value States
I'm working on a parser that is able to parse data directly from SharePoint .mdf database.
Currently I'm working on parsing data in binary column tp_AllUsersProperties. I'm able to parse pretty much ...
- 11
1
vote
2
answers
2k
views
SPFx to connect to local SQL Server Tables,Stored Procedures & view.. Approaches to follow
I am working on a migration from SharePoint 2010 to SharePoint Online. Where inside the on-premises the customer has a configurable Web Part (Server-side of course), which allow users to do the ...
0
votes
0
answers
52
views
SharePoint database admin account accidentally deleted
The SharePoint database admin accidentally deleted. How to reinstate this admin account?
I created a new account with db_owner in database. But looks like it was not setup properly.
It shows below ...
0
votes
1
answer
23
views
I need to create report from external sql database , and run the report at sharepoint 2016
I need to create a report from an external SQL database and run the report at SharePoint 2016. The SQL database size was big around 5 GB, How can I do it?
I think to create a procedure at SQL ...
0
votes
1
answer
690
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!
- 47
0
votes
1
answer
279
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 ...
- 107
0
votes
1
answer
489
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 ...
- 115
0
votes
2
answers
115
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
- 581
0
votes
1
answer
2k
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 ...
- 1
0
votes
1
answer
92
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 ...
- 581
0
votes
1
answer
48
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,018
1
vote
3
answers
1k
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
1
answer
69
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
- 581
1
vote
1
answer
676
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
1
answer
794
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 ...
- 202
1
vote
0
answers
81
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 ...
cleemas
1
vote
1
answer
53
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 ...
- 11
1
vote
3
answers
390
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
1
answer
27
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 ...
- 1
0
votes
1
answer
893
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
1
answer
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
1
answer
135
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
1
answer
136
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
1
answer
144
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
1
answer
161
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 ...
- 12.6k
1
vote
1
answer
209
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 ...
- 439
0
votes
1
answer
517
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 ...
- 8,030
2
votes
2
answers
1k
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 ...
- 295
0
votes
2
answers
37
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
0
answers
62
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 ...
- 21
2
votes
1
answer
64
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. ...
- 125
1
vote
2
answers
27
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?
- 85
1
vote
1
answer
888
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?
- 435
1
vote
2
answers
1k
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
- 91
0
votes
1
answer
256
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 ...
- 101
1
vote
3
answers
2k
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 (...
- 753
0
votes
1
answer
95
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") ...
- 101
1
vote
1
answer
1k
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 ...
- 653
2
votes
1
answer
22
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 ...
- 143
0
votes
1
answer
1k
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"...
- 175
0
votes
1
answer
57
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 ...
- 11
2
votes
3
answers
1k
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?
- 405
0
votes
1
answer
2k
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 ...
- 653
1
vote
1
answer
5k
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 ...
- 53
0
votes
1
answer
180
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 ...
- 129
1
vote
0
answers
20
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 ...
- 11