SQL Server 2008 log file growing and wont shrink. Hard Drive Space running out

Asked Jun 05 '13 at 19:34

Active Jun 05 '13 at 21:24

Viewed 22 times

I have a SQL Server 2008 database which has a log file (.ldf) with a size of 360GB and growing every day.

The .mdf file is only 25GB. The hard drive is 950 GB and has 150GB free space. I want to shrink this log file so that it doesn't overrun the hard drive on the server.

I used dbcc shrinkfile('my database log file name', 0) but unfortunately, it doesn't shrink the file. Now I know I need to take a log backup and then run the shrink command for the file to shrink.

My problem is that I don't have enough hard drive space to take a log backup.

Is there anyway I can shrink this file?

The database is on FULL RECOVERY MODE with mirroring ON. Please advise. Any tips to avoid this problem in the future would also be appreciated.

edited Jun 05 '13 at 21:24

Kin Shah

62,225
6
120
236

asked Jun 05 '13 at 19:34

1

Do you do backups? Full recovery model, mirroring - if there are no backups and/or an issue with mirroring the log HAS to fill up to do it's job. – TomTom Jun 05 '13 at 21:27
How frequently the transaction log backup runs? and what is the output of ==> select log_reuse_wait_desc,* from sys.databases – Kin Shah Jun 05 '13 at 21:37
@Cougar9000 Can you point to the link/s ? – Kin Shah Jun 05 '13 at 22:12
Do DBCC CHECKPOINT – Stoleg Jun 06 '13 at 08:01

SQL Server 2008 log file growing and wont shrink. Hard Drive Space running out

0 Answers0