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


Top 5 Contributors of the Month
Kaviya Balasubramanian
Sgraph Infotech
Imran Ghani
Post New Web Links

Attach site collection data from content databases

Posted By:      Posted Date: September 03, 2010    Points: 0   Category :SharePoint
 
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?


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?


cross site-collection content query wp

  
Hi,How can i override the Content query wp so i can query data from other site collection? Is it possible?How? Recommended ways? alternatives? references?the site collection is under another site collectioni did some googling and only found a comercial wp for this..tks

content Type at site collection level using feature.

  
I m planning to create a feature to install the content type and site colomun at site collection level. Now my doubt is? 1. what will happen when i de activate a feature with documents already there? 2. what will happen when i de activate a feature without documents? What are points i need to take care? 

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.

Is there any way to populate an InfoPath form field with the data from the site content type column?

  

I have a Form library with a form template.

The templat has a field "Office name" which should not be a fixed list of values, but a dynamical list, feeded from a different type of form. I'm a novice with InfoPath - Sharepoint and I want to find out, how can I can give users a possibility to create and maintain a list of offices and also have this list as a selection list inside main library form - ALL inside one library, if possible.

I assumed that if I publish main form (Itinerary) as a library template form and lookup form (OfficeInfo) as a SiteContent, I should be able somehow to connect to siteContent column and it's information. But I cannot see how - Site Content Gallery is not appering as a Connection item.

Can I use SiteConenct for this purpose or there are other ways to create end-user lookup lists?

Thank you!

 


How do I view all content of the root site in my collection?

  
Since the Quick Launch menu is not part of the home page of a site collection, how do I gain access to the View All Site Content list?

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


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


Lookup column across site collection that are in different content DB

  
Is there any solution to create a custom look up column that get the data from lists in different site collection that are different content DB?

How to Deploy MOSS Site Collection using backup/restore with DB attach

  
Can anyone give pointers on Deploying Moss Sites from Development Environment to Production Envirnment Using backup/restore with DB attach?? TIA
Thanks, Devi Prasad M

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

Wss v 3 site collection - can't add /change /edit any content

  

Hi guys,

I have noticed a very strange thing in my wss v 3 site. Since a few days Nobody can add / modify / delete contents of site. Site actions button give only Site settings options, Not like before edit page etc, View all site content does not show Create button. Any document library or list does not shpow anything but Actions button.  It is clearly a lost permission issue, however  when I checked and rechecked all of those are correct. I'm even login as an administrator which is listed as site collection admin and nothing. STSADM.EXE" -o backup -url let me do a backup however option restore give access denied HRESULT: 0x80070005 (E_ACCESSDENIED). Of course I'm running as site collection admin. Where to look for answers ?


Reset site collection content types

  

Hi,

I have a "Test Document" content type inheriting from the default "Document" content type which, in turn, inherits from "Item". The "Test Document" is a MS Word template document (as is "Document").

I went into the "Site Settings" of the site collection, selected "Site content types" -> "Document" -> "Advanced Settings" and while the "Update all content types inheriting from this type" was set to Yes, I clicked OK.

Now when I go back to the documents library and open the "New" menu to create a new document, both the "Document" and the "Test Document" logos are changed to plain icons (not the MS Word icons it had before) and when I click it I get the "Upload Document" dialog.

Is there a way to restore the site collection's content types to their default settings?

 

Thank you,

Sagy


Sagy Langer SLA Software Systems www.sla.co.il

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


Join related data by using content types and site columns?

  

Hi guys

Say for instance if I have process column and a sub - process column, and if I chose a process I want to only show the relevant sub - processes instead of all. I need to solve this by using content types and site columns. Any ideas, or guides on how I can acheive that?

Regards


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