Question Locked

Can a SQL Snapshot be undone?

0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I am trying to implement a replication system in sql 2000 and in doing so have seriously messed up my database. When taking the initial snapshot of the database an new column was added called rowguid. I didn't realize when setting the replication up that sql server was actually going to add a column to the original table. This new addition to 4 tables (and whatever else that was done) has messed the tables so that the program that needs to read them now cannot operate.

Before I go in an start deleting columns, is there anyway to undo the actions of a snapshot? Glod bless you all for any help you can give me!

1 reply

This discussion is closed to new replies.