Hi Team,
I have 2 ldf file for a database and I want to empty and remove 1 log file and second log file I want to move it to new drive.
SQL Server 2008 R2 version. There is merge replication in place for this database and service broker enabled to push the transaction data from this db to another reporting db.
How can I accomplish this without breaking the replication/service broker.....and is it possible ?
If someone can break down the steps, will be much appreciated. thanks.