Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
NeilG
Aged Yak Warrior
530 Posts |
 Posted - 2009-09-03 : 09:32:42
|
| I'm testing a few systems at the moment, and i've restored a backup file from a system which does have replication onto a system that doesn't and it moves over the replication details etc. However when i try to replicate the same on a local system this doesn't happen.I'm just really asking for advice on this one as i'm unable to find an answer on the web as to why this would happen, so thought you clever guy might be able to helpCheersNeil--------------------------SQL Server MCP & MCTS |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2009-09-03 : 10:00:20
|
| On the one that is working, are you sure you haven't turned replication on? Also, do you have linked/remote servers already set up to your subscribers or at least netwrok connectivity to be able to see the subscribers?On your local system, this will not be set up if you are not part of the domain and haven't got any linked/remote servers set up. |
 |
|
|
ScottWhigham
Starting Member
49 Posts |
Posted - 2009-09-03 : 10:31:07
|
| Hi Neil - I'm confused as to the use of the word "replicate" in the second sentence ("However when i try to replicate the same on a local system this doesn't happen."). By "replicate", do you mean that you are trying to do the same thing - or are you using "replicate" to mean "I'm trying to set up SQL Server replication on my local instance with this database and it isn't working."========================================================I have about 1,000 video tutorials on SQL Server 2008, 2005, and 2000 over at http://www.learnitfirst.com/Database-Professionals.aspx |
|
|
|
|
|
|
Replication on restore