SQL Server - Replication Failed
Purpose: Move database files to a standard location
Steps:
1) Tried to detach database but failed because database is setup forreplication (publisher).
2) Generated scripts for dropping and creating replication
3) Ran the script for dropping replication (i.e. distribution databasewas removed)
4) Detached, moved, and re-attached database
5) Ran the script for creating replication (i.e. distribution databasewas re-created)
6) Recieved error because failed to login and subscription settings inthe publisher was not created by the script
7) Fixed the problem in 6) seventeen hours later. Therefore, nothingpublished or subscribed during this period of time. Databases not in-sync.
Question:
- Since the distribution database was re-created, did I lost all thedata since last subscription?
- After the problem was fixed in 6), does the publisher pickup fromthe last published transaction (i.e. seventeen hours ago)?
- How can I fix this problem? Can it re-sync by reading from thedatabase transaction log file?
Thanks,
Eliza