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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Log Shipping & Schema Changes

Author  Topic 

davy_boy2000
Starting Member

28 Posts

Posted - 2002-09-24 : 10:08:17
Does anyone know if schema changes are replicated when using log shipping?

For example, Log Shipping setup from Server A to Server B. Table structure changes made on Server A. Are these table changes made on server B when the log is restored?

davy_boy2000
Starting Member

28 Posts

Posted - 2002-09-24 : 11:12:13
Tested it myself, and it takes over schema changes, stored procedures etc...

Go to Top of Page

royv
Constraint Violating Yak Guru

455 Posts

Posted - 2002-09-24 : 11:36:04
Whatever operations are logged will be replicated with the log shippping.

*************************
Someone done told you wrong!
Go to Top of Page
   

- Advertisement -