Transaction log file size 5+ GB

Question

Viewing 7 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Ford Fairlane SSCertifiable Points: 7664 More actions · Answer 1

AB

Once you have shrunk the database you will need to shink the file to free up the space

dbcc shrinkfile (<t-log>, 500) -- shinks the t-log to 500Meg in sise

Hope this helps...

Ford Fairlane
Rock and Roll Detective

Deni Kusdeni Default port Points: 1457 More actions · Answer 2

1. detach database

2. attach database without log file

3. change database recovery option to simple

runaldo SSCommitted Points: 1742 More actions · Answer 3

Or simpler. Change the recovery model to Simple. Backup the database and shrink the file!

Vasily Bycov Newbie Points: 5 More actions · Answer 4

If you need to be able to recover your database you shouldn't change the recovery model to Simple. Just do the following:

1. Make full backup of your database

2. Make transaction log backup. This will reduce your transaction log

Generally it is very good sometimes to look through Books Online

Arvind Bhambhani SSC Rookie Points: 32 More actions · Answer 5

Hi Guys

Thanks for your advice.

The problem has been solved now.

I actually did this ...

Thanks

Vik Nat Hall of Fame Points: 3930 More actions · Answer 6

Another simple way without having to detach/attach

1. BACKUP LOG dbname WITH NO_LOG

2. DBCC SHRINKFILE (log_name, size in MB, truncateonly)

3. Take a full backup immeditely and setup trans log backups on schedule.