Reverse log shipping -- sql server clustering

N.
1/31/2007 3:19:40 PM

We are in the planning stage of a redundant SQL environment and had a
question about log shipping.

We would like to double our use of the standby server and use it as a
pre-production server from time to time. Meaning, we would like to import
and test data on our standby server and then be able to log ship the changes
over to the primary server. Is this possible/recommended? If so, how would
it be done ?

Thanks
Nick

Kevin3NF
2/1/2007 7:29:54 AM

No.

Your better option is to move the DDL changes by script, or by using a 3rd
party tool such as Red Gate's SQL Compare.

You can move data using Script, DTS/SSIS, Red Gate's SQL Data Compare, etc.

You cannot change the data/schema in a Log Shipping Destination server
(whether its the Prod box or the standby) without Recovering it first, which
stops the Log Shipping part.

--
Kevin Hill
3NF Consulting
http://www.3nf-inc.com/NewsGroups.htm

Real-world stuff I run across with SQL Server:
http://kevin3nf.blogspot.com

[quoted text, click to view]

sql server clustering : Reverse log shipping