Focus on: Enterprise SQL Server backup and job management

Welcome to SQLsmarts, Idera’s monthly newsletter for SQL Server Professionals! We welcome your questions, comments or suggestions.
Email us at SQLsmartseditor@Idera.com.

SQL diagnostic manager chosen BEST performance monitoring solution for SQL Server
Receives Platinum Award in SQL Server Magazine’s 2006 Editor’s Choice Awards!

SQL diagnostic manager has long been the secret life-saver of many database administrators worldwide – saving hours of time, reducing tedious administrative work, and providing the industry’s most comprehensive SQL Server performance monitoring and deep diagnostics tool on the market. Now, the press is noticing! SQL diagnostic manager was recently

SQL diagnostic manager gives you all of the raw power and information you need to manage, monitor and control all SQL Servers throughout your environment:

• Monitor the performance of SQL Servers in real-time, enterprise-wide from a central point of control
• Find and fix performance bottlenecks – fast
• Get a wealth of real-time and historic diagnostic metrics at your fingertips
• Set custom alerts and receive immediate notification of problems
• Access critical SQL Server info anytime, anywhere using a Web-browser
• Analyze performance trends over time and plan for the future
• Requires no agents, very low overhead
• Easy to install, implement and use -- download and begin monitoring SQL Server performance in 30 minutes or less!

SPECIAL OFFER:
Download the award-winning SQL diagnostic manager BEFORE September 30, try it free for 14 days, give us your feedback, and we'll send you a free SQL Server Superhero t-shirt!

Download Now

Integrate SQL Server Backup and Job Management Enterprise-wide
Now manage all jobs including backup and recovery jobs from a central point of control with SQLsafe 3.1

SQLsafe:
Provides fast-compressed and secure-encrypted backup and recovery operations enterprise-wide, speeding SQL Server backups by up to 50% and reducing disk space usage by up to 95%.

SQLschedule:
SQLschedule provides an extremely powerful and easy-to-use enterprise job management and scheduling solution that gives you complete control over all jobs throughout your environment .

Together: SQLsafe & SQLschedule
Provide extremely powerful solutions for managing jobs and backups across your environment – helping you increase the performance and, availability of your SQL Servers. From a central point of control, you can quickly identify conflicts, optimize backup job schedules and plan/schedule all jobs across the enterprise.

More new features in SQLsafe 3.1: High-Performance Backup and Recovery

• Automated Archive Grooming: Provides automated grooming of backup files based on a specified retention policy for full, incremental and transaction log backups.
• Maintenance Plan Conversion Wizard: Provides easy conversion of maintenance plans and log-shipping maintenance activities to SQL Server jobs, enabling easy customization and management.

Find out more about SQLsafe and SQLschedule
Try the SQLsafe/SQLschedule bundle free for 14 days
 

SQL Server Backup Tips

SQL Server Backup Wish list:

• Automatically backup all SQL Server databases.
• Create a separate folder for each database.
• Automatically delete any backups over 2 days old.

Idera SQLsafe can make your wishes come true!
This article offers scripts that you can use along with SQLsafe to set backups for all of your databases and to create a separate folder for each database before doing the backup. In addition, you can use these scripts to set an automatic deletion of old backup archives that are older than a certain time period (like 2 days).

Read the full article
 

We want to hear from you!

Do 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 newsletter is helpful! You may even find your input published here in future newsletters.

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

Visit Idera at these upcoming events:

• St. Louis SQL Server User Group
  Sept 12, 2006
  REGISTER HERE
   
  
• Idera Hosts the Microsoft Across America Truck:

• Houston, TX
  Sept 14, 2006
  REGISTER HERE
  
  
• Detroit, MI
  Sept 25, 2006
  REGISTER HERE
  
  
• Atlanta, GA
  Oct 25, 2006
  REGISTER HERE
  
  
• Dallas, TX
  Nov 1, 2006
  REGISTER HERE
  
  
• Microsoft Connections
  Houston, TX
  Sept 21, 2006
  REGISTER HERE
   
  
• DevLink
  Nashville, TN
  Oct 13, 2006
  REGISTER HERE
   
  
• PASS
  Seattle, WA
  Nov 13 – 16, 2006
  REGISTER HERE