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
4
votes
3answers
14k views

Move database to new SQL Server

My client has asked me to move all the Database used by the SharePoint Farm to a new SQL Server Machine. I came across this article http://technet.microsoft.com/en-us/library/cc512725(v=office.14)....
10
votes
2answers
1k 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 ...
5
votes
4answers
28k views

List of databases used for a sharepoint 2010 farm?

How to find the list of databases are used by a SharePoint 2010 Farm, including content databases, service application databases and configuration database.
3
votes
2answers
1k views

(De)Commission SharePoint Database Servers

In our SharePoint Farm, We are running with 2 Database Servers and on which we have 20+ Databases.Now, due to some issues we would like to decommission the existing database servers and commission 2 ...
2
votes
1answer
2k views

Restore Content Database to a different farm (Prod -> Beta -> Dev Servers)

My end goal is to have some code that automatically takes the Content Database backup from Production and automatically nightly restores it on Beta. Can I just do backup and restore sql commands? Or ...
1
vote
3answers
16k views

Moving the Sharepoint 2010 configuration Database to a new DB server..?

We were using the database server "OldDBServer" and have copied all the databases on the new database server "NewDBServer". Now, all the reference (like CA admin content DB, content DBs & Service ...
1
vote
1answer
6k views

Does sharepoint online support external Data sources

We are looking to migrate to sharepoint online from our current on premise installation and currently have one question that is still unanswered. We use custom WebParts (which we will need if we ...
1
vote
1answer
4k views

Restore User Profile Data to another farm

I've been setting up a test farm for a customer where I'll be looking to restore the UPSA databases from production, mainly the profile one, there isn't too much else I'm interested in other than ...
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 ...
0
votes
3answers
984 views

What is best way manage SharePoint webpart access to database?

I have my custom webpart, which have access to database. I need to configure data source, catalog, username and password, which allows webpart a access database. I don't want that users can see, what ...
14
votes
3answers
9k views

How to split a Content Database within site

I have a very large content database & need to split it. Is it possible to split a content database within a site collection? or I need to create a new site collection?
5
votes
2answers
17k views

Central Administration cannot connect to configuration database

I made a script for batch uploading files, which I successfully used to upload more than 900 files (few gigs of data). Today I prepared another set of files and everything was working fine, but ...
3
votes
2answers
3k views

How does SharePoint store versions of customised pages?

While a page is uncustomised (previously known as unghosted) it is stored on the file system, however once it is customised (previously known as ghosting) it is copied to the DB. Source 1 and Source 2 ...
2
votes
1answer
474 views

1 million records in SharePoint 2013 List

We are having list wherein, we where pushing records from mobile app to the SharePoint List. We were just adding mobile device id into the list for push notification. In 2 year time records reach to ...
2
votes
6answers
10k views

Emptying site collection recycle bin doesn't make content DB smaller?

I deleted everything from a site collection recycle bin and remote into the SQL server the content database is located and the sucker didn't get smaller. I had about a good 2 or 3 gigs of files in the ...
1
vote
3answers
3k views

Copy items from sql database table to SharePoint list

I need to migrate items from SQLdatabase table to SharePoint list. I know this can be achieved using a C# console, but I have no idea how to achieve this. (Need to implement this using C# code, I ...
1
vote
3answers
436 views

Sharepoint 2010 and 2013 on same SQL Server

We have a Sharepoint 2013 installed with SQL database Cluster and our old Sharepoint 2010 databases should also be moved to the new SQL database Cluster but not migrated to Sharepoint 2013. I have ...
1
vote
1answer
3k views

move a database to a different drive on the same server? [closed]

I'm trying to figure out how to point the database of my existing Sharepoint foundation install to the D: on my server. It was installed on the C: We just upgraded the D: to hold a lot more and need ...
1
vote
1answer
184 views

Where do I get started on building an HTML5 form in SharePoint?

Working on a project to build an HTML5 form within SharePoint that will read and write to a SQL database. Can't find much online about how to get this implemented. I am very well versed in HTML and ...
1
vote
1answer
121 views

MOSS 2007 + ContentDB size ~500GB = Performance Issues

Have an old MOSS2007 "mammonth" on SQL 2008, which have performance issues. IIS often crashes and gives "Unknown error". It is a two-tier Farm with Database on one server and WFE+App.Server on the ...
0
votes
1answer
6k views

Restore content database 2013

I am trying to restore a SharePoint site with a backed up content database. I restored the backup of the content database to Sql server, then when i created the web application i entered the restored ...
0
votes
2answers
2k views

Is it possible to migrate and attach a wss 3.0 configuration database to a new Foundation 2010 front-end?

We are preparing to migrate from WSS 3.0 to 2010. WSS is currently on a x86 operating system, so migrating to a x64 operating system will be involved as well. My co-worker's thought is to turn up a ...
0
votes
2answers
2k views

How should I set up my database instances for multiple SP2010 installs?

I'm setting up three SharePoint instances. We have a single database instance (DB\SP2010) that will hold all the databases for these three SP instances. Will this be overly confusing? Is there some ...