How to backup individual Content databases in SharePoint

Here is a quick tip about how to go for backing up indivual databases. To backup indivusal databases in SharePoint you can either

1. Use stsadm command -
.BAT file to backup content databases:

cd %COMMONPROGRAMFILES%\Microsoft Shared\web server extensions\12\BIN
stsadm.exe -o backup -directory "E:\SharePointBackups" -backupmethod full -overwrite -item databasename

2. Sql server managemnt -> Select database ->backup option.

Ads by Google