As an official ‘Friend of Red Gate’ , I occassionally get direct updates and announcements from the company. They have an excellent suite of tools, which I have used and recommended at various client sites of mine.
Although I'm not promoting specifically any one product (with the exception of my own tools from time to time :-), I wanted to just pass on the news of their new tool that can help DBA's in a pinch and recover individual database objects without the need to resort to Full backups. This can save time and resources, in production environments large and small. I believe this feature has been part of their SQL Backup Pro software, but are now offering it as a stand-alone product. Please fee free to check out below their latest offering. The product supports versions from SQL 2000, 2005 and 2008.
New Tool: SQL Object Level Recovery Native
Red Gate (www.red-gate.com) recently released a standalone tool to enable you to recover individual database objects from Microsoft® Tape Format (MTF) SQL Server backup files (.bak). It's licensed per user, so you can restore the database objects to any database on any server.
For a feature list, and on-line demos, click here to learn more about the product.
Hope this helps!
---------------------------------------------------------------------------------------------------------------------
For Remote DBA Services and SQLCentric monitoring, visit us at http://www.pearlknows.com