Explore BrainMass

Maintenance Tools in MS SQL 2005

This content was STOLEN from BrainMass.com - View the original, and get the already-completed solution here!

What are some of the maintenance tools available in MS SQL 2005, and how are they used?

© BrainMass Inc. brainmass.com October 24, 2018, 9:35 pm ad1c9bdddf

Solution Preview

Manageability Features in SQL Server 2005

SQL Server 2005 focuses on making it simpler and easier to deploy, manage and optimize enterprise data and analytical applications. As a trusted data management platform it provides a single management console that enables data administrators anywhere in the organization to monitor, manage and tune all of the databases and associated services across your enterprise.

Management tools include:
? an integrated management tool suite with support for the automation of routine tasks
? proactive systems for monitoring system health and performance
? enhanced performance tuning tools
? greater programmability
? table and index partitioning to improve ...

Solution Summary

The maintenance tools available in MS SQL 2005, and their usage are explained.

See Also This Related BrainMass Solution

Information Systems- SQL Servers

Using the Online Library, the Internet, and all course materials, locate information about the differences between SQL Server 2005 and SQL Server 2008.

Try to complete the following:

*What are some of the improvements made between these two versions?
*Why are these changes important?

View Full Posting Details