none
Can sqlserver tool do site collection backup RRS feed

  • Question

  • I follow the article http://technet.microsoft.com/en-us/library/ee748617.aspx and site collection backup is possible using windows powershell. So does that mean we cannot do site collection backup using sqlserver 2008?
    Friday, October 7, 2011 7:23 PM

Answers

  • If you have separate database for each site collection you can backup. I don't think you want to do that.
    You can use tools like : http://spdeploymentwizard.codeplex.com/ to back up site collection or Power Shell 


    Aryan Nava | Twitter: @cloudtxt | Blog: http://virtualizesharepoint.com
    Please click "Propose As Answer" if a post solves your problem or "Vote As Helpful" if a post has been useful to you.

    Disclaimer: This posting is provided "AS IS" with no warranties.

    • Marked as answer by Wayne Fan Wednesday, October 19, 2011 11:46 AM
    Friday, October 7, 2011 7:32 PM
  • Hi,

    yes you are right. With SQL Server Management Studio you can just backup a complete database.

    If you want to create granular backups, like site Collections or Sub Sites you can use PowerShell or the Central Administration integrated Backup (but this one is also limited).

    Cheers, Chris

     

    -----------------------------------------------------------------
    SharePoint WebSite Branding done in less then 5 minutes

    First Online SharePoint 2010 Branding Tool now available

    http://www.nextflow.at/eng/pages/plugnplay.aspx
    -----------------------------------------------------------------


    Christian Handler, MCITP SharePoint 2010 Administration, Plug 'n Play Branding for SharePoint 2010, http://www.nextflow.at
    • Marked as answer by Wayne Fan Wednesday, October 19, 2011 11:46 AM
    Tuesday, October 11, 2011 12:57 PM
  • I notice that two people have mentioned the PowerShell option without providing any further detail.  There is a technet article that details how you can do this, with either the scripts, or via Central Administration.  Please look at this: -

    http://technet.microsoft.com/en-us/library/ee748617.aspx

    You can also use STSADM for this but this is a deprecated feature.


    Steven Andrews | SharePoint Professional | http://www.twitter.com/backpackerd00d | https://baron72.wordpress.com/
    • Marked as answer by Wayne Fan Wednesday, October 19, 2011 11:46 AM
    Tuesday, October 11, 2011 1:16 PM
    Answerer

All replies

  • If you have separate database for each site collection you can backup. I don't think you want to do that.
    You can use tools like : http://spdeploymentwizard.codeplex.com/ to back up site collection or Power Shell 


    Aryan Nava | Twitter: @cloudtxt | Blog: http://virtualizesharepoint.com
    Please click "Propose As Answer" if a post solves your problem or "Vote As Helpful" if a post has been useful to you.

    Disclaimer: This posting is provided "AS IS" with no warranties.

    • Marked as answer by Wayne Fan Wednesday, October 19, 2011 11:46 AM
    Friday, October 7, 2011 7:32 PM
  • Hi,

    yes you are right. With SQL Server Management Studio you can just backup a complete database.

    If you want to create granular backups, like site Collections or Sub Sites you can use PowerShell or the Central Administration integrated Backup (but this one is also limited).

    Cheers, Chris

     

    -----------------------------------------------------------------
    SharePoint WebSite Branding done in less then 5 minutes

    First Online SharePoint 2010 Branding Tool now available

    http://www.nextflow.at/eng/pages/plugnplay.aspx
    -----------------------------------------------------------------


    Christian Handler, MCITP SharePoint 2010 Administration, Plug 'n Play Branding for SharePoint 2010, http://www.nextflow.at
    • Marked as answer by Wayne Fan Wednesday, October 19, 2011 11:46 AM
    Tuesday, October 11, 2011 12:57 PM
  • I notice that two people have mentioned the PowerShell option without providing any further detail.  There is a technet article that details how you can do this, with either the scripts, or via Central Administration.  Please look at this: -

    http://technet.microsoft.com/en-us/library/ee748617.aspx

    You can also use STSADM for this but this is a deprecated feature.


    Steven Andrews | SharePoint Professional | http://www.twitter.com/backpackerd00d | https://baron72.wordpress.com/
    • Marked as answer by Wayne Fan Wednesday, October 19, 2011 11:46 AM
    Tuesday, October 11, 2011 1:16 PM
    Answerer