1. How to check currently working environment i.e. cluster or non-cluster ?

  • We can identify using server properties or by using following command
  • SELECT  SERVERPROPERTY('isclustered')
  • 0 for non cluster and 1 for cluster

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.

SQL Server Error Logs

* Error Logs maintains events raised by SQL Server database engine or Agent. * Error Logs are main source for troubleshooting SQL Server...

SQL Server DBA Training

SQL Server DBA Training
SQL Server DBA