December 5, 2002 at 11:57 pm
We have this as a scenario.
We have transactional replication happening on our main database server. Now we have to implement Log Shipping to the stand by server given by the client. We have changes in the replication articles at the publisher(main server) which happens quite frequently. Since we want to implement the Log Shipping, i would like to know whether i need to Log Ship the "msdb" database also to my stand by server, so that what ever changes are done for the Replication at my main server also affects to my standby server. So that when i switch to my standby server, i dont have to do all the changes which have been done on the main server.
Hoping to have a nice disscussion about this subject from u all SQL gurus.
Regards
Jay
December 9, 2002 at 7:05 am
Nice and simple.
I am not sure that you can use log shipping and replication in the manner that you describe. The reason being is that the subscriber will be subscribed to your main server and so when you activate the standby it won't work.
Have a look at http://msdn.microsoft.com/library/default.asp?url=/library/en-us/replsql/replbackup_3js7.asp
Simon Sabin
Co-author of SQL Server 2000 XML Distilled
http://www.amazon.co.uk/exec/obidos/ASIN/1904347088
Simon Sabin
SQL Server MVP
http://sqlblogcasts.com/blogs/simons
December 9, 2002 at 7:10 am
Nice and simple.
I am not sure that you can use log shipping and replication in the manner that you describe. The reason being is that the subscriber will be subscribed to your main server and so when you activate the standby it won't work.
Have a look at http://msdn.microsoft.com/library/default.asp?url=/library/en-us/replsql/replbackup_3js7.asp
Simon Sabin
Co-author of SQL Server 2000 XML Distilled
http://www.amazon.co.uk/exec/obidos/ASIN/1904347088
Simon Sabin
SQL Server MVP
http://sqlblogcasts.com/blogs/simons
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply