Adding Article to Transactional Replication Without Creating Entire Snapshot

To add new article, follow below steps.


1) Add article using the below script in the publisher server.
        sp_addarticle @publication='Test_Tran',    
        @article='dbo.Table_4',@source_object='Table_4',
        @force_invalidate_snapshot=1



2) Run the below script in publishing DB
       EXEC sp_changepublication  @publication = 'Test_Tran',
         @property = N'allow_anonymous', @value = 'false'

       GO
       EXEC sp_changepublication @publication = 'Test_Tran',
       @property = N'immediate_sync', @value = 'false'
       GO



3) Start the SnapShot Agent. This time only the newly generated article will be    
    initialized.

Cluster Logs

Windows 2008 Cluster - Cluster Log can be generated using the below method.

From one of the nodes of the cluster, open a Command Prompt with Administrator rights.  The simplest command to create the log is to type “cluster log /g”.  A clusterl.log file will be generated and stored in the %windir%\Cluster\Reports directory on each node of the cluster.  Note that with all commands you can use either “cluster … ” or “cluster.exe …” as they have the same functionality.

For more information read below article.

http://blogs.msdn.com/b/clustering/archive/2008/09/24/8962934.aspx

Other Windows Cluster - Cluster Log can be found in the below location.

c:\Windows\Cluster
C:\Windows\System32\LogFiles\Cluster