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


Top 5 Contributors of the Month
david stephan
Santhakumar Munuswamy
Asad Ali
Fauzul Azmi
Post New Web Links

Delete a Site Collection without a Content database

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

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




View Complete Post


More Related Resource Links

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


Delete Site in Collection

  
Hello! I have a site collection with 100+ subsites and I needed to remove one the subsites. I usually go into the subsites site settings and choose "delete this site" and it has always worked without issue. Well...I had a large site(10 GB) I needed to delete last week so I used my ususal method. The first thing I noticed was system performance tanked. You couldn't even navigate to sites. When the delete finished all that was gone was the security groups. All the site content was intact. I thought possibly there was a problem with the site being so large so I deleted all the libraries and lists using sharepoint designer and/or the UI. I verified nothing was in the sites recycle bin or the site collections recycle bin and tried deleting again. Same results. A colleague suggested I try deleting from the command line (stsadm.exe -o deleteweb). Results were the same. Does anyone have any suggestions on how I can delete this subsite. Thanks in AdvanceRenee P.S. I also tried deleting from Sharepoint Designer with same result.ReneeDD

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

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?

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? 

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.


Cannot delete certain site column(s) from new content type

  

Hello,

I make a new content type, based of event.

If I add the (existing) site columns, Active, Aliases, Article Date, Byline (and some others?), these columns cannot be deleted afterwards!

is there a workaround ? 

Thank you 

P.S. After testing, this also happens in 2007.

 


Christos

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?

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


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

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?

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

WSS v 3 Can't Create/Modify/Delete any content in the site

  

Dear Support,

I would like to share with you a situation which I'm experiencing right now. WSSv3 Site is

My WSSv3 site which serves us as an intranet has become acting a bit weird. As before anyone listed in Site user and permissions can access the site. However the people listed as site owners or site collection administrators can't Add / modify edit any content to a site.  What I meant is when View All site Content button is selected No Create button is present to create a new document library or list . Selecting Site actions button give no other choices but Site settings ( no edit page etc ), when inside any document library or list no other buttons are present than Actions ( to View RSS Feed ). When I try to create a new content by going to Site settings Site libraries and list create new content site is asking me for credentials. Funny is that I 'm listed as collection administrator as well as site owner together with administrator account.

It seems as a security permission issue , however whenever I checked I'm site owner and site collection administrator (Site Central Administration - Application Management - Site Collection Administrators). When I use STSADM.EXE -o backup backup is being done however when I use a restore switch I got an error : Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED)


Site Admin Can't Delete Content In Document Library

  

Hello,

I am the admin of a site and need to delete a version of a document someone else uploaded into a document library. In other libraries, when I hover over the document, I get the drop-down which contains the "Edit Item, Open In... and Delete". In the particular library, I don't get that menu. Any ideas why?

 


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