jesinj (2/3/2011)

---

Hi

Have a question on shrinking datafile when its log shipped.

When the secondary database is setup in standby mode and i shrink the data file on the primary the change is carried over to the secondary database and the secondary database is also shrunk. I could see the file has reduced in size when i go to the file path through explorer.

But when the secondary database is in norecovery mode the shrink on the primary does not seem to be applied at the secondary database. The file size does not change at the secondary server.

However when i recover the database on the secondary the file does shrink.

Any idea why this happens?