SQL Server is a relational database server used in SharePoint
18
votes
6answers
4k views
Backup via SharePoint or backup via SQL Server?
How should I backup my 2010 SharePoint server? As I see it there are 3 choices:
Full Farm backup
Site collection backup
SQL Server backup
We're only doing backups using points 1 (occasionally) ...
11
votes
3answers
281 views
SharePoint database maintenance for the non-DBA
Question ported from Serverfault as it is specific to database maintenance for SharePoint administrators:
For SharePoint administrators, SQL Server is often a black box that is installed as a ...
7
votes
5answers
4k views
SQL Server 2005 vs SQL Server 2008 on SharePoint 2010
I'm writing a recommendation for an upgrade scenario from SharePoint 2007 to SP2010.
Customer is currently running x64 SQL Server 2005 SP3 on Windows 2003 Server.
Does anyone have pros/cons for ...
6
votes
5answers
172 views
Should I use lots of SharePoint Lists or a SQL Database to store the data for my new bespoke application?
I am working on a project to create a new bespoke intranet website for around 50 users. The data volumes are relatively small, but in order to model the data I need to store (about the 100 or so ...
6
votes
4answers
1k views
Reusing and parameterising BCS External Content Types
I recently posted a query here that asked about the best way of connecting to an external SQL store.
I got some great responses back but need a little more info, specifically around External Content ...
4
votes
4answers
2k views
Why is SharePoint_Shell_Access permission required to run SharePoint powershell?
So we're setting up a SharePoint farm and it seems our admin accounts require access SharePoint_Shell_Access role on SQL.
http://technet.microsoft.com/en-us/library/ee806878.aspx
...
4
votes
3answers
4k views
How do I populate a SharePoint list from a SQL table?
I would like to know the best way to get data from a SQL view into a temporary SharePoint list from within SharePoint.
4
votes
4answers
6k views
Cannot connect to the configuration database
During usage yesterday my SharePoint services locked up the entire server and forced me to end process SharePoint tasks and stop SharePoint services. The problem was attributed to Office Web Apps, so ...
4
votes
2answers
2k views
Execution of code as Application Pool account
Here is what I'm currently trying to do -
1.Create a new instance of a timer job from a web part
2.Add a new site collection to the current web application again from a web part
Each time the code ...
4
votes
0answers
80 views
Do SQL Full Backups of Content Databases interfere with SharePoint differential backups using backup-sofarm
I've recently switched our SharePoint 2010 backups from using stsadm to the PowerShell backup-spfarm technique but just have a bit of a worry about differential backups.
Essentially we're running ...
3
votes
4answers
724 views
What is the recommended way to query data on a Sharepoint site?
Say if I need to retrieve list items for batch processing, how would I be recommended to retrieve the data? Maybe Powershell or a SQL Server query?
3
votes
4answers
2k views
Claim SQL server space after content deleted from SharePoint
We have a site collection with its own database where we have been testing migration of a department's shared drive content (about 40GB) via a third party tool. The test migrations went fine. Before ...
3
votes
1answer
173 views
Remote BLOB Storage and Sharepoint 2010
I have a SharePoint Server 2010 documents library. Library's size - 20 Gb. Size increases each year by 1-2 GB. It stores files ranging in size from 1 to 50 MB. Files rarely change.
Should I use the ...
3
votes
2answers
3k views
Moving Sharepoint to New Server
I am running a Sharepoint Server 2010 Stardard on a Windows 2008 R2 server.
This server also has SQL Server 2008 R2 installed.
I want to move the Sharepoint and SQL to 2 completely new machine.
What ...
3
votes
1answer
213 views
Which version of SQL Server Express gets installed with Search Server Express 2010?
What exact version of SQL Server Express 2008 gets automatically installed via the standalone setup of SSE 2010? Is it just SQL Server Express 2008, SQL Server Express 2008 R2 or a special kind of ...
3
votes
1answer
48 views
SP2010: What happens when starting several Content deployment jobs at the same time?
what happens if I start several content deployment jobs synchronously in different site collections by ContentDeploymentJob.Run()? Are the jobs definitely executed one after another?
Thanks!
3
votes
1answer
1k views
Form for user to input data and submit to run sql command
We're looking for an quick and easy way for an HR person to enter data into a couple fields and then have them click submit and have it execute some SQL Update query on the database. We don't need to ...
2
votes
2answers
504 views
Should I regularly backup and shrink my content databases through SQL?
I've been contending with hard disk space on my SharePoint 2010 (with SQL 2008) environment for a while and I've just recently found out a few things that I think might help.
Should I be regularly ...
2
votes
2answers
877 views
Changing to SQL alias after installing MOSS
Our network admin installed MOSS using the SQL Server address instead of using the SQL alias. How can we change this after the fact? We tried using a simple stsadm commmand to change server name but ...
2
votes
2answers
289 views
Installing RBS
OK I have posted other questions about this but no answers were given so I deleted them and thought I would try one last time before calling it a day...
I am trying to install RBS for SharePoint ...
2
votes
2answers
576 views
Cannot update DB record from SP timer job
I am trying to create a timer job that will read a list of new customers from a SQL server db, create a site for the customer and then update the table with the site's id. I have no trouble reading ...
2
votes
2answers
553 views
What MOSS issues can I expect with default SQL Server collation?
SharePoint installation guidance specifies that SQL Server collation should be set to Latin1_General_CI_AS_KS_WS (case-insensitive, accent-sensitive, Kana-sensitive, and width-sensitive). However, ...
2
votes
1answer
239 views
Problem with PowerShell script in Tasks Sheduler Windows Server 2008 R2 - SharePoint Shell Access?
I have a problem with PowerShell script in Tasks Sheduler in Windows Server 2008 R2. I try to run Sheduler Tasks which run batch file which run PowerShell script to Backup Farm and while I choose "Run ...
2
votes
2answers
576 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
Create reports from SharePoint lists
We currently have SharePoint 2010 Standard with SQL Server 2008 R2 Enterprise, and Visual Studio 2010 Ultimate for development. As I understand it, to be able to create reports from SharePoint lists I ...
2
votes
1answer
482 views
Two Server Sharepoint Farm Topology
I'm working on creating a product for Sharepoint and have set up a server farm consisting of two machines running Server 2008 R2.
I want to set up SQL2008 on one Machine, and SharePoint 2010 on the ...
2
votes
2answers
866 views
Import a SQL Server table into a SharePoint list to use in InfoPath
I need put the SQL table (with over 20000 records) into a SharePoint list, and use it in InfoPath.
2
votes
1answer
707 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 ...
2
votes
2answers
457 views
Migrating Windows Sharepoint Services 3.0 from Windows 2003 x86 / MSEE to Windows 2008 R2 x64 / SQL Server 2008
I am having a helluva time with this one.
I am attempting to migrate a 5 year old VM running Windows 2003 Windows Sharepoint Services 3.0 that was deployed as a standalone (thus to MSEE) to a ...
2
votes
2answers
198 views
Should we have thousands of sleeping database connections from the Crawler server?
Our IT Manager has brought up a situation where it looks like we have about 5000+ sleeping connections from the Crawl Server to our SQL Server. This seems like quite a bit and it's been slowly ...
2
votes
1answer
1k views
Tutorial to move WSS 3.0 DBs from Windows Internal to SQL 2005 Instance
I have found or have been told about a few ways to move WSS 3.0 databases from the Windows Internal Database to SQL Server 2005. As I read them, however, I find I have more questions.
Two I found ...
2
votes
1answer
212 views
What permission does my search service account need for external database searches?
The farm admin for my SharePoint site has a different Default Search Service Account login than the one I am using to create my external content types (which is my personal log in). When I am trying ...
2
votes
2answers
245 views
Database migration problem
We have recently migrated our MOSS databases from MS SQL Express 2005 to MS SQL 2008 both intances running on the same Windows 2003 server.
After "successful" migration we switched the 2005 server ...
2
votes
1answer
432 views
Why does Reporting Services in SharePoint integration mode require a minimal install of SharePoint?
I have a two machine set-up, with MOSS 2007 installed on one server (Machine A), and SQL Server 2008 installed on the other (Machine B).
In order to run SS Reporting Services in SharePoint ...
2
votes
1answer
241 views
File size too large with RBS and SharePoint 2013
since i set up my SP2013 Foundation Preview with SQL Server 2008 R2 Express i wanted to use the RemoteBlobStorage. It works seemingly fine just now.
The only problem is if my files which im uploading ...
1
vote
2answers
8k views
database size would exceed your licensed limit of 4096 MB per database
We are using sharepoint server 2007 and if i create any files and folders the sharepoint site is throwing some error "Exception from HRESULT: 0x80040E14"
and i checked event viewer.here also some ...
1
vote
2answers
379 views
Update a list via SQL with MOSS2007?
How can I go about applying an update statement to a on MOSS2007 deployment?
Essentially I'd like to write something similar to the following across it:
update <list_name>
set ...
1
vote
3answers
507 views
SharePoint 2010 - Generate reports from SharePoint Database?
It is possible to generate reports from the SharePoint Database with informations like current users, teamsites, websites etc. ?
I heard maybe it is possible with the WSS-Logging Database.
Are there ...
1
vote
3answers
6k views
Can I use a SQL Express database for sharepoint 2010?
I'm setting up a dev system with only 2 site collections, is it possible to run an express version of SQL 2008 R2?
I'm not too worried about performance, mainly that it will install and run for dev ...
1
vote
1answer
1k views
How can I tell SP installation of an existing SQL server
I wish to install SharePoint 2010 standard server but to "show" it the location of an existing SQL server, rather than have the prerquisites installation install its own sql version on the same ...
1
vote
1answer
226 views
SharePoint 2010 new server farm with shared SQL Server
Here is the situation I'm planning an upgrade from MOSS 2007 to MOSS 2010. My goal is to provision the minimum amount of new hardware. My Thought was to just setup new WFE's and re-use the existing ...
1
vote
1answer
790 views
How to design for large content databases?
Although single content databases of upto 200GB is possible in Sharepoint 2010, administering and managing such a db would be a nightmare. What would you suggest for options in a case where there is ...
1
vote
1answer
393 views
Is it possible running SharePoint Foundation 2010 on the following environment?
I would like to know if the following environment is supported by SharePoint Foundation 2010:
OS: Windows Server 2003 R2
DB: SQL Server 2005 Standard Edition (with license model for CPU)
If not ...
1
vote
2answers
495 views
Cloning a SharePoint Server 2010 (Virtual Machine) production box?
Here is the long and short:
Goal: To clone a SharepointProd VM retaining all the webapps and sites in order to debug a custom solution.
We have two virtual machines: spTest and spProd. spTest is ...
1
vote
2answers
52 views
Backing up all sharepoint web applications?
I have a sharepoint farm hooked to a named instance of SQL2008.
I have a web application (it is also extended to another web app) that I would like to back up.
Here is what I am trying to achieve:
I ...
1
vote
1answer
670 views
What benefits do I get by upgrading to SQL Server 2012 Enterprise?
With SharePoint Server 2010 Enterprise edition, what additional benefits do I get using SQL Server 2012 Enterprise edition as opposed to SQL Server 2008 R2 Enterprise edition?
1
vote
2answers
620 views
Installing SSRS on the Sharepoint Box as opposed to the SQL Box?
We currently have two SQl boxes (2008 R2) with multiple instances on them. One for test and the other for production databases.
We also have two sharepoint servers (2010 Enterprise). One in the DMZ ...
1
vote
1answer
151 views
Which identity is being used and authenticated while connection to SQL Server with Windows Authentication?
SQL Server Windows authentication uses application's process identity or thread identity to connect. So, for a solution deployed to a SharePoint farm which identity will be used to connect
Current ...
1
vote
1answer
232 views
Finding the location of the SharePoint Configuration Database in API
I'm building a .NET Health Analyzer Custom Rule which checks a few vital signs of another custom application I have built, however if the application is also deployed on a server that is also hosting ...
1
vote
2answers
108 views
Extra database server in farm
Recently I was looking at Central Admin > Operations > Servers in Farm and noticed an extra database server. It is the same name as the actual database server with "-Common" appended to the end. This ...
