locked
How to backup & restore FBA application in sharepoint 2010 RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi friends,

     I am working on a sharepoint 2010 application. The application uses two server one for database & one for sharepoint. In that application, i stored membership database into the web application's database. So whenever i perform granular site collection backup & restore the application from central administration, i am unable to get membership database tables.

    So my question is how can i get all the users created in web application to the restored application?

    • Moved by star.wars Monday, February 27, 2012 1:43 AM SP 2010 question (From:SharePoint - Setup, Upgrade, Administration and Operation (pre-SharePoint 2010))
    Friday, February 24, 2012 1:39 PM

Answers

  • Question
    Sign in to vote
    2
    Sign in to vote

    Hi Satish,

    Not sure whether I understand you correctly - but if YOU created this membership database in the SharePoint SQL server that can't be backed up from SharePoint central administration. SharePoint only backs up it's own databases. If that's the case you may have to use SQL server backups (like SSMS) for your database.

    Hope this helps!

    BlueSky2010
    Please help and appreciate others by using these features: "Propose As Answer", "Vote As Helpful" and "Mark As Answer"

    • Proposed as answer by Trevor SewardMVP Monday, February 27, 2012 6:38 PM
    • Marked as answer by satish_p Tuesday, February 28, 2012 9:25 AM
    Monday, February 27, 2012 6:21 PM

All replies

  • Question
    Sign in to vote
    2
    Sign in to vote

    Hi Satish,

    Not sure whether I understand you correctly - but if YOU created this membership database in the SharePoint SQL server that can't be backed up from SharePoint central administration. SharePoint only backs up it's own databases. If that's the case you may have to use SQL server backups (like SSMS) for your database.

    Hope this helps!

    BlueSky2010
    Please help and appreciate others by using these features: "Propose As Answer", "Vote As Helpful" and "Mark As Answer"

    • Proposed as answer by Trevor SewardMVP Monday, February 27, 2012 6:38 PM
    • Marked as answer by satish_p Tuesday, February 28, 2012 9:25 AM
    Monday, February 27, 2012 6:21 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Thanks BlueSky2010,

    As you said, i am unable to get those membership table in sharepoint backup. So what should i do to register same users as existing site has on the restored application so that everything works as it. 

    Tuesday, February 28, 2012 9:25 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi Satish,

    As mentioned you can use the SQL Server Management studio to backup your database and restore that DB to the new location. See the following links for wolkthroughs:

    http://www.sqlteam.com/article/backup-and-restore-in-sql-server-full-backups 

    http://blog.sqlauthority.com/2009/07/29/sql-server-2008-copy-database-with-data-generate-t-sql-for-inserting-data-from-one-table-to-another-table/

    Thank you!

    BlueSky2010
    Please help and appreciate others by using these features: "Propose As Answer", "Vote As Helpful" and "Mark As Answer"

    Tuesday, February 28, 2012 6:53 PM