Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Complete backup include transaction log?
Message
From
04/05/2005 10:53:27
 
General information
Forum:
Microsoft SQL Server
Category:
Backups
Miscellaneous
Thread ID:
01008494
Message ID:
01010775
Views:
19
Hey Sergey,

Thanks for your response.

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)?
Thank You

Rollin Burr

Politicians and diapers have one thing in common. They should both be changed regularly, and for the same reason.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform