How to add new article in Replication? Client is asking to add new article in existing Replication?

Please fine the below steps to full-fill the client requirement.

To add new article in Replication

SSMS à Replication à Local Publications à right click on your publication à Properties à Click on 'Articles' tab à Uncheck 'Show only checked articles in the list'.

To verify added new article-

SSMS à Replication à Local Publications à right click on your publication à Properties à Click on 'View Snapshot Agent Status' à Click on 'Start' à It will show how many articles generated. If you added one new article to it will show N+1 article.

Note: - N (existing article) + 1 (New Article)

Please comment below if you know any other way to add new article in Replciation. - Jainendra Verma

SQL Server - How to generate Logs related to a specific Cluster Node and open the generated log file?

There are two ways to generate the Cluster node log-

1. Using Command Prompt 

2. Using Pwoershell 

Login in the Cluster node and run the below command-

Using CMD -

Syntax-  c:\>Cluster log /gen /node:’’node1”

Example-

C:\window\system32>Cluster log/g

Using Power shell - 

Syntax-  PS C:\> Get-ClusterLog –Node <SQL Server node name> –TimeSpan 15

Example-

PS C:\> Get-ClusterLog  Node_test1 TimeSpan 15

Note:- Here Timespan means 15 minute of log.

After running above any one command the cluster log will generate. To see the log follow below location -

Open the log C:\Windows\Cluster\Reports\Cluster.log file and you can find the error to fix issue.

Please let me know if you know any other way to get the Cluster log. - Jainendra Verma