Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I have 2 Sql Servers (2008) with Log Shipping setup between them. The receiving server is configured to keep the database in Read-Only mode. When creating a view on the primary server, this view is not copied over to the secondary. It was my believe that any DDL statements are also shipped. Can anyone clarify?

share|improve this question
    
Is the view in the log shipped database? –  gbn Nov 25 '11 at 12:32
    
The view was added to the logshipped database some time after logshipping was started, so yes its in the logshipped db –  edosoft Nov 25 '11 at 14:14
    
What is the delay between shipping the logs over to the standby server, and did you happen check between this delay? Also, are the DML statements being applied to the standby? –  StanleyJohns Nov 25 '11 at 15:53
add comment

1 Answer

All modifications to the source database will be copied over to the target database, assuming that your log shipping process is not broken or blocked. The target database must be in read-only made (which in your case it is) but users accessing the database will prevent SQL from applying the transaction log.

Log shipping needs to be able to put the target database into single-user mode before applying the logfile. This is the one serious drawback of log-shipping. Try disconnecting all users, then wait for log shipping to get caught up. Your view will appear.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.