locked
scheduling SharePoint 2007 backups RRS feed

  • Question

  • Hi

     

    Is there any way i can scheduling SharePoint backups?

     

    Regards


    SharePoint 2007 (Administration/Development) | Web developer and .NET DTS Programmer | .NET Framework 2.0/3.5 | SQL Server 2008/2005/2k
    Friday, November 11, 2011 1:37 AM

Answers

  • Hello AliUsmanKhan1,

    Yes you can. You will have to create a STSADM script and then schedule that through Windows scheduler. Here is an example how you can achieve that.

    Through SharePoint central admin you can't scheule backup though.

    Hope this helps!


    BlueSky2010
    • Marked as answer by aliusman Monday, November 14, 2011 3:01 AM
    Friday, November 11, 2011 3:43 AM
  • Hi,

    In addition to what BlueSky has said I would suggest you to create DB maintenance plans as well.

    These plans will be used to back up your DBs. 


    Thanks, Rahul Rashu
    • Marked as answer by aliusman Monday, November 14, 2011 3:02 AM
    Friday, November 11, 2011 8:42 AM
  • Hi,

    There is a Official KB from Microsoft: http://technet.microsoft.com/en-us/library/cc288541(office.12).aspx

    You should use STSADM with Windows Scheduler to perform backups.

    Windows PowerShell script files are .ps1 files.

    You can use Backup-SPFarm to do it. For help and examples, type get-help Backup-SPFarm -examples.

    For example, the follow script will start a full backup to e:\backup.

    Backup-SPFarm -Directory E:\Backup -BackupMethod full

    Save it as E:\Scripts\BackupSharePointFarm.ps1. You may need to use "set-executionpolicy RemoteSigned" to allow a local unsigned ps1 file to run.


    And put the following as your scheduled command line, or inside your batch file....
    powershell -command E:\Scripts\BackupSharePointFarm.ps1

    In task scheduler, the account need to be set to the one who has admin permissions (or at least with powershell permission) otherwise it cannot run properly.


    Microsoft Certified Technology Specialist: SharePoint 2010, Configuring
    Microsoft Certified Personal
    • Marked as answer by aliusman Monday, November 14, 2011 3:02 AM
    Friday, November 11, 2011 8:52 PM

All replies

  • Hello AliUsmanKhan1,

    Yes you can. You will have to create a STSADM script and then schedule that through Windows scheduler. Here is an example how you can achieve that.

    Through SharePoint central admin you can't scheule backup though.

    Hope this helps!


    BlueSky2010
    • Marked as answer by aliusman Monday, November 14, 2011 3:01 AM
    Friday, November 11, 2011 3:43 AM
  • Hi,

    In addition to what BlueSky has said I would suggest you to create DB maintenance plans as well.

    These plans will be used to back up your DBs. 


    Thanks, Rahul Rashu
    • Marked as answer by aliusman Monday, November 14, 2011 3:02 AM
    Friday, November 11, 2011 8:42 AM
  • Hi,

    There is a Official KB from Microsoft: http://technet.microsoft.com/en-us/library/cc288541(office.12).aspx

    You should use STSADM with Windows Scheduler to perform backups.

    Windows PowerShell script files are .ps1 files.

    You can use Backup-SPFarm to do it. For help and examples, type get-help Backup-SPFarm -examples.

    For example, the follow script will start a full backup to e:\backup.

    Backup-SPFarm -Directory E:\Backup -BackupMethod full

    Save it as E:\Scripts\BackupSharePointFarm.ps1. You may need to use "set-executionpolicy RemoteSigned" to allow a local unsigned ps1 file to run.


    And put the following as your scheduled command line, or inside your batch file....
    powershell -command E:\Scripts\BackupSharePointFarm.ps1

    In task scheduler, the account need to be set to the one who has admin permissions (or at least with powershell permission) otherwise it cannot run properly.


    Microsoft Certified Technology Specialist: SharePoint 2010, Configuring
    Microsoft Certified Personal
    • Marked as answer by aliusman Monday, November 14, 2011 3:02 AM
    Friday, November 11, 2011 8:52 PM