How to Shrink the Standby database in SQL Server
Log-Shipping was configured in one of the Production servers which was in sync with its respective DR Server.
Due to High transactions happening in the Prod server, Log file was drastically increased and this was creating a problem for me as a DBA. DR server Hardware was not as good as production hardware and there was a disk space crunch.
Question arises now, Can we shrink Standby/Read Only database?
Answer is YES, we can do it but indirectly.
Shrink the PRODUCTION Database and it will reflect to the DR Database as well when the backup of the log gets shipped and restored on DR Database.
I did this practically in 2005 Standard Edition Server and it went successfully.
Hope the above information helps.
Log-Shipping was configured in one of the Production servers which was in sync with its respective DR Server.
Due to High transactions happening in the Prod server, Log file was drastically increased and this was creating a problem for me as a DBA. DR server Hardware was not as good as production hardware and there was a disk space crunch.
Question arises now, Can we shrink Standby/Read Only database?
Answer is YES, we can do it but indirectly.
Shrink the PRODUCTION Database and it will reflect to the DR Database as well when the backup of the log gets shipped and restored on DR Database.
I did this practically in 2005 Standard Edition Server and it went successfully.
Hope the above information helps.
