Special Edition: SQL Server Backup & Recovery

Welcome to SQLsmarts, Idera’s newsletter for SQL Server Professionals!

We welcome your questions, comments or suggestions.
Email us at SQLsmartseditor@Idera.com.
 

In this issue:

Product News
Announcing new SQLsafe v2.2: Enterprise-class backup & recovery for SQL Server environments

News
Backup and recovery enhancements in SQL Server 2005

Tips & Tricks – SQLsafe
Save time backing up multiple databases
Get real-time status of backup jobs with SQLsafe’s enterprise console

Announcing new SQLsafe v2.2: Enterprise-class backup & recovery for SQL Server environments

Regardless of how large your SQL Server enterprise, or how complex your backup requirements, Idera’s new SQLsafe v2.2 will simplify and streamline your SQL Server backup and recovery operations. From a central, easy-to-use console, you’ll be able to view, schedule, and oversee all backup operations across all servers in your SQL Server environment and quickly restore a database to working order in the event of a disaster. SQLsafe helps you ensure that every database is backed up on schedule without fail and will notify you of any issues. SQLsafe dramatically reduces backup storage requirements, backup time and expense by compressing data by as much as 95% and shortening the backup time by as much as 90%.

SQLsafe Enterprise Console

SQLsafe v2.2 will help you backup SQL Server faster and more effectively than ever before with these key benefits:

• Enhanced Performance and Scalability: New multi-threading capabilities and queuing technologies have been tested to provide up to 50% increase in performance over previous versions in multi-processor environments.
• MSDE Support: Now backup and restore MSDE databases.
• Maintenance Plan Conversion: Quickly and easily convert existing maintenance plan jobs to perform SQLsafe backups from native SQL Server backups.
• “Agent-only” Install: Now perform backup and restore operations without having to add additional SQLsafe management services and central repositories to your environment. This allows SQLsafe to be easily incorporated into an existing backup and recovery infrastructure.
• Restore Script Generation: Quickly generate CLI or T-SQL restore scripts enabling easy job creation.

Learn more about the SQLsafe 2.2
Try it FREE for 30 days!

Backup & recovery enhancements in SQL Server 2005

As with any new software release, you'll often find new features you didn't know existed or you didn't know you needed. Many backup and restore features that exist in SQL Server 2000 will remain the same in SQL Server 2005, but there are several new enhancements worth your consideration. Find out what SQL Server Expert, Greg Robideaux of Edgewood Solutions has to say about the new features in SQL Server 2005.
Read the article...

Save time backing up multiple databases

Most backup products immediately launch an executable whenever you request a backup -- making it difficult or impossible for you to select multiple databases for backup without stressing your systems. SQLsafe, on the other hand, will allow you to select multiple databases for backup and will automatically queue those backups to occur in a logical order. This will save you hours of administrative time, help you ensure that every database is backed up without fail, and will never affect the performance of your SQL Server environment.

SQLsafe Queued Backups View

Get real-time status of backup jobs with SQLsafe’s easy-to-use enterprise console

SQLsafe provides an easy-to-use enterprise console that allows database administration staff to quickly and easily check the status of all backup and restore commands in real-time. Therefore, regardless of where or how the backup commands were initiated (SQLsafe Management Console, command-line, XSP, or scheduled job) the SQLsafe console displays all in-progress backups as well as historical backup and restore status.
 

We want to hear from you!

Have an interesting story about how Idera product(s) have helped you?
Want to share a product tip, trick or hint?
Have product suggestions or questions?

Your feedback helps us ensure that our solutions continue to best serve your SQL Server management and administration needs. You may even find your input published here in future newsletters.

Please send your comments and suggestions to SQLsmartseditor@idera.com

Visit Idera at an upcoming Microsoft Ready Launch Tour 2005  
U.S. Dates:
- Seattle, Nov 29
- Dallas, Nov 30
- Anaheim, Dec 6
- Denver, Dec 6
- Houston, Dec 6
- Orlando, Dec 8
- Boston, Dec 15
- Wash D.C., Jan 11
 
Australia Dates:
- Sydney, Nov 29
- Canberra, Dec 1
- Perth, Dec 6
- Brisbane, Dec 8
 
REGISTER NOW!

Idera will also sponsor:

Northern Virginia SQL Server Users Group
Dec 19

Using and Understanding Stored Procedures
 
December 7, 2005
12 pm | PST
 
Hosted by: SSWUG
 
Learn how to build stored procedures, how you pass in parameters, return results and how they work. You'll also see specific cases where you can use stored procedures to your benefit for security, performance and overall server management benefits. We'll take you from 0 to 60 with stored procedures and how they can be a great benefit for your systems.
 
REGISTER NOW!