Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

What are the enhancements that would help a SQL Server Yukon database administrator (DBA)?

0
10 Posted

What are the enhancements that would help a SQL Server Yukon database administrator (DBA)?

0
10

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

Related Questions

Thanksgiving questions

*Sadly, we had to bring back ads too. Hopefully more targeted.