How to reduce log size of database in SQL Server 2008 r2?

Asked Jan 21 '16 at 13:05

Active Jan 21 '16 at 13:05

Viewed 164 times

I have a database with mydb.mdf file size in 4GB and mydb.ldf is 400GB, how to reduce this log .ldf file?

asked Jan 21 '16 at 13:05

Ahad

If `FULL` - `BACKUP LOG`, If `SIMPLE` - `DBCC SHRINKFILE` – Devart Jan 21 '16 at 13:07
Already tried ... but no effect on log size – Ahad Jan 21 '16 at 13:07
Please answer on the first question... We don't have a crystal ball – Devart Jan 21 '16 at 13:07
3

[How to shrink the SQL Server log](http://rusanu.com/2012/07/27/how-to-shrink-the-sql-server-log/) – Remus Rusanu Jan 21 '16 at 13:08
2

I think your problem solved by following links Try this http://stackoverflow.com/questions/829542/how-do-i-decrease-the-size-of-my-sql-server-log-file – ArsalanK Jan 21 '16 at 13:11

0 Answers0