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


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

Share point database and site collection size, and restrictions and workflow

Posted By:      Posted Date: October 19, 2010    Points: 0   Category :SharePoint
 

Sharepoint site collections

 

More Detail

 

 

We had a 3rd party into to develop the share-point service, This is really a very difficult situation not the solution but the documents that are stored and the way it was retrieved.

 

The real thing is that we receive an item it is booked into SAP and then we send an automated xml to set up a local site this site will then have details from the SAP system fed by ABAP. After the site is created, and then we add documents files and .jpg. These documents must show a detailed audit trail so that if challenged in a court of law can show who had access and who updated documents. 

 

SO the problem is 

 

1 Site Collection that is 170gig and the design means that we have 1600 sites and these contain images that are stored in the single site collection. How do we remove the full documents and images and replace with links rather than the doc, img. 

 

2. We have around 8 business units the problem is that they can share information acros


View Complete Post


More Related Resource Links

How to create WSP or Package for workflow in Share Point 2007?

  

Hi,

I am working on SharePoint 2007. I have created 2 List called "Config List" (this is a list) and "Vacation Form" (this is form library & form designed in infopath). I have also created a workflow on form library "Vacation Form" in Share Point Designer 2007.

With the use of this workflow I am creating some task and updating "Vacation Form".

Now I want to deploy these three thing (Config List, Vacation Form & workflow) on other server.

How do I create a package or WSP file to install these things on different server.

 


G. Goyal

Share Point integrated SSRS reports rendering when access from external site

  

Our client has a SharePoint (moss2007) site on Windows 2008, SQL2008 R2 Enterprise, and Reporting service is integrated with SharePoint

The authentication on the share point integration is set to windows, else the authentication for the SSAS datasource gives and error

The extranet zone ( forms) and intranet (Customer Forms) and default (Windows) zones are all access from inside the firewall and the reports render in each with no issues, as the datasources are configured to pass a sql username and password.

However, report rendering is a problem from the internet (external site), the following error is displayed:

 
An unexpected error occurred while connecting to the report server. Verify that the report server is avai

site collection size

  
what is the solution of a site collection if its size grows beyond 100GB?  There is no way we can split it into two site collections and the content database will be large than 100GB even if it contains a signal site collection. Thanks in advance, Peter  

Share Point Designer 2007 Workflow (Sequential) - multi-collect data from user

  
I am currently building a multi-step workflow using ShrePoint designer for MOSS2007. I am getting a bit confused as to if I have an error or if I am doing something incorrect. Here is what I have going. My workflow consists of something similar to the following New document comes in, a collect data from user routine is ran and assigned to a reviewer. My understanding when I create a collect data from user WorkFlow step is any data I request is saved in the "Tasks" list. Therefore I need to grab the workflow task ID in order to later lookup what the reviewer submitted... I understand this...   However, I have one more collect data from user workflow step and I have one more item to collect. Even though this is a brand new collect data from user workflow step - does the collected data still go into the "Tasks" list? In other words, if I have two steps in a workflow and both of these steps are "collect data from user", does the data from both steps go into the same "Tasks" list?  I could see how this might be possible as long as the Task list columns contain all the items for all the different "collect" data from user steps.  I don't see two different Tasks lists representing or named "Reviewer" or "Final" or anything, so I assume the items are all in "Tasks"   However..

How to find newly added item in the share point site?

  
How to find the recently added item in the share point page If the any user added the items in the custom list, library, list,Announcement, Picture library,etc......... i need to show all item that added last 2 days. Is that any object model available to find all item in the share point site???Instead of searching every list.

how to recover the site collection from restored database

  

Hi,

i have a backup of one database which is used by existing web application. I want to access the same contents with different web application. i have created a web appln with restored database,and i could not see the site collections which are in existing web application. Please guide me to get the site collections. Please correct me if my approach is wrong...

Thanks in advance.


How to make Quicklaunch of share Point site movable?

  
Hi

How to make Quicklaunch of share Point site movable?(so is its not needed , it should be moved to leftmost direction)

                                                                                     Thanks and Regards,
                                                                                          Swati

Workflow or Time Job for email reminder on Tasks List in Share Point 2007

  

I need to send a reminder to the person whom a task has been assigned 3 days before a due date. We also wants to re-use this workflow/time job on other lists as well. Name of the lists can be different??

 

Also if the due date gets change it should change the reminder accordingly.

Which approach i should take to achieve this?? 

Regards

Deep

 


Repeating Sections in Share point designer workflow

  

Hi

 

I created repeating section drop down. This drop down gets data from the list.

 

Now i create a work flow in a share point designer. I want to get all the repeating values in the work flow which i want to send a email with all values.

 

But in share point designer i can get only ROOT value, and can not get the child.. Means the first value of the section, not others.

 

Please help me to get all the values.


Delete a Site Collection without a Content database

  

I have a site collection whose content database has been deleted with no backup. Now I want to delete the site collection and i get what seems to be a sql login error. I know the account I am using has enough access to the sql server (used this account to install sharepoint). I am guessing it is complaining because it can't find the database.

Remove-SPSite : Cannot open database "WSS_Content_Database" requested by the lo
gin. The login failed.
Login failed for user 'DOMAIN\PowerfulAccount'.
At line:1 char:14
+ Remove-SPSite <<<<  https://sitename.domain.com/mysite/username
    + CategoryInfo          : InvalidData: (Microsoft.Share...mdletRemoveSite:
   SPCmdletRemoveSite) [Remove-SPSite], SqlException
    + FullyQualifiedErrorId : Microsoft.SharePoint.PowerShell.SPCmdletRemoveSi
   te

I used the Remove-SPSite <URL of site to delete> command.

Any ideas?

Thanks, Berney


Create workflow to create list item in calendar list of a DIFFERENT site collection

  

I work for a school district.  Each school has a SharePoint calendar.  We set up each school as its own site collection.  I would like to create a workflow that would send their calendar events to a district calendar, which is also its own site collection.

Example,  School A enters creates a new item on their personal school calendar.  They click YES in the column called SendToDistrictCalendar.  The workflow would be triggered to create this same item in the district calendar (which is in a different site collection) when SendToDistrictCalendar is checked YES.

We're using Windows Server 2003 with Windows SharePoint Services 3.0

I am a mid-level SharePoint user.  I would appreciate ANY and ALL help to make this work!!

 


creating custom table in share point database in sqlserver is fine ?

  

we are creating custom table in share point database in sqlserver.


is it fine to create custom table?

are we violating any rule  because of the creation of custom table ?

does share point recommended to create custom table  ?


Delete a Site Collection without a Content database

  

I have a site collection whose content database has been deleted with no backup. Now I want to delete the site collection and i get what seems to be a sql login error. I know the account I am using has enough access to the sql server (used this account to install sharepoint). I am guessing it is complaining because it can't find the database.

Remove-SPSite : Cannot open database "WSS_Content_Database" requested by the lo
gin. The login failed.
Login failed for user 'DOMAIN\PowerfulAccount'.
At line:1 char:14
+ Remove-SPSite <<<<  https://sitename.domain.com/mysite/username
    + CategoryInfo          : InvalidData: (Microsoft.Share...mdletRemoveSite:
   SPCmdletRemoveSite) [Remove-SPSite], SqlException
    + FullyQualifiedErrorId : Microsoft.SharePoint.PowerShell.SPCmdletRemoveSi
   te

I used the Remove-SPSite <URL of site to delete> command.

Any ideas?

Thanks, Berney


how to Selec site Tempalte Picker using Code in Share point 2007

  

Hi Guys,

My Requirement is: I have an page it's coming from _Layouts,that page contains one Template Picker Control(share point control).so it showing all site templates like Team site,Wiki site etc.

But My Issue is i have site template id like "STS#1" Now i need to show  this site template in  Template Picker Control using c# or Object model code.how to do that right know it selected  Default site template.

Thanks In Advance.

Murali krishna.T

 


Suggest best way to do this approval workflow for share point form library.

  

I have created the Info path form.

Once the new form created i need to send the email to users which the user selected in the people picker field.

Is that possible to do this using Designer,or VS 2010.

Give some reference to do this.


site collection size

  

We have site collections, some of them keep growing and reach about 100GB level.

Should we keep them growing?   

Should we split the site collection and how?

Any suggestions to dealing with this situation?  

Thanks,

Peter 

 


Does whole site collection data stored only on database

  

Hi All,

Does the whole data belonging to site stored in database or part of the data also gets stored some where else? We have restored a content database but few stes are missing on new server and when we take the backup of site on new sevrer the backup comes as 100 KB , but if we take the site backup on new server the backup size comes as 6GB, tht is a big difference. So i am a dba and have no idea on how the sharepoint stores the data. Please advice...


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