We have run into a bit of a issue. When backing up SharePoint via
STSADM, the command does not capture the host header information.
When you go to restore the sites, the system will restore only one
site then the restore fails.

We have found a post from MSFT concerning the issue:
------------------------
Hello customer,

As you have noticed that this is a known issue with restoring
SharePoint site. Please refer to the "Problems during recovery" of the
following article:
Troubleshoot backup and recovery for Office SharePoint Server 2007
technet2.microsoft.com/.../991e55bd-b3e2-4260-beb3-b2386\
1934f0a1033.mspx
The workaround is:

1. Create a Web application using host header on the destination farm.
2. Backup the content database and restore to the destination farm
using SQL tools.
3. Add the restore content database to the Web application created in
step 1.

Stsadm usage of deleting and adding content database:
==========================================
a. Add content database:
stsadm -o addcontentdb -url <url> -databasename <database name>
[-databaseserver <database server name>] [-databaseuser <database
username>] [-databasepassword <database password>] [-sitewarning <site
warning count>] [-sitemax <site max count>]

b. Delete content database:
stsadm -o deletecontentdb -url <url> -databasename <database name>
[-databaseserver <database server name>]
------------------------

Our question is, can anyone tell us a more reliable backup and restore
routine...are there any products out there that excel in SharePoint
Backup and Restore?