SPS backup with SQL

[sgwisby]

If I backup a SharePoint Portal Server using SQL to backup the sites, is this sufficient for restoring the Portal sites?
Thanks
David

 

[Thomas2000]

Hello,

It is sufficient to restore the portal in case of a disaster recovery. I would recommend you to also do backups with stsadm for your sites, doing it that way will allow you to restore single SharePoint sites/site collections.

You can easily create a script that runs the backup commands and you just make it a scheduled task on your Windows Server.

Download the Administrator guides for SharePoint from Microsoft, there you will have information on how the stsadm tool works, and what options you have.

If you only do an SQL backup, I do not think you will be able to restore individual sites if for example someone deletes a document library.

We are using 3rd party backup software to do real itemlevel backups of everything, so I can restore a single item in matter of minutes.

Regards,
Thomas

 

[sgwisby]

Thanks Thomas, I also backup using the stsadm utility. I read in another post that you use a fairly expensive tool for the purpose of restoring file level objects(the name eludes me at this time). I appreciate your help.
David

 

[sgwisby]

Should the spsbackup.exe utility be run each time the stsadm.exe utility is run?
Thanks for any all assistance,
David

 

[Evilbart]

if you want a full fidelity backup of your portal environment you should use SPSBACKUP to backup your portal.
(or tools from third party vendors)

SQL backups can be used, but in case of disaster you don't want to wait for rebuilding your indexes etc....
And i hate corrupt indexes ;-)


//Bart

http://sharepointblogs.com/bart