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.
| Author |
Topic |
|
mandragoras
Starting Member
1 Post |
 Posted - 2006-09-13 : 09:54:20
|
| I have an SQL Server 2005 (ServerA) hosting the application DB(DatabaseA) accessed by many customers who insert, update, delete , select data.I need another database (DatabaseB) on another SQL Server 2005 (ServerB) for development purposes but i need also this db to be updated with the real data of DatabaseA.I decided to implement log shipping between DatabaseA (primary) and DatabaseB (secondary).When I change the schema of a table in DatabaseB (e.g. in table T1 I add a nullable column) then the log shipping doesnt work (ie if i insert a record in ServerA.DatabaseA.T1, there is no insertion into the ServerB.DatabaseB.T1)Could you please tell me if there is any answer to this problem?Should I choose another feature of SQL Server 2005 and not log shipping? If yes, which is the feature that meets my requirements?Thanks |
|
|
|
|
|
Log Shipping Problem to the secondary server