Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [database]

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

1
vote
0answers
23 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
23 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
21 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
42 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
44 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
28 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
109 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
25 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
126 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 ...
0
votes
0answers
20 views

Database query to fetch different objects for SharePoint 2013

We want to fetch below information from Share Database: - BCS Applications - Custom Profile Property Mappings - Secure SStorage Applications - Web Applications Policy - Web Applications - Sites ...
2
votes
1answer
17 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
62 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
43 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
151 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
558 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 ...
0
votes
1answer
1k 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
41 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
14 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
54 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
728 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 ...
0
votes
0answers
51 views

How to get home page content programmatically?

Is there any way to get home page content programmatically ? I've already known that home page is stored in [WSS_Content].[dbo].[DocStreams] ? Am I right ? I use this query: SELECT * FROM [...
1
vote
0answers
100 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. ...
1
vote
0answers
207 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
1k 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
255 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
32 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 ...
10
votes
2answers
798 views

size of content database does not decrease after deleting content

I am using SharePoint Foundation server in my development environment, it has a content database with size almost 68 GB. I deleted all the major content (media file and documents) but its size does ...
0
votes
1answer
111 views

Deleted SessionState Database

I mistakenly deleted the SessionState database from SQL server. How this will affect my farm? And what is the correct way to recreate it?
1
vote
1answer
291 views

Are access macros supported on SharePoint

I am working on building an Access 2013 database that I'd like to deploy on our SharePoint 2013 Online site. I'd like to do some VBA customization but am concerned it will not work like excel's ...
5
votes
1answer
276 views

Whether to go for SharePoint List or Custom SQL Database

I currently have a project to create a database for storing the details of past projects we have done for customers. However, the data set is relatively small (less than 500) and the data is mostly ...
1
vote
0answers
406 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
1answer
537 views

User's Permission Database

Whenever any user creates a SharePoint site , in which database site-title and user permissions are stored in SQL server ?
0
votes
0answers
69 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
261 views

Crawl Database Size

So I have a SharePoint 2010 farm. Last month I noticed it was getting unreasonably bigger, everything was working fine though. Then I noticed that Search_Service_Application_CrawlerStore..... database ...
0
votes
1answer
50 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
29 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 ...
1
vote
1answer
1k views

Huge db file size in WSS_UsageApplication DB

I want to reduce the size of the file from this db WSS_UsageApplication in my sql server/sharepoint farm. How to reduce the this huge file size.
0
votes
1answer
47 views

When creating a list does Sharepoint create a table?

When I create a list from the web interface, does sharepoint go and create a matching table in the database? If not how is the database structured to absorb new list?
2
votes
1answer
102 views

Crawl Database disk almost out of capacity

We have a huge SharePoint environment running which has one server running exclusive for crawling. The disk of this server only has 60gb left of space and we are planning in switching it for a larger ...
0
votes
1answer
74 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
2answers
364 views

How to move the SharePoint Search Service Application database?

Can anybody suggest me how to move Search Service Application database and components to other server under the same farm ?
1
vote
1answer
57 views

Create Site Collection with New Database

I want to create new site collection with new database. I've to create new database for new site collection. the issue is, if I create new site collection. the site collection database is still on ...
2
votes
0answers
74 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
1answer
2k views

Get the status for Get-SPDatabase powershell command

How do I get the SharePoint farm database status using below PowerShell script? $baddb = Get-SPDatabase -id 25dfdfdf73-d941-4f66-9e92-18b19e7e5c79 It returns Name, Typd & Id but not status...
1
vote
0answers
105 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 ...
4
votes
1answer
2k views

Remove all Recycle Bin Items from database

In the recycle bin there are 176100 items. I have tried to remove them using PowerShell but it is unable to remove all. After sometime it stops and gives an error. Tried following PowerShell. $WebApp=...
1
vote
1answer
27 views

What is the Minimum permission the Configuration Wizards' Service Account need to have on the Database

we have installed a new sharepoint enterprise server 2013. and now i want to run the "Central Administration >> Configuration Wizards". where i am asked to select the Service Account which will be ...
1
vote
2answers
671 views

DB Schema version not supported

I am migrating my databases to my new server and encounter this error when trying to attach. "This content database has a schema version which is not supported in this farm." How do I go about ...
3
votes
2answers
276 views

SharePoint Config Log grew massively

We have a Hyper V machine hosting our SharePoint server. We are currently in the process of moving our site off the Virtual machine, for example, A, onto our server B. Because I have been busy with ...
1
vote
1answer
48 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 ...