February 26, 2007 at 8:27 pm
How do you go about restore a T-Rep if you accidentally set the replicated DB as not "published" and the publication folder was wiped out.
PS. do not have the create script
Any inputs would be greatly appreciated.
February 26, 2007 at 10:43 pm
Create the replication folder manually first...
Then cleanup your database and its publications and subscriptions if any exists...
If you have replication script use it to recreate it otherwise do it through replication wizard...
How come any one remove the replication accidentally...it is multi step process....
MohammedU
Microsoft SQL Server MVP
February 26, 2007 at 11:10 pm
the thing is I didn't actually drop/delete the t-rep
what I did was the following:
sp_dboption 'DBname', 'published', 'false'
once the script was ran, the t-rep tied to this DB was wiped out.
Tried to set the value back to 'true' doesn't help.
Any ideas on how to get the t-rep back??
February 27, 2007 at 10:28 am
Could you not load a backup of the database and generate the scripts from there?
Carlos
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply