In the following command I try to shrink my log file down to 1GB. DBCC SHRINKFILE (‘SalesHistory_Log’, 1000) Also, make sure that your databases are NOT set to auto-shrink.

So I have a specific database that won't release and shrink its log files. The DB backups are happening successfully, but I still have 4GB of logfiles (and no, this DB does not generate 4GB of log ...

This code is used to add a new log file to the database using the alter database command. Method 2-Recover Database from an Existing Backup If you fail to rebuild the corrupted Log files, then you can ...

In addition to your .MDF file, you will have an accompanying .LDF. The .LDF contains database log information, which SQL Server uses to maintain database integrity. If you have this file, make ...

I have a SQL 2000 SP4 server and MOM 2005 is reporting that the tempdb database log file is getting to large.

Using the Transact SQL ALTER DATABASE statement to shrink the transaction log file Open SQL Server Management Studio (SSMS) and click Query Analyzer to open the Query Analyzer window.

Procedure to move Microsoft SQL Server database to a new location, painlessly, if you’re running low on disk space, added a new drive array, or just curious.