CODEWITHSUNDEEP
sql-server-2005
vandana sharma
vandana sharma

Reputation: 191

How to reduce ldf file size if we have applied replication on database

I have a Database that is using replication. Now I want to reduce the LDF file size (currently the size of the LDF is 6 GB).

I did "shrink" the LDF files, but it shrank only a few MBs. We need to look for other options for it because these database are using replication. Is any solution available for it?

Upvotes: 3

Views: 5169

Answers (1)

Dalex
Dalex

Reputation: 3625

You should change database recovery model to "simple" and then use

dbcc shrinkdatabase('database_name').

After this you will have an empty log.

Then do not forget to change recovery model back to "Full"

Upvotes: 11

Related Questions