Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to truncate a transaction log file?
Message
From
19/09/2001 11:25:14
Marc Levesque
La Prairie, Quebec, Canada
 
 
To
19/09/2001 11:11:09
Juan Flores
Nocorp
Somewhere, Virginia, United States
General information
Forum:
Microsoft SQL Server
Category:
Other
Title:
Re: How to truncate a transaction log file?
Miscellaneous
Thread ID:
00558317
Message ID:
00558351
Views:
28
> BACKUP LOG myDatabaseName WITH TRUNCATE_ONLY

The command completed successfully. But the size of log file
on the disk is not changed.

MyData_Data.MDF 62528kb
MyData_Log.LDF 1110720kb

Anyway, is it normal the log file is so huge?
Marc Levesque
La Prairie, Quebec (CANADA)
marc.levesque@videotron.ca
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform