question

Chitrarekha avatar image
Chitrarekha asked

Connecting to replication database

I have followed the link below http://www.sql-server-performance.com/2010/transactional-replication-2008-r2/ and I can create SQL Server Replication Snapshot Bulk-copy Data File, SQL Server Replication Snapshot Index Script, SQL Server replication Snapshot Script, Sql Server Replication Snapshot Schema Script. However on a failure condition how do I connect the data to the Replication files so the database is looking into the replication folder.
sql-server-2008replication
1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

KenJ avatar image KenJ commented ·
can you explain what type of failure condition you expect or are experiencing? I'm also not quite sure what "connect the data to the Replication files so the database is looking into the replication folder" means. Can you elaborate?
0 Likes 0 ·

1 Answer

·
Chitrarekha avatar image
Chitrarekha answered
I guess I am having issues understanding the steps required to perform transactional replication. Just now I learned that Replication are of two kinds Transactional and Merge Replication. Do you know of a good article that I can follow to learn and implement replication.
1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

KenJ avatar image KenJ commented ·
SQL Server Central has a 6-part "stairway" series on replication that covers both of those types of replication. I would suggest that you read through that to get started. It can be found here - http://www.sqlservercentral.com/stairway/72401/
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.