The Idea Database Accelerator tool appears to be real handy at analyzing, reorganizing, and rebuilding indexes.

Keep in mind i’m still playing with this.

Today I sort of figured out how to backup and restore a site using Idera Site Backup.  Site Backup creates a .cmp file for the site you are backing up.  Using SharePoint Designer I was able to restore my deleted site from the .cmp file.

Here are the steps I followed:

Restore a Web site

Step 1: Create a new empty Web site as a destination

1. On the File menu, click New.
2. In the New dialog box, click the Web Site tab, click General, and then click Empty Web Site.
3. In the Specify the location of the new Web site box, enter the location where you want to restore the backup site.You can restore the site to a different server, and you can restore it as either a new top-level site or a subsite under an existing top-level site.
4. Click OK.

 Tip   You can also create an empty Web site through the browser by using the Site Settings or Create pages. For example, when viewing the site in the browser, click Site Actions, and then click Create. On the Create page, under Web Pages, click Sites and Workspaces. Complete the first four sections, but when you get to the Template Selection section, close the browser without making a selection. Do not apply any template — including the Blank Site template — or the restore operation will fail.

Step 2: Restore the backup file to the destination

1. With the destination site open, on the Site menu, point to Administration, and then click Restore Web Site.
2. In the File Open dialog box, browse to and click the .cmp file that you want to restore, and then click Open.
3. If the current Web site is low on available storage space, click Advanced, and then do any of the following:
   • To store the archive files in another temporary location, enter a new location in the Temporary location for archive files box.Backing up a Web site requires a location to store temporary backup files. By default, Office SharePoint Designer 2007 uses the current Web site. You can use another site on the same server or a location on another server on the same network — for example, \\Server name\Share name.
   • To store the .log file in another location, enter a new location in the Location for import log file box.You might need to choose another location for the .log file if the server cannot write to the default location. By default, Office SharePoint Designer 2007 creates an import .log file in the current Web site. You can check this file to determine if there were errors during the restore process.
4. In the Restore Web Site dialog box, click OK to confirm that you want to restore the .cmp file to the current empty Web site.If the site that you are backing up or restoring is large, the process can take quite a while.

http://office.microsoft.com/en-us/sharepointdesigner/HA100699391033.aspx