Tips for Using Top SQL Server Products

Special Sponsored Section: This vendor-sponsored collection of tips will help you get the most from your favorite products

Editor's Note: Use the Comments tool to share your own special tricks for getting the most out of these solutions.

3 Top Backup Tips from UltraBac Software

1. A Fast, Simple Way to Restore a Database to the Same or an Alternate Location
When you're restoring a SQL Server database, UltraBac's built-in SQL MOVE Parameters option lets you restore a database to an alternate location on the same SQL Server host as the original database. During the restore process, UltraBac can also rename the data and log files-and even change the database file name.

2. UltraCopy-A Media Marvel
The UltraCopy utility gives users the ability to copy or move backup data from one media type to another, including disk-to-tape, tape-to-tape, FTP, Tivoli, and DVD. UltraCopy provides disk-to-disk-to-tape backups when used with UltraBac's file-based backup software. UltraCopy offers tape-to-tape media conversions-letting you convert 4mm tapes to Advanced Intelligent Tape (AIT), Digital Linear Tape (DLT), LTO (Linear Tape-Open), and other formats-and lets users select and combine any disk or tape hardware solution to perform disk-to-disk-to-tape backups. UltraCopy is an ideal utility to create redundant and inexpensive backup copies for offsite disaster recovery requirements, to perform media conversions, to refresh old tapes to new media, and to copy daily disk-based backups offline for essentially unlimited redundancy.

3. Completely Recover a Failed Machine in as Little as 15 Minutes
Using UBDR Pro or UBDR Gold image-based bare metal disaster recovery lets users manually recover an unbootable server in seven quick steps:

  1. Insert the Universal Boot CD (all drivers preloaded).
  2. Press the machine's power button.
  3. Use the backup wizard to locate the saved image.
  4. Highlight the file and initiate restore from tape, disk, or network location, as Figure 1 shows.
  5. When complete, remove the Universal Boot CD.
  6. Press the power button.
  7. Resume operations.

UBDR Gold offers cold boot file-by-file or image backup capability, and restores can be fully scripted for 100 percent unassisted disaster recovery. Both products safely back up all open files and hidden partitions and offer built-in encryption. You can use them as standalone products or integrate them with UltraBac.

Hide comments


  • Allowed HTML tags: <em> <strong> <blockquote> <br> <p>

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.