What are the enhancements that would help a SQL Server Yukon database administrator (DBA)?
Yukon significantly enhances the existing Log shipping feature by providing a Database mirroring option. Database mirroring option enables the continuous streaming of the transaction log from a source to a single destination. This destination would then in an event of failure be useful to recover the database. Database mirroring option is an orchestration between SQL Servers to achieve the ability to recover the database when a failure occurs. Administrators now need not restart the Server for every change in SQL Server system parameters that is made. This would ensure a higher availability of the database. SQL Server Computer Manager is the replacement for the earlier known tools such as Client Network Utility, Server Network utility and SQL Server Service Manager. SQLCMD is the new command line utility for working with Yukon. This is a replacement for the earlier OSQL Utility. SQL Server Yukon now features a new dedicated administrative connection to access the database even if the s