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