Tagged Questions
0
votes
0answers
9 views
Which versions of sharepoint support sqlserver read commited snapshot isolation?
I have been unable to find out if Sharepoint 2010 or 2013 (or even 2007) are able to take advantage of this MSSQL feature to improve the performance of the database operations invoked by Sharepoint ...
1
vote
2answers
52 views
Workflows and SQL Server Databases
Is it possible to create a workflow that is started by activity in a SQL Server database that is outside of SharePoint?
Using a WebPart to put and modify data in a database isn't a problem. ...
0
votes
0answers
85 views
RBS with SharePoint 2010 and SQL Express 2008 / 2012.
My client has about 100GB of files loaded on a File Server. Initially the plan was to upload everything to SharePoint and bring everything under one hood.
They have SharePoint Foundation 2010 and SQL ...
0
votes
1answer
136 views
Databases for Sharepoint Foundation 2013
I recently installed Sharepoint 2013 onto a test server to look at the possibilities of upgrading our 2010 instance. After the installation, I noticed that far more DBs were created on my SQL Server. ...
0
votes
1answer
444 views
How to Create Analysis service Data Source for SharePoint Dashboard designer?
We don't have data warehouse, we want to add Reports in SharePoint dashboard designer from SharePoint list as data-source, but Reports accepts only analysis service as Data source.
So can anyone ...
0
votes
0answers
119 views
When using a SQL database connection with stored procedures is it possible to use an output parameter
I'm kind of new to attempting this sort of thing and I have some unique restrictions, so please bear with me.
I am attempting to connect to data in a SQL database through stored procedures in my ...
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 ...
0
votes
1answer
486 views
SharePoint Farm SQL Server tempdb/Crawl DB disk configuration
We've identified I/O latency on SQL Server portion of our farm. We see tempdb and CrawlDB are biggest offenders. We have 2 extra Raid 1 disks available to us. Let's call them X: and Z:. The ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
