+ Post New Thread
Results 1 to 13 of 13
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 ...
  1. #1
    zag
    zag is offline
    zag's Avatar
    Join Date
    Mar 2007
    Posts
    3,738
    Thank Post
    894
    Thanked 414 Times in 348 Posts
    Blog Entries
    12
    Rep Power
    85

    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

    Sharepoint_Upload_Problem.jpg

    "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
    Source: MSSQL$SHAREPOINT
    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 09:59 AM.

  2. #2
    HMCTech's Avatar
    Join Date
    Apr 2008
    Posts
    618
    Thank Post
    37
    Thanked 48 Times in 35 Posts
    Rep Power
    22
    SQL Express?

  3. #3
    zag
    zag is offline
    zag's Avatar
    Join Date
    Mar 2007
    Posts
    3,738
    Thank Post
    894
    Thanked 414 Times in 348 Posts
    Blog Entries
    12
    Rep Power
    85
    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?

  4. #4

    Join Date
    Mar 2008
    Location
    Surrey
    Posts
    2,160
    Thank Post
    98
    Thanked 318 Times in 260 Posts
    Blog Entries
    4
    Rep Power
    111

  5. #5
    apearce's Avatar
    Join Date
    Feb 2008
    Location
    Birmingham
    Posts
    412
    Thank Post
    34
    Thanked 175 Times in 110 Posts
    Rep Power
    43
    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.

    A.



    Quote Originally Posted by zag View Post
    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

    Sharepoint_Upload_Problem.jpg

    "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

  6. 2 Thanks to apearce:

    Trapper (16th February 2011), zag (16th February 2011)

  7. #6
    zag
    zag is offline
    zag's Avatar
    Join Date
    Mar 2007
    Posts
    3,738
    Thank Post
    894
    Thanked 414 Times in 348 Posts
    Blog Entries
    12
    Rep Power
    85
    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.

  8. #7
    zag
    zag is offline
    zag's Avatar
    Join Date
    Mar 2007
    Posts
    3,738
    Thank Post
    894
    Thanked 414 Times in 348 Posts
    Blog Entries
    12
    Rep Power
    85
    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:

    Code:
    C:\Program Files\Microsoft Office Servers\14.0\Data\MSSQL10.SHAREPOINT\MSSQL\DATA
    There doesn't seem to be any way to connect to this with sql server manager and therefore I can't export it.
    Last edited by zag; 17th February 2011 at 08:25 PM.

  9. #8

    Join Date
    Mar 2008
    Location
    Surrey
    Posts
    2,160
    Thank Post
    98
    Thanked 318 Times in 260 Posts
    Blog Entries
    4
    Rep Power
    111
    You could just stop all services, copy the files, import them into a new instance, cross your fingers and hope for the best?

  10. #9
    zag
    zag is offline
    zag's Avatar
    Join Date
    Mar 2007
    Posts
    3,738
    Thank Post
    894
    Thanked 414 Times in 348 Posts
    Blog Entries
    12
    Rep Power
    85
    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.

  11. #10

    Join Date
    Mar 2008
    Location
    Surrey
    Posts
    2,160
    Thank Post
    98
    Thanked 318 Times in 260 Posts
    Blog Entries
    4
    Rep Power
    111
    Quote Originally Posted by zag View Post
    This time I won't select a "stand alone" install.
    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).

  12. #11
    zag
    zag is offline
    zag's Avatar
    Join Date
    Mar 2007
    Posts
    3,738
    Thank Post
    894
    Thanked 414 Times in 348 Posts
    Blog Entries
    12
    Rep Power
    85
    Quote Originally Posted by jamesb View Post
    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).
    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.

    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

  13. Thanks to zag from:

    jamesb (18th February 2011)

  14. #12

    Join Date
    Mar 2008
    Location
    Surrey
    Posts
    2,160
    Thank Post
    98
    Thanked 318 Times in 260 Posts
    Blog Entries
    4
    Rep Power
    111
    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.

  15. #13
    zag
    zag is offline
    zag's Avatar
    Join Date
    Mar 2007
    Posts
    3,738
    Thank Post
    894
    Thanked 414 Times in 348 Posts
    Blog Entries
    12
    Rep Power
    85
    Fixed it!

    Blogged about it here

    Sharepoint 4GB limit - Blogs - EduGeek.net

SHARE:
+ Post New Thread

Similar Threads

  1. another promisor update gone horribly wrong
    By browolf in forum Educational Software
    Replies: 24
    Last Post: 4th October 2011, 03:35 PM
  2. If your network suddenly goes slow.....
    By kennysarmy in forum Wireless Networks
    Replies: 4
    Last Post: 10th September 2010, 09:07 AM
  3. Monitor going suddenly blank?
    By TechSupp in forum Hardware
    Replies: 2
    Last Post: 8th September 2010, 08:39 PM
  4. Odyssey Software suddenly not working.
    By tosca925 in forum Educational Software
    Replies: 1
    Last Post: 30th October 2007, 02:54 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •