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


Post New Web Links

Does whole site collection data stored only on database

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

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...




View Complete Post


More Related Resource Links

Site Collection Usage Summary: No Data Available

  

Usage analysis processing is enable for my farm in both Central Administration and in the SSP.

I've checked TImer Job Status and the three timer jobs responsible for doing the log analsis are all running.

I've also checked the log file locations and the log files are being generated.

Yet when I browse the "Site collection usage summary" report (SpUsageSite.aspx) I get the following:

No data is available for this report. Usage analysis might have been enabled only recently, or there might have been insufficient usage to result in any values for the report.

My farm is running 2007 Enterprise SP2 (12.0.0.6421).

Can someone confirm if this issue was fixed with one of the CU's that were issues post-SP2?


Attach site collection data from content databases

  
I have migrated my Sharepoint from a stand-alone installation to a server farm installation by following this article. http://technet.microsoft.com/en-us/library/cc262325%28office.12%29.aspx Every step was completed successfully, except for the last one (4): Install Office SharePoint Server 2007 on a new farm Move databases from the stand-alone server to the server farm Create and attach data from the Shared Services Provider (SSP) Attach site collection data from content databases Whenever I try using the stsadm -o extendvs I get the following message: The IIS Web Site you have selected is in use by SharePoint.  You must select another port or hostname.   The following is the command: STSADM.EXE -o extendvs -url http://dms01 -ownerlogin group\dms -owneremail dms@xxx.com -exclusivelyusentlm -databaseserver jagrb -databasename WSS_Content -apcreatenew -apidname DMS -apidtype configurableid -apidlogin group\dms -apidpwd xxxx   So far, all my efforts to Attach the site collection data from the content databases have failed. Any ideas?

CAML query to access List data across multiple site collection.

  
Hi   Is there any way to get the Task List data across multiple site collection using CAML query. Currently, I have the code which will retrieve the data from a single site collection. Below is the code.                           /***************************************************I am using Moss2007.Thanks!Ravi             SPSiteDataQuery q = new SPSiteDataQuery();             q.ViewFields = "<FieldRef Name=\"Title\" />" "<FieldRef Name=\"Status\" Nullable=\"TRUE\"/>";             q.Lists = "<Lists ServerTemplate=\"107\"/>";             q.Webs = "<Webs Scope=\"SiteCollection\"/>";             q.Query = "<Where>" +                                "<Eq>" +                                     "<FieldRef Name=\"Status\" />" + "<Value Type=\"Choice\">Not  Started</Value>" +                                     "</Eq>" +                         "</Where>";             DataTable dt=null;             using (SPSite s = new SPSite("http://banglabguest1:31000/"))             {                 SPWeb w = s.OpenWeb();                 dt = w.GetSiteData(q);                 w = null;             }                              *************************

Site Web Analytics reports and Site Collection Web Analytics reports show no data

  
Although I have enabled all the web analytics and health data collection option and can see that usage data files are being created both my Site Web and Site Collection analytics reports show no activity. I have checked the Sharepoint 2010 documentation and it basically states only thing to do is enable the respective option under the 'Configure web analytics and health data collection' section.

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.


Calling Stored Procured in SSIS from database moving data into another Database

  

Hey,

 

I am just wondering if this is a feasible option within SSIS.

I have a source database on one server, a destination database on another server

The source database has a stored procedure which returns lets say 500 records. 300 are inserts the rest updates. (Based on some column)

So in SSIS I call this SP, following this im able to loop through the records returned figure out wether its Insert or Update and then move the data to destination table.

 

Cheers


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


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


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

  

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

How do I limit size of Usage ( Usage and Health Data Collection ) database size please?

  

Hi

How do I control the size of my usage database ( Usage and Health Data Collection database ) in SP2010 so it never exceeds a certain size?

Its not clear how you do this - does anyone know? I want to set it so it never exceeds 100 GB in size but logs pretty much everything.

Thanks in advance,

Steve


How to Specify Content Database for a Site Collection Restore from Backup

  
Hello,

I have prepared code that first creates a new Content Database within a specified Web Application, then restores a Site Collection backup to that same Web Application.  Unfortunately, the Restore doesn't provide an option to select the Content Database that was just created.  So, is there something that I might do to ensure that the Site Collection gets restored to the Content Database of my choice, programmatically?  If not, is there something I can do to change the Content Database for the newly restored Site Collection?  All ideas would be appreciated.

Thank you,

Doug

Creating Site Collection in Existing Content Database

  
Hi All,

I'm trying to create a site collection in a existing content database. I haven't found a method in Sharepoint object model to perform such a action. There is an option to create a site collection in a new database using the following command:
                                                                
SPSiteCollection.Add(url, siteDescription, siteDescription, 1033, siteTemplate,
                                                                siteCollPrimaryAdmin.LoginName, siteCollPrimaryAdmin.Name, siteCollPrimaryAdmin.Email,
                                                                siteCollSecondaryAdmin.LoginName, siteCollSecondaryAdmin.Name, siteCollSecondaryAdmin.Email,
                                                                strSQLServerName, siteContentDBName, null, null);

Is there a different object to do this creation on existing database? Any ideas to approach this problem will be greatly appreciated

Thanks,

vgurusam


transfer data from a database to another using a stored procedure

  

I need to transfer data  from a database to another using a stored procedure in a C# application. I have some tables in the first database and I need to transfer data from them in others tables from the second database, not all columns but few of them.

How should I do that?

 

Thank you for your time!

 


ucsel

External Data Option Not at Site Collection Level

  

Hello all,

It appears that I can only create an External Data field at the library level for a content type. Can anyone validate if this is true. Following a good practice of creating all content types and site columns at the Site Collection I used for my Content Type Hub allows me to create content types/columns only once and have them sent across to any libraries they have been added to.

In the current scenario, if I need to use a Content Type with External Data, in lets say, 12 other libraries, I have 12X the work!


How to create another site collection with different database

  

Hello

I have an existing site with single site collection with team site as. http://moss . Then I created another site collection using existing http://moss using team site template, now new url is http://moss/sites/new. It is very straightforward approach and works perfect. But I noticed it is using same content databse which was using by http://moss. During creating seprate site collection it wont ask for content database. In my case I already have another 2007 content database which I restoerd in sql server 2008. I want to attach this databse with second site collection. I know I can use mount powetshell command, but my problem is that I dont how to detach the original content database from 2nd site collection and attach or mount another database.

Please advise


i need to crawl the data from particular site's database.

  
i need to crawl the data from particular site's database. Is it possible? they may protect their database. am i correct?. please reply me.

data not stored in series in database

  

hii guys,

this is a huge problem

i have a database in sql and datagrid in vb.net. when i am storing records in database, they are stored in series until the 10th record.

as soon as 10record is saved, it comes exactly after 1st record. likewise,11th record is below 10th record. so the database looks like:

1
2
10
11
12
13
14
15
16

3
4
5
6
7
8
9

 

and this is the same problem i am facing in vb.net as table is connected to vb.net via datasets.

i have assigned varchar as datatype to "stud_id" colukn.

 

 

 

guys pls help out or else my hard work of so many months will go waste and software will not be accepted by the client!!!!


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