I have a database that I wish to temporarily change the recovery mode on to simple so that I may forcefully shrink the transaction log(due to maintenance tasks screwing up and not reducing the file)
My question is :-
Can i change the recovery model to simple without breaking the merge replication on this database?? Then change it back to full?
Server : SQL 2008 server
Compatability level : SQL server 2000 (80)
Recovery model currently : Full