kcwallace Posted July 7, 2006 Posted July 7, 2006 I have a SQL Server 2000 database that has a log file that is entirely too big. The file has grown to be 12 Gb. I tried to shrink it using the Shrink wizard where it says that it only needs 230 Mb. However, after the wizard runs the file remains the same size. The database is backed up nightly. How do I reduce its footprint, and prevent it from growing so big? Quote Go Beavs!!!
Administrators PlausiblyDamp Posted July 7, 2006 Administrators Posted July 7, 2006 How are you backing up the SQL Database? Are you using the builtin support (either directly or via a 3rd party) or just backing up the physical files? If you are using the built in routines then it should be truncated on a sucessful full backup / log backup. You can always clear it by doing a BACKUP LOG WITH NO_LOG and then try to shrink it again. Quote Posting Guidelines FAQ Post Formatting Intellectuals solve problems; geniuses prevent them. -- Albert Einstein
kcwallace Posted July 7, 2006 Author Posted July 7, 2006 Thank you very much. I am using builtin routines. I did what you suggested and it did the trick. Thank you Quote Go Beavs!!!
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.