shrinking transaction log

to find the log name –
select name from sys.database_files where type = 1

to shrink to a specified target size –
DBCC SHRINKFILE (DataFile1, 7);  –where 7 = 7MB

Leave a Reply

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.