Pasted from http://blah.winsmarts.com/2006-12-Backup-Restore_a_site_collection_in_SharePoint_2007.aspx

The best way to backup a SharePoint site is –

Stsadm –o backup –url <SiteURL> -filename <FileName>

For example: Stsadm –0 backup –url http://sharepoint:100 –filename c:\sharepoint100.bak

To restore the site, use

Stsadm –o restore –url <restoretoURL> -filename <filetorestorefrom>

For example: Stsadm –0 restore –url http://sharepointNEW:100 –filename c:\sharepoint100.bak

Few searches revealed that this id is corresponding to Publishing Timer Jobs. To install the feature, run the following command:

stsadm -o installfeature -name PublishingTimerJobs

When you launched “SharePoint Products and Technologies Configuration Wizard” and got into this error:

Failed to start the database service MSSQL$OfficeServers.  Repair this product by selecting it from the Add/Remove Programs menu.

Here’s the solution: Go to “regedit”, browse thru “HKLM_Local_Machine/Software/Microsoft/Shared Tools/Web Server Extensions/12.0/WSS/”. Then change the value of attribute named “ServerRole” from SINGLESERVER to APPLICATION.

Thanks to Akshay’s Weblog (http://blogs.msdn.com/akshayns/archive/2007/08/14/unable-to-configure-sharepoint-products-and-technologies-configuration-wizard.aspx?CommentPosted=true#commentmessage).

If you try to install Project Server 2007 on Windows Server 2008 R2, the Setup program will give you an error message such as this one:

“The program is blocked due to compatibility issues.”

To overcome this error, you need to slipstream the latest sharepoint or project server updates to the respective “Updates” folder.

To install MOSS 2007 on Win 2008 R2, please refer to here.

To install Project Server 2007 on Win 2008 R2, please refer to here.