Other Free Encyclopedias » Online Encyclopedia » Encyclopedia - Featured Articles » Featured Articles: Melissa And Doug Puzzle - What Are Melissa and Doug Puzzles? to Panasonic Mini Dv Camcorders - Panasonic Mini DV Camcorder Great Choice for Pro or Amateur

Microsoft Server Sql - A checklist after you restart your Microsoft server SQL services

validation step post dtc

There are many times in the work of an information technology specialist where you might need to restart your Microsoft server SQL services. For example, the server in your small business or work setting may need to be rebooted after you perform some task to patch security vulnerabilities. Alternatively, you may need to reboot after you install some sort of server pack considered essential by the operating system used on your server. In some cases, you may need to restart services simply due to a power loss or after shutting down the server to add or remove novel components, such as memory, graphics cards, or hard drives. You may also need to restart if you discover you have not registered your SPN, or if a database is suddenly found to be offline. Whatever the reason, you can use the following checklist to help you make sure your Microsoft server SQL services are working well after you restart your Microsoft server SQL services.

The first set of instructions involves the pre validation checklist. Once you restart one of your Microsoft server SQL services, the first thing you should do is keep a detailed inventory of the different editions, versions, lists, and languages of SQL services that are running on your SQL servers. You will then want to keep up test systems that match your production systems and will readily be available to test new patches. You will then want to make sure all of the user and system databases have been thoroughly backed up. Next, you will want to keep your password for the service account close by. This way, if you do not successfully restart the server because of a bad password, you will be able to correct the password and try again with hopefully more success. Finally, you will want to check your server to make sure there is a CLR initialization. It is easy to check the status of the CLR initialization and enable CLR if necessary by issuing commands in SQL.

The second set of instructions involves the post validation checklist. This involves multiple steps. The first step will be to check the status of the different Microsoft server SQL services. This can be done by executing commands involving NMSSQL Server, NSQL Server Agent, Nms dtc, Nsql browser, NMSSQL Server OLAP Service, and NReport Server. Additionally, you can check the status of various services by going through the SQL Server Configuration Manager.

The second step involved in the post validation checklist will be to check how the MS DTC service is currently configured. There is the possibility that there may have been a change in the security configuration of the MS DTC. You can check this by going to the control panel, then navigating to administrative tools, then to component services. From here, expand the computer node by right clicking on my computer. From there, go to properties, select the MS DTC tab, and move to the security configuration. From this point, you can adjust your security settings if you need to do so.

The third step involved in the post validation checklist will be to ensure that all of the databases present in your Microsoft server SQL services are online. You should make sure they are not in a state where they are suspect or restoring. This can be done by using SSMS, or by going through a systems query. If you want to use SSMS, this can be done by expanding the database list in the SQL server database folder. From here, you can check on the database status.

The fourth step in the post validation checklist will be to go through the error logs of the SQL Server and look for any errors in the restarting procedure. This can be done by executing a procedure such as EXEC xp_readerrorlog, which will look for any problems within the system. Another way to look for potential errors is by using the object explorer in SSMS.

The fifth step in the post validation checklist after you have restarted your Microsoft server SQL services will be the last one, which will be to verify the instances in the Cluster Group of your server set if it is clustered.

Microsoft Windows Xp Updates - Microsoft Windows XP Updates Continue Through 2014 [next] [back] Microsoft Phone Number - How to contact Microsoft with the Microsoft phone number

User Comments

Your email address will be altered so spam harvesting bots can't read it easily.
Hide my email completely instead?

Cancel or