Knowledge Base - .NET, C#, SQL Server 2005, PHP and Actionscript 2.0 / 3.0 etc

I. Â Shrink the log file size at the right time

I found out this trick:

 Immediately after I use the SSIS package or Import the data to the database ( highlight the database->Tasks->Import data … ), or Export the data from the database ( highlight the database->Tasks->Export data … ),  I can shrink the log file to the desired size, for example, 1MB.  That is, highlight the database->Tasks->Shrink->Files

 set the file size, say, 1MB.

Then, click OK and you are done.

Â

Â

II. Eliminate the log file completely

Sometimes we just do not need the big log file. For example, I have 40GB log file. IÂ am sure I do not need this log file and want to get rid of it completely to free up the hard drive space. The logic is

a. Detach the database

b. Rename the log file

c. Attach the database without the log file

d. Delete the log file

Â

Let’s say, the database name is testDev. In the SQL Server Management Studio,

1. Highlight the database-> Tasks->Detach..-> Click OK
2. Go to log file folder -> rename the testDev_log.ldf to be like testDev_log-aa.ldf,
3. Highlight Databases->Attach…-> Click Add -> add the database testDev, highlight the log file and click the ‘Remove’ button. This means you only attach testDev.mdf
4. After this is done, you can verify the contents of the attached database and then delete the log file.

Â

This way we can safely delete the log file and free up the space.

http://www.codeproject.com/useritems/truncate_log_SQL_server.asp?df=100&forumid=315417&exp=0&select=1655485