SQL Enterprise Manager
Databases
Emerald (double-click on it)
Truncate the Transaction Log
This will tell you that you should do a diskdump right afterwards, so you
should do that as well
right-click on the Emerald database and choose Backup/Restore
Make sure that Database Backup displays Emerald.
Select a Backup Device (I created one a while back called
"Emerald_diskdump", but you can use the generic "diskdump"
too)
Click on Backup Now. (you may have to click on the Initialize
Device checkbox first)
That should take care of it.
Josh Hillman
hillman@talstar.com
----------
> From: Warren Kipp <kippw@titanlink.com>
> To: emerald@iea.com
> Subject: SQL Transaction Log is full.
> Date: Wednesday, March 26, 1997 2:23 PM
>
> Hi Dale or anyone. I wanted to delete some of my old start records via a
> sql statement provided by Dale, but it tells me my transaction log is
full
> and to basically dump it.
>
> Can someone tell me how to do this and any repercussions? Enterprise
> Manager indicates that the transaction log is using space shared with
the
> data. I don't know if this makes any diff.
>
> When I dump the transaction log, what actually is getting deleted? Any
> history records for the users?
>
> Hope you excuse my SQL ignorance.
>
> Warren
>
>
> ----------------------------------------------------------
> Emerald Mailing List listserver@emerald.iea.com