Customer Support Portal Language
 
Home Knowledge Base Databases My MS SQL transaction log is full, can you help?
Information
Article ID87
Created On5/3/2008
Modified5/3/2008
Actions
My MS SQL transaction log is full, can you help?

Run the following command in query analyser while connected to your database, replace mydatabase with your database name:

DBCC SHRINKFILE(mydatabase_log, 1)
BACKUP LOG mydatabase WITH TRUNCATE_ONLY
DBCC SHRINKFILE(mydatabase_log, 1)

If you are unsure then please contact support.
 
SmarterTrack Free Edition 3.5 | Customer Service Software | © 2008 SmarterTools Inc.