Never mind, I found my solution...
take DB offline
detach database
rename transaction log file
re-attach database WITHOUT transaction log
SQL Server creates small transaction log file
Problem solved!
On 7/20/07, Rick Root <[EMAIL PROTECTED]> wrote:
> I have a problem with our database server. We have a database that we
> load from text files every day... the db itself is about 9 gb. The
> log settings is "bulk logged" and I don't perform backups.
>
> Unfortunately, it still logs SOME stuff... and the transaction log is
> now 55 gig
>
> Problem is... I have no room on the server now to perform a
> transaction log backup, and I can't shrink the file because it's
> pretty much all allocated.
>
> How do I get rid of the transaction log?
>
> Can I detach the database and then re-attach it without the log file?
>
> --
> Rick Root
> Check out CFMBB, BlogCFM, ImageCFC, ImapCFC, CFFM, and more at
> www.opensourcecf.com
>
--
Rick Root
Check out CFMBB, BlogCFM, ImageCFC, ImapCFC, CFFM, and more at
www.opensourcecf.com
~|
CF 8 â Scorpio beta now available,
easily build great internet experiences â Try it now on Labs
http://www.adobe.com/cfusion/entitlement/index.cfm?e=labs_adobecf8_beta
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284187
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4