Microsoft Office SharePoint Designer 2007 is a good resource for backup and restore. It creates a content migration package (.cmp) for the web site.
The content migration package contains library content, list content, navigation, user information, security settings, personalize settings like views and content types and customization but content migration package does not contain alerts, workflows and properties.
BACK UP WEB SITE
The first step is open the site in Microsoft Office SharePoint Designer 2007 and move from Site menu to Administration and click on Back Web Site.
Backup Web Site dialog box will appear which will ask to include all the sub sites in the backup, do as appropriate and click OK.
File Save dialog box will appear, guide it to the desired location after entering the name of the .cmp file and hit OK.
Microsoft Office SharePoint Designer 2007 will take time to crate content migration package depending upon the size of the web site.
RESTOR WEB SITE
First we will create an empty web site for restoring. For this, open Microsoft Office SharePoint Designer 2007 and move from File menu to New and click on Web Site.
In the New Dialog box, select Web Site tab, then select General and then Empty Web Site. Give the desired URL in the text box at the bottom of the dialog box and click OK. Microsoft Office SharePoint Designer 2007 will create a new empty web site.
Now, move from Site menu to Administration and click on Restore Web Site. Browse to the desired content migration package (.cmp file) and click OK.
This will start restoring the site and success message will appear at the end of the process.
Error occurred while exporting the web http://site URL.
Access is denied.(Eception from HRESULT:0x8007005(E_ACCESSDENIED))
You are not the administrator of the site collection.
Add yourself as site administrator. For this, open SharePoint Central Administration. Move from “Application Management” to “Site collection administrators” under “SharePoint Site Management”. Add yourself as administrator in the appropriate site collection.