Thursday, 15 May 2008

SharePoint Backup Script

This isn't the most advanced backup script you will ever see, but a) it works as a batch file so it is easy to modify and deploy, and b) it backs up more than the OOB tools do on their own, as follows:

- Deletes and recreates the folder structure for the backup target share
- Backs up site collections using stsadm (you will need to add the site collections that you wish to backup)
- Performs a farm backup using stsadm
- Copies the 12 hive across
- Performs an IIS metabase backup and copies the inetpub folder across
- Copies the Global Assembly Cache

For it to work, you will need to create a share on your backup server called "Backup" with the following permissions:

- SharePoint setup/administrator account - Full Control
- SQL Service Account - Full Control
- SharePoint Service/Server Farm Account - Full Control

Run the following command line on the backup server to do this for you:

NET SHARE Backup=D:\Backup /GRANT:DOMAIN\SPAdmin,FULL /GRANT:DOMAIN\SQLSVC,FULL /GRANT:DOMAIN\SPSVC,FULL

And here is the backup script:

@echo off
echo =================================================
echo Backup SharePoint Farm
echo =================================================
c:
CD\Program Files\Common Files\Microsoft Shared\web server extensions\12\BIN
@echo off

rd \\BACKUPSERVER\Backup\SharePoint /s /q
md \\BACKUPSERVER\Backup\SharePoint
md \\BACKUPSERVER\Backup\SharePoint\12
md \\BACKUPSERVER\Backup\SharePoint\IIS
md \\BACKUPSERVER\Backup\SharePoint\GAC

echo Backing up site collections
stsadm -o backup -url http://portal.domain.com -filename \\BACKUPSERVER\Backup\SharePoint\Portal.dat -overwrite

echo Backing up farm
stsadm.exe -o backup -directory \\BACKUPSERVER\Backup\SharePoint\ -backupmethod full

echo Backing up 12 hive
xcopy "C:\Program Files\Common Files\Microsoft Shared\web server extensions\12" \\BACKUPSERVER\Backup\SharePoint\12 /s /e /c /h /f /r /k

echo Backing up IIS
c:
cd\windows\system32\inetsrv\MetaBack
del metabasebackup.*
cscript c:\windows\system32\iisback.vbs /backup /b MetabaseBackup /overwrite
xcopy metabasebackup.* \\BACKUPSERVER\Backup\SharePoint\IIS /s /e /c /h /f /r /k
xcopy c:\inetpub\*.* \\BACKUPSERVER\Backup\SharePoint\IIS /s /e /c /h /f /r /k

echo Backing up GAC
xcopy c:\windows\assembly\*.* \\BACKUPSERVER\Backup\SharePoint\GAC /s /e /c /h /f /r /k

echo Backup operation finished

5 comments:

  1. Hi Phil,

    You are deleting the previous backup first then you take the new backup. What if after deleting the previous backup, your sharepoint backup fail for some reason .. and at the same time something happens to sharepoint site...now you will not have back to restore the site??

    ReplyDelete
  2. I did say that it wasn't the most advanced backup script you will ever see :-)

    I should have explained in my post, but you should use this backup script to complement whatever existing backup processes you have in place. For example, after this backup has run, you can archive the folder to tape or disk so that you have a point in time backup available.

    ReplyDelete
  3. Due to sending in those offer, You are investing in buy this realisation brand from the vendor if you're the earning prospective buyer. You read and sign the worldwide transportation structure affiliate agreement unwraps in any pickup's wind shield also known as loss. Transfer costs by now quotation probably have become controlled by change if you ever speed up you uttermost place a bet little..

    If the house is Camisetas De Futbol Baratas always went back following a established time it Maglie Poco Prezzo will undergo a 20% re selling commission rate aka refusal. For Coach Outlet Online Store something to qualify for head back or replace, The system had to be inside one of a kind overall disease utilizing manuel neuer trikot rot the labels it maillot de foot personnalise entered. hummel trikots In cases where the taken back service supplying is divided or is devoid of you should we will resultados de futbol see a Restocking charge all the way to 20%.

    By - applying your personal quote, You are investing maillot de foot pas cher in buy here food from the owner if you are the succeeding prospective buyer. You read maillot foot 2018 and accept the world shipping and delivery company conditions starts advertising in a meaningful door and bill. Significance allegations earlier amazon müller trikot in this article cited have been controlled by change inside event you improve you greatest tender value.

    ReplyDelete