April 5, 2011 at 7:06 am
Hi forum,
I want to setup a transactional replication between a SQL 2008 server (publisher+distr) and a SQL 2005 server (subscriber) without a snapshot.
I can accomplish this with the option 'allow initialization from backup files'
that part I know because we already use that between 2 SQL 2005 servers without any problem.
But with SQL 2008 server I can't restore my backup file on my SQL 2005 server !
Can somebody help me with this one ? workaround ?
Extra info :
- OS both servers = Windows 2008 Server StdEd 64bit
- database to replicate is 350GB
As always thanks for your input
Steven
April 5, 2011 at 9:41 pm
There is no workaround for this method - you cannot restore a database to any earlier version of SQL Server.
If you don't want to use a snapshot, you will need to build a functionally equivalent method to deliver the data to your subscriber.
If the reason that you don't want to use a snapshot is something like network bandwidth (and you would copy a database backup to CD/DVD and send that to the subscriber), you can also do this with a snapshot. You can setup the publication so that its snapshot folder is a local drive (e.g. D:\MySnapshot\). Copy all the files in that drive to the subscriber, placing them in the subscriber in the same path (i.e. in D:\MySnapshot at the subscriber) and the get the subscription up and running. When the distribution agent tries to find the files for the snapshot, it will look for D:\MySnapshot and does not particularly care that this drive is local to the subscriber.
Hope that makes sense.
April 5, 2011 at 10:24 pm
This is normal behavior. You can't go from 2008 to 2005. I would look into a different method or get both servers up to SQL 2008.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 6, 2011 at 1:33 am
Hey guys thnx for quick reply and your time.
April 6, 2011 at 10:55 am
you're welcome.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply