Tuesday, September 7, 2010

Add article to mirroring?

Sql server 2005 onwords we have good option called mirroring (Heigh avilability) Concept.

By using this option we can maintain/manage same capy of data in another location( either in same server or different server)
Same server: instal two instancess in same machine.
Another server: let configure mirroring in another machine.

In both senarios we need to add an article to the existing mirroring articles.

This can be done in two ways:

1.From query window
   use mydb
   go
    sp_addarticle @publication='mypublication', @article='dbo.test’,
    @source_table='test' ,  @force_invalidate_snapshot=1  it is used for add article for existing one
  go

2.From UI ( Wizard )

  1. Right click on local publication
  2. Select Required publication
  3. Right click on desired publication
  4. Click on Launch publication monitor
  5. Expand plus symblo -- > Choose Properties --> Choose article from the wizard (option 2)
  6. Add required table/stored procedure (Article) to the existing articles
  7. then take snapshot and apply that snpshot to the subscription
 

No comments:

Post a Comment