Today, more than ever, companies must align IT functions with the overall business objectives.This means moving away from the everyday tedium of managing technology infrastructures and redirecting in-house experts to higher-value work. One of the most crucial areas of IT where this transition must occur is database management.

DATABASE DESIGN SERVICES

• Initial database design review with Hosted SQL Server expert

ON CALL DBA SUPPORT (WEEKDAYS 8AM-6PM)

• Up to one (1) hour of DBA support is included every month for customer directed DBA activities.

DATABASE BACKUPS FOR POINT IN TIME RECOVERY

• Daily or weekly backup of all databases to local disk using SQL Server commands.
• Hourly backup of transaction logs to local disk using SQL Server commands.
• Daily sweep of online backup files to tape backup system (requires server backup package).
• Additional charges may apply to large databases.

DATABASE MONITORING & ADMINISTRATION

• Monitor network connectivity to the database server
• Monitor that SQL Server services are running
• Monitor disk space
• Review SQL Server scheduled jobs for failures
• Review SQL Server and Windows event logs
• Resize database data and transaction log files as required
• Check for database corruption
• Create and update database statistics
• Rebuild or defrag indexes
• Cycle SQL Server error logs

ADDITIONAL DATABASE ADMINISTRATION SERVICES

• Hosted Solutions offers complete SQL Server DBA services on a time and materials basis at $150/hour weekdays 8AM-6PM and at $200/hour after hours and on holidays.