Sunday, April 14, 2013

[MS SQL Server] multiple instances of sqlserver different dns alias

[MS SQL Server] multiple instances of sqlserver different dns alias

multiple instances of sqlserver different dns alias

Posted: 14 Apr 2013 01:33 AM PDT

Hi , I have installed named instances sqlserver2005 express and sqlserver2012 on the same Windows 2008 server Virtual machine ,configured sqlserver2012 to use NON Default TCP IP port .we need 2 different DNS Aliases for these 2 database Servers i.e I should be able to access by specifying the following properties in my applicationuser=sapassword=myPwdhostname=mysql2005.us.comp.comport=1433instanceName=sqlserv2005user=sapassword=myPwdhostname=mysql2012.us.comp.comport=1533instanceName=sqlserv2012Is this possible?Can you give pointers on how to achieve thisManyThanks,BG

Transactional replication issues

Posted: 13 Apr 2013 08:28 PM PDT

Hello There,I am new to this forum,Could anyone help me with this questions please.I am working in retail industry and has some doubts relating to this topics.Our company has 100 stores and the data has to be replicated to the main subscriber server from all the 100 publishers. We have set up a transnational replication with one distributor. In a region for some 15 stores we have network issues, the data was not replicated to the main server. 1.How can we replicate the data when the network is back to normal ?2.If any of the remote server gets crashed, how do we restore the publication after the server gets normal (what is the procedure to follow) ?- How do we apply changes to remote servers using Transactional Replication· If there was an issue with a certain server, how do we stop and restart replication· How do we apply changes to a replicated server
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Search This Blog