.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
MarieAdela
Imran Ghani
Post New Web Links

what is the sharepoint service 3.0 database limitation

Posted By:      Posted Date: September 28, 2010    Points: 0   Category :SharePoint
 

My sharepoint uses sql express, it has 4GB database size limit, is that possile to migrate the database from the express to a standard version?




View Complete Post


More Related Resource Links

problem rename sharepoint 2010 search service application admin database

  
Hi all, i have a problem that hopefully someone has an answer to.  i am not too familiar with sharepoint so please excuse my ignorance. we have sharepoint 2010 on a windows 2008r2 server.  everything seems to work fine.  but as you know, the default database names are horrendous.  i have managed to rename all of them, except for the "search service application" admin database. the default is: Search_Service_Application_DB_<guid> the other 2 databases (crawl and property) were renamed without a problem. we are following the article from technet on how to rename the search service admin db (http://technet.microsoft.com/en-nz/library/ff851878%28en-us%29.aspx).  it says to enter the following command: $searchapp | Set-SPEnterpriseSearchServiceApplication -DatabaseName "new database name" -DatabaseServer "dbserver" however, i get an error about identity being null.  no big deal, i add the -Identity switch and the name of my search service application.  but the real problem comes the error it throws:   Set-SPEnterpriseSearchServiceApplication : The requested database move was aborted as the associated search application is not paused. At line:1 char:54 + $searchapp | Set-SPEnterpriseSearchServiceApplication <<<<  -Identity "Search Service Application" -DatabaseName "ShareP

sharepoint 3.0 service, database backup restore

  

I am using stsadm to run daily backup of the server, but would like to run hourly database backup, not sure if it works to restore database and log for sharepoint service 3.0, the db is on sql 2005 embedded edition. does any one know or has any suggestions to backup WSS3.0 hourly?

I tried the backup restore feature in the admin site, didn't get it work when last time the server crashes, so right now only use stsadm backup / restore.


Manually specify database name for Microsoft SharePoint Foundation Search Service Settings

  

Hi Team,

I wanted to specify database name manually for Microsoft SharePoint Foundation Search Service under Application management | Manage services on server | Sharepoint Foundation Search . Under Search database settings,  it says 'Use of the default database server and database name is recommended for most cases. Refer to the administrator's guide for advanced scenarios where specifying database information is required.' . Specifying database name field is coming grayed out and can't have option to specify my own database name. Any help to specify database name for foundation search will be highly ppreciated.

 

Thanks

Regards,

rohit



attach access database in SharePoint 2010 service application

  

I am planing to publish Access database MyDB into Access Service application in SharePoint 2010 server farm. MyDB has following tables,

tblShared1, tblShared2, tblShared3, tblShared4, ... 

Is that possible for each user to open an Access database locally and set linked tables above in MyDB Access database? If yes, how it works?

Thanks in advance,    



Web Service for uploading documents into SharePoint

  
WS UploadService is a web service written for Microsoft Office SharePoint Server 2007 and Windows SharePoint Services 3.0 and is meant for uploading documents into SharePoint. I have just uploaded the zip file to GotDotNet.com so it will take some time before the zip file appears in the list of downloads. For the time being, you can download the zip file from the following location

Sharepoint site shows Service Unavailable

  

Hello everyon,

I am working sith WSS 3.0.

I have one webapplication with one sitecollection.Later i wanted to provide it HTTPS URL, so i extended the WebApplication with option-Yes in SSl field.

And in the virtlay directory properties -> Directory Security -> Secure communications -> Edit

selected Required Secure Chanel.

Thats it. I didn't do anything in that.

 

Then because of some problems , i deleted the iis website of extended webapplication from central admin.

After that when ever i try to open the site, it shows service unavailable.  And the application pool is getting disabled.

Please help me to get the site working.

 

Thanks in advance.

 


RDL Rendering (500 Internal Server) Error at Sharepoint Integrated Reporting Service

  

I have a serious problem that cannot be solved by googling around the keywords below:
sharepoint, moss 2007, reporting service, ssrs 2008, rendering, internal server error, ....

The error is;

"An error occurred during client rendering. The remote server returned an error: (500) Internal Server Error. "

Everything is O.K.;

* When I render the report from the REPORTSERVER (http://localhost/ReportServer)
* When the reports are scheduled to be sent by the reporting service (planned via MOSS 2007) 

But if I open (render) the RDL file from the sharepoint REPORTS LIBRARY interface, all of the reports fail with that internal error message above. 

It is weird also that parametrized reports are displayed without errors although the parameters are queried from a sql dataset. But I got the error when rendering the report after I've chosen a parameter  and order "apply/report"...

Possible causes how I met that error may be;

After I have installed (then uninstalled) AJAX extensions
After I have re-configured IIS Web Service Extensions list items

Possible solution alternatives I've found;

I've found a solution on MSDN replying a similar issue with an ideal cause of the error but an evreka answer but no sol

Video: SharePoint 2010: Creating Custom Service Applications

  
Do you need more than the services provided by SharePoint? In this advanced session targeted at high-end developers, you will learn how to create a custom SharePoint service. (Length: 36:31)

SharePoint List with Hyperlinks Stored in a Database

  

To all,

I need to display a List of Hyperlinks that are stored in a database. I want it to be a SharePoint List so it can be Indexed and Search properly in SharePoint.

SharePointSite Table - Columns:SiteName(nvarchar(256)), URL(nvarchar(256))

Example: Acme Foods, http://www.acme.com

I need a List that shows:

Acme Foods and is a clickable hyperlink  to http://www.acme.com

What is the best way to get access to the data and feed it to a List and then host it on a Site landing page?

This is meant to be a directory of Site Collections. We have 175 Site Collections that host our customers Report Libraries.

Thanks,
Eric

 


Update SharePoint List item using UpdateListItem web service with javascript

  
I'm using the Custom_AddListMenuItems function in a CEWP to add a menu item to each list item to Archive that item. This is achieved by updating a choice field in the item to 'Archived'. I'm trying to do this using the web service UpdateListItem web service to update the item using Javascript, but I can not find the correct code that updates the list item. I'm using this code:     var ctx=currentCtx;     var ciid=currentItemID;     var xmlHttp=null;     if (confirm("Are you sure you want to Archive this item?"))     {         var soapRequest = '<?xml version="1.0" encoding="utf-8"?>'+             '<soap:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">'+             '    <soap:Body>'+             '        <UpdateListItems xmlns="http://schemas.microsoft.com/sharepoint/soap/">'+         

SharePoint 2007 uploading document limitation <=6 record ??

  
Dear Expert, I've 1 project of sharepoint which is involved a scanning solution + sharepoint (document library) People will scan a set of invoice thru scanning device and then export to sharepoint (document library) as a PDF file. 1 invoice may have many sheet, but our scanning solution will group it into 1 and save as 1 pdf. After upload to sharepoint (document library) my Workflow will start to running and routing for approval But if they upload more than 6 invoice then the 7th invoice will get a error on WF to start (intermittent case).  Isit sharepoint have a limitation number of uploading??  

sharepoint New Item form database table

  
hi, i want to know if i create a custom list in sharepoint designer and i modify it with my own fields. when the user filled this form where in the database are the filled data stored. thus in witch table in the wss_content db will the data be stored?

SharePoint Version 2.0 (WSS 2.0 SP3) Content Database restore to new farm

  
Is it possible to use an SQL backup from a sharepoint Version 2 SP3 database to restore the content on a new server farm and attach to a new web applicaiton. NOTE: This is WSS 2.0. In WSS 3.0 this is a very simple task, but it is not the same in WSS 2.0 (the add content database option CANNOT be used to attach to an existing content database like it does in WSS 3.0). The options I have found appear to say you need the configuration database from the old server then it can be done. I am migrating from an outsourced deployment, so I do not have access to that. Plan B is to do a sharepoint STSADM backup. THis seems to be a more likey way to do it.

SharePoint Database Consistency Errors

  
Hi All, I have noticed that my sharepoint content database contains many database consistency errors. I have run following SQL command to verify these errors ALTER DATABASE your_database_name SET SINGLE_USER WITH ROLLBACK IMMEDIATE DBCC CheckDB ('your_database_name', REPAIR_REPAIR_FAST) ALTER DATABASE your_database_name SET MULTI_USER Now I want to remove them safely with any application error. Is there any method to remove these errors ? For Information: I know following SQL commands will remove these consistency errors but with data loss. I want to know what type of data will be lost and whether it is safe to run below commanrds with REPAIR_ALLOW_DATA_LOSS parameter ALTER DATABASE your_database_name SET SINGLE_USER WITH ROLLBACK IMMEDIATE DBCC CheckDB ('your_database_name', REPAIR_ALLOW_DATA_LOSS) ALTER DATABASE your_database_name SET MULTI_USER Thanks and Regards..  

Windows SharePoint Services v3.0 Database Error

  
Hi Below is the error from event viewer on the server based on the Above Event Type:     Error Event Source:  Windows SharePoint Services 3 Event Category:          Database Event ID:         3758 Date:               3/18/2009 Time:               4:38:40 PM User:                N/A Computer:       FIB-PORTAL Description: Database full error on SQL Server instance 'FIB-PORTAL\OfficeServers' in database 'WSS_Content'. Additional error information from SQL Server is included below.   Could not allocate space for object 'dbo.EventCache'.'EventCache_Id' in database 'WSS_Content' because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup.   For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.   Event Type:     Error Event Source:  MSSQL$OFFICESERVERS Event Category:          (2) Event ID:         1827 Date:               3/18/2009 Time:               4:38:40 PM User:                FIRSTINLAND\sharepointadmin Computer:       FIB-PORTAL Description: CREATE DATABASE or ALTER DATABASE failed because the resulting cumulative database size would exceed your licensed limit of 4096 MB per database.Any ideas on the Solution to the Above Issue...Best Regards,Adeoye...

Problem Integration SQL Reporting Service 2005 and SharePoint 2007

  
Hello, I'm trying to make our SQL Reports available on our SharePoint report center. I have SQL 2005 (sp3) report server that resides on a different server than our SharePoint 2007 server. So in our SRS Configuration Tool, we changed the database mode for SharePoint integration (before, we only had it in native mode), so we created a new database for this SharePoint Integration type. Next, I installed the Report Server Add-in for SharePoint 2007 server and it was successful. However when configuring the Report Server, we got stuck at the step "Grant Database Access". For some reason we keep getting error message "Named instance not found" We already installed Service Pack 3 on the Report Server... I heard that the problem is because the mismatched version between the Report Server Add-in in SharePoint and the SQL RS version... but I don't think this is the case for us. Do we need to install WSS on our Report Server too?     Another question: We already integrate our Report Server with Microsoft Dynamics CRM 4.0. However I see that when the Report Server is in the SharePoint Integration mode, all the reports in CRM don't work (because Report Manager is no longer available in this mode). Do you think it would be the best practice to install a copy of Report Server instance in our SharePoint 2007 server? Thank you, greatly appreciate all your hel

Problem Integration SQL Reporting Service 2005 and SharePoint 2007

  
Hello, I'm trying to make our SQL Reports available on our SharePoint report center. I have SQL 2005 (sp3) report server that resides on a different server than our SharePoint 2007 server. So in our SRS Configuration Tool, we changed the database mode for SharePoint integration (before, we only had it in native mode), so we created a new database for this SharePoint Integration type. Next, I installed the Report Server Add-in for SharePoint 2007 server and it was successful. However when configuring the Report Server, we got stuck at the step "Grant Database Access". For some reason we keep getting error message "Named instance not found" We already installed Service Pack 3 on the Report Server... I heard that the problem is because the mismatched version between the Report Server Add-in in SharePoint and the SQL RS version... but I don't think this is the case for us. Do we need to install WSS on our Report Server too?     Another question: We already integrate our Report Server with Microsoft Dynamics CRM 4.0. However I see that when the Report Server is in the SharePoint Integration mode, all the reports in CRM don't work (because Report Manager is no longer available in this mode). Do you think it would be the best practice to install a copy of Report Server instance in our SharePoint 2007 server? Thank you, greatly appreciate all your hel
Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend