Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Shrinking Transaction Log

Status
Not open for further replies.
jmeadows7

jmeadows7

IS-IT--Management
Jun 13, 2001
148
US
I have a database that is approximately 5GB; however, the the log space has been increased to about 8GB. I am in the process of upgrading the database from 12 to 15. I want to re-create the database with a reasonable size log segment, but when I recover, I can't seem to figure out how to reduce the log size from 9GB to a reasonable size without going to the trouble of creating a blank database and re-creating all the objects from scratch and migrating the data.

Sybase doesn't seem to have an answer - does anyone here have any idea how to shrink a transaction log?

Thanks,
 
Status
Not open for further replies.

Similar threads

positraction
  • Locked
  • Question
Tracing or Logging of Sybase ASA
Replies
0
Views
97
positraction
positraction
fanszeri
  • Locked
  • Question
Sybase Transaction dumps
Replies
2
Views
57
fanszeri
fanszeri
HROCKS
  • Locked
  • Question
Log File Filling Up
Replies
1
Views
52
HROCKS
HROCKS
aspijker
  • Locked
  • Question
usage device from data and log to only data
Replies
2
Views
56
aspijker
aspijker
rocco
  • Locked
  • Question
Removing Log Allocation from Database
Replies
0
Views
55
rocco
rocco

Part and Inventory Search

Sponsor

Back
Top