views:

132

answers:

0

Possible Duplicate:
SQL Server 2005 Transaction Log too big

I am running SQL Server 2005.

My db backup scheme is: Recovery model: FULL Backup Type: Full Backup component: Database Backup set will expire: after 0 days Overwrite media: Back up to the existing media set, Append to the existing backup set

The db is writing to 250GB drive (232GB actual).

My _Data.mdf file is over 55GB and my _Log.ldf is over 156GB.

We ran into a situation where our drive was filled today. I moved our ab_Full.bak and ab_Log.bak files to another drive to make space - about 45GB. Now, free space is at 31GB.

I don't think there is any way that I can make another backup of the db and transaction log.

How can I get the size of the transaction log down? Can I shrink it without performing a backup?

Can I create a new full backup of the db that allows me do delete the existing transaction log; thus, freeing alot of space and creating a new transaction log?

I'm running out of space quickly and, I fear, options too.

Thanks, Joel