I have configured logshipping with stand by option for reporting purpose. Please find the configuration details as below as
Primary Server: SQL 2005 sp3 EE 64 bit
log backup frequency: every 15 min
Secondary Server: SQL 2005 sp3 EE 64 bit
restore frequency: every 2 hours
Mode: stand by mode(secondary server's db is in read only mode for reporting purpose)
here my questions are
1. when i do index rebuilding operations on a table in the primary server, will the indexes on the table in the secondary server also be rebuilt? i hope index rebuilding is fully logged operation. or do i have to configure the separate maintenance plan on the secondary server to rebuild the indexes?
if the database is in bulk logged mode what will happen?
2. how do i find when the index was rebuilt last?
Please help me on this.
Thanks in advance.
View Complete Post