Can we shrink datafile of a database which is configured with log shipping
I have a primary database Server A and Secondary Database Server B Log shipping configured on A to B of a database,
1) Database size 500 GB, We would like to delete old data and make it to 250 GB, Can we do this without breaking of log shipping?
2) After this we need to shrink the data file not log file, Can we shrink data file without breaking of log shipping?
If we do shrinking do i need to stop log shipping jobs or will it break log shipping configuration?
If the logshipping secondary is in Standby mode, then the data file shrink get replicated. But the same is not possible if the logshipping is configured in Norecovery mode.