locked
Restore Sharepoint missing Site Collections!! RRS feed

  • Question

  • Hello,

    During this process:

    - Restore all Databases with Tivoli
    - Create a Web Application in Sharepoint for each databases to be restored
    - Remove Content Database WSS_xxxx
    - Add Content Database by changing the name WSS_xxxx by the datbase restored.

    It works on 13 databases so far...
    Two sites do not get their site collection populated !!!
    All idea are welcome,

    Thanks,
    Dom


    System Center Operations Manager 2007 / System Center Configuration Manager 2007 R2 / Forefront Client Security / Forefront Identity Manager

    Saturday, December 1, 2012 4:50 AM

Answers

  • hi Felyjos ,

    If you Empty rows for query on sites table , then that DB does not have a Active collection & hence it does not come up in SharePoint . You can do 2 things

    1. Run Get-spdeletedSite & see if this  Site collection is still listed ? , If yes  Then ran restore-Spdeletedsite –id ‘GUID of teh Site collection ’ which should restore it ..

    OR

    2. Restore the DB again  which would have  the site collection , Confirm by

    use [WSS_Content_HelpdeskProd]
    Select * from sites (nolock )

    & Then Attch that Database by Mount-spcontentdatabase , which would take care of the upgrade as well .

    Regards

    Rajan

    • Marked as answer by Felyjos Thursday, December 20, 2012 11:44 PM
    Sunday, December 16, 2012 5:28 AM

All replies

  • Hi,

    Thank you for your post.

    I'm trying to involve someone familiar with this topic to further look at this issue. Appreciate your patience.

    Thanks & Regards,
    Emir Liu
    TechNet Subscriber Support in forum
    If you have any feedback on our support, please click here.


    Emir Liu
    TechNet Community Support

    Monday, December 3, 2012 3:30 AM
  • Hello,

    I appreciate.. I am waiting thanks,

    Dom


    System Center Operations Manager 2007 / System Center Configuration Manager 2007 R2 / Forefront Client Security / Forefront Identity Manager

    Monday, December 3, 2012 9:28 PM
  • hi Felyjos,

    1.  Does these Site collections use custom Managed path , if yes Has that been configured  to the Web-application  settings .

    2. Go to Central Admin > Application Management > View All site Collections , Select the Web-application having problem , Do you see the Site collection listed there ?

    2. Query the Sites table of the 2 problem content databases  to see  if the site ID exist in them , from SQL mgmt. studio

    use [ContentDB]

    Select * from sites (nolock )

    This Should List the ID of the Site if they are present .  

    If they show up , Then Remove & add the content DB from the Web-application   & see if this helps  

    Monday, December 10, 2012 10:31 AM
  • Hello Rajan,

    1. I am not sure to understand this... where should I look in Production for custom managed path?

    Web Application List > Application > Define Managed Paths

    root explicit inclusion

    sites Wildcard inclusion

    they exist on the server Production(origin) and Test (Destination)

    2. I do not see a View All site collections option?

    Per Web Application I have most of them showing Site Collections.

    but under Central Administration > Application Management > Site Collection List  

    there is no site collection

    3.

    use [WSS_Content_HelpdeskProd]
    Select * from sites (nolock )

    <<Empty>> for both databases...

    Thanks,

    Dom


    System Center Operations Manager 2007 / System Center Configuration Manager 2007 R2 / Forefront Client Security / Forefront Identity Manager


    • Edited by Felyjos Tuesday, December 11, 2012 6:06 PM
    Tuesday, December 11, 2012 6:02 PM
  • hi Felyjos ,

    If you Empty rows for query on sites table , then that DB does not have a Active collection & hence it does not come up in SharePoint . You can do 2 things

    1. Run Get-spdeletedSite & see if this  Site collection is still listed ? , If yes  Then ran restore-Spdeletedsite –id ‘GUID of teh Site collection ’ which should restore it ..

    OR

    2. Restore the DB again  which would have  the site collection , Confirm by

    use [WSS_Content_HelpdeskProd]
    Select * from sites (nolock )

    & Then Attch that Database by Mount-spcontentdatabase , which would take care of the upgrade as well .

    Regards

    Rajan

    • Marked as answer by Felyjos Thursday, December 20, 2012 11:44 PM
    Sunday, December 16, 2012 5:28 AM
  • Hello Rajan,

    1. does not seem that SharePoint 2007 has this command!!!

    2. I will try this option...

    Thanks,

    Dom


    System Center Operations Manager 2007 / System Center Configuration Manager 2007 R2 / Forefront Client Security / Forefront Identity Manager

    Thursday, December 20, 2012 11:22 PM