locked
What is the proper way to create a backup of a content DB in production?

    Question

  • Hi,

    Help, please.

    I need to create a backup of my content DB in production.

    Do I need to do some step before opening the SQL Management Studio?

    Thanks in advanced.

    • Edited by efebo Thursday, February 16, 2012 4:42 PM
    Thursday, February 16, 2012 4:41 PM

Answers

  • There are no extra steps in either SharePoint (such as detaching) or SQL Server, a regular SQL backup using SQL tools or most third-party SQL database or SharePoint database backup products will backup a SharePoint content database.

    Here are some things to think about:

    1. Consider performing a copy-only backup to prevent messing with your SQL backup sets
    2. A SQL backup can affect the performance of the farm. Consider running the backup during a less-used period of time
    3. A backup can take a long time depending on the size of the database, likewise, ensure you have enough free space to accomodate the backup
    4. If you are using the full recovery model you can create a backup that can be restored at a more granular point in time. This may not be a concern if you're making a backup for testing purposes

    Jason Warren
    Infrastructure Specialist
    Habañero Consulting Group
    www.habaneros.com/blog


    • Edited by Jason WarrenMVP Thursday, February 16, 2012 6:16 PM
    • Marked as answer by efebo Thursday, February 16, 2012 10:40 PM
    Thursday, February 16, 2012 6:15 PM

All replies

  • There are no extra steps in either SharePoint (such as detaching) or SQL Server, a regular SQL backup using SQL tools or most third-party SQL database or SharePoint database backup products will backup a SharePoint content database.

    Here are some things to think about:

    1. Consider performing a copy-only backup to prevent messing with your SQL backup sets
    2. A SQL backup can affect the performance of the farm. Consider running the backup during a less-used period of time
    3. A backup can take a long time depending on the size of the database, likewise, ensure you have enough free space to accomodate the backup
    4. If you are using the full recovery model you can create a backup that can be restored at a more granular point in time. This may not be a concern if you're making a backup for testing purposes

    Jason Warren
    Infrastructure Specialist
    Habañero Consulting Group
    www.habaneros.com/blog


    • Edited by Jason WarrenMVP Thursday, February 16, 2012 6:16 PM
    • Marked as answer by efebo Thursday, February 16, 2012 10:40 PM
    Thursday, February 16, 2012 6:15 PM
  • If you have a dev and a production environment, then I'd assume that you're creating a nightly backup of the db somewhere, either using a SQL backup routine or through a batch file or some other method.

    What I'm driving at is if you are uncomfortable in SQL Manager, don't want to draw on the SQL server's resources, and/or want to avoid redundant backups, it's likely that there's already a backup on your network somewhere, likely on your SQL server. Might be worth checking.

    Thursday, February 16, 2012 8:03 PM
  • Thank you both

    Thursday, February 16, 2012 10:41 PM