SQL 2005 to -> SQL 2008 database replication
Posted on 2013-06-06
We are new to database replication, and we have been unable to find the answer to our questions by just using Google.
We are replicating a SQL 2005 database to SQL 2008, in order to have a disaster recovery area.
However, when we setup the SQL 2005 -> SQL 2008 replication, it appears to not be working correctly. Here's the situation:
We have successfully synced up the databases between the two. However, when we look up the size of the SQL 2008 replicated database, it's only 4 MB in size! And the original database (publisher) is actually 20 MB in size.
Should the replication sync the entire database (and transaction logs with it), to match exactly the database that is being replicated? (As it is now, we can't failover to this replicated database because it's now a full databases.)
Obviously we are missing something here.
What should we do to make both databases exactly alike, so that we can failover to the replicated one should we need to?