Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Complete backup include transaction log?
Message
 
 
To
04/05/2005 10:53:27
General information
Forum:
Microsoft SQL Server
Category:
Backups
Miscellaneous
Thread ID:
01008494
Message ID:
01010779
Views:
24
This message has been marked as the solution to the initial question of the thread.
>
>I finally have time to take another look at this. I have a large log file (over 12 Gig). I have done transaction backups, but the log is still large. I have gone into 'shrink database', and chosen to shrink the log file, but it does not make much, if any difference.
>
>How do I get the transaction log to empty itself and get down to a manageable size (and keep it there)?

Check INF: Shrinking the Transaction Log in SQL Server 2000 with DBCC SHRINKFILE mskb #272318
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform