Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Shrink transaction log
Message
From
19/04/2002 08:12:54
 
 
To
18/04/2002 14:35:30
Dave Sonier
Technologies Nter inc.
Gatineau, Quebec, Canada
General information
Forum:
Microsoft SQL Server
Category:
Backups
Miscellaneous
Thread ID:
00646470
Message ID:
00646842
Views:
19
Try using DBCC SHRINKFILE to shrink the transaction log file.

DBCC SHRINKFILE(logical name of the transaction log, new size)

You can check the BOL for more info on DBCC SHRINKFILE.

You will not be able to shrink the file past an open transaction. You can use DBCC OPENTRAN() to determine if there's an open transaction in the database.

-Mike
Michael Levy
MCSD, MCDBA
ma_levy@hotmail.com
Previous
Reply
Map
View

Click here to load this message in the networking platform