I am using MS SQL Server 2012 version RTM, below is our environment,
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?