Virtual Learning Platforms Thread, Sharepoint gone horribly wrong suddenly in Technical; Came in this morning to find a few reports of things not working on Sharepoint 2010.
Basically when I try ...
16th February 2011, 10:48 AM #1
Sharepoint gone horribly wrong suddenly
Came in this morning to find a few reports of things not working on Sharepoint 2010.
Basically when I try to upload a document it says
"The URL is invalid, it may reference a non existing file or folder"
I've tried rebooting the sharepoint server but no luck
Any ideas how to troubleshoot this?
EDIT: Got it I think. SQL server is producing this error
Log Name: Application
Date: 16/02/2011 09:43:28
CREATE DATABASE or ALTER DATABASE failed because the resulting cumulative database size would exceed your licensed limit of 4096 MB per database.
Last edited by zag; 16th February 2011 at 10:59 AM.
IDG Tech News
16th February 2011, 10:59 AM #2
16th February 2011, 12:02 PM #3
Yep just worked out I did a stand alone install when I created it which automatically installs sql server compact edition. I've got 2008 SQL enterprise installed on the server its just not using it!
Anyone know how to migrate sharepoint dbs?
16th February 2011, 12:23 PM #4
16th February 2011, 06:46 PM #5
you need to install full SQL Server as your limit to SQL Express is full.
You can do this 2 ways
1. Export your SharePoint environment, don't forget to include security permissions and the import it into a completely new SharePoint farm.
Export a site, list, or document library (SharePoint Server 2010)
2. Connect your SharePoint farm to a new SQL Server and remove the connection to the existing database. The connect SharePoint using database attached.
If it was me - I would do option 3
3. Create new farm that is not standard install. Build the farm with just the service application you require and then do a database attached to the new farm.
Originally Posted by zag
2 Thanks to apearce:
Trapper (16th February 2011), zag (16th February 2011)
16th February 2011, 08:34 PM #6
Is it not possible to upgrade the SQL server and keep the same Database instance?
I saw this blog post but it relates to sql server express not compact edition.
17th February 2011, 09:16 PM #7
I'm so confused after hours of googling I don't seem to be any closer to a way of fixing this.
From what I can tell, I have "compact edition 3.5" of SQL installed(not express) and all my data files are in:
There doesn't seem to be any way to connect to this with sql server manager and therefore I can't export it.
C:\Program Files\Microsoft Office Servers\14.0\Data\MSSQL10.SHAREPOINT\MSSQL\DATA
Last edited by zag; 17th February 2011 at 09:25 PM.
18th February 2011, 10:01 AM #8
You could just stop all services, copy the files, import them into a new instance, cross your fingers and hope for the best?
18th February 2011, 11:56 AM #9
Gave up in the end, Re-installing sharepoint on a new server from scratch seems to be the safest option.
This time I won't select a "stand alone" install.
18th February 2011, 12:07 PM #10
They really, really need to just take that option out. I've never seen a purpose for it (excepting installs on dev machines, but even then a farm works fine).
Originally Posted by zag
18th February 2011, 12:21 PM #11
Yep, it makes no mention that there is a 4gb limit or that SQL server compact is going to be installed. I had SQL 2008 enterprise installed before but the installer just ignored it.
Originally Posted by jamesb
And even worse Microsoft don't provide an easy upgrade route, I've read hundreds of posts online over the last few days of people making exactly same mistake. Its simply not realistic to start detaching databases on my main live SP install.
Things like this in IT drive me nuts.
Ok rant over
Thanks to zag from:
jamesb (18th February 2011)
18th February 2011, 12:27 PM #12
Of course, if it was easy none of us would have jobs.
I've actually got a similar problem. There's a live, hosted site which is in use at the moment, and is set up as a standalone which can't be expanded. Given the amount of usage the system will be getting once the full solution's deployed, it would simply snap under the strain. The solution we're going for is to assign it to someone who can keep it limping along until an actual enterprise solution is finished, at which point it gets scrapped in its entirety and everything comes in-house. Some opposition to this idea at the moment, so I may have to use your story as an illustration of why trying to upgrade is more trouble than it's worth.
22nd February 2011, 04:08 PM #13
By browolf in forum Educational Software
Last Post: 4th October 2011, 04:35 PM
By kennysarmy in forum Wireless Networks
Last Post: 10th September 2010, 10:07 AM
By TechSupp in forum Hardware
Last Post: 8th September 2010, 09:39 PM
By tosca925 in forum Educational Software
Last Post: 30th October 2007, 03:54 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)