If you are a SQL Server developer or DBA, chances are you are quite familiar with working with SQL Server Management Studio (SSMS). However, even the most experienced professionals can encounter unexpected issues or misunderstandings with this tool. In this blog post, we will discuss one such experience and how it was resolved.
Recently, I was trying to configure Database Mirroring on a freshly created database using SSMS. However, I was surprised to find that the database mirroring option was missing in the database properties. This was unusual, as the option should be available regardless of the recovery model.
I initially thought that the issue might be related to the recovery model or a problem with the SQL Server Engine installation. However, after connecting to the same instance remotely, I discovered that the options were available. This indicated that the problem was not with the SQL Server Engine, but rather with the client tools installation.
To further investigate the issue, I launched the discovery report from the “SQL Server Installation Center” by clicking on “Installed SQL Server features discovery report”. The report confirmed that the option was not visible on the server with the problem, while it was present on a working server.
To resolve the issue, I re-ran the SQL Server installation and added the missing components on the server with the problem. After completing the installation, I was able to see the database mirroring option in SSMS.
It is worth noting that there are other options that may not be available in the “basic” version of SSMS. If you encounter missing options or unexpected behavior, it is always a good idea to check your installation and ensure that all necessary components are installed.
In conclusion, SQL Server Management Studio is a powerful tool for SQL Server developers and DBAs. However, it is not immune to issues or misunderstandings. By understanding common problems and troubleshooting techniques, you can effectively resolve any unexpected behavior and make the most out of this essential tool.