| Re: Remove large (old) log file from SIMPLE model database? |
|
 |
|
 |
|
 |
|
 |
Group: microsoft.public.sqlserver.setup · Group Profile
Author: Roy Harvey (SQL Server MVP)Roy Harvey (SQL Server MVP) Date: Sep 16, 2008 10:28
On Tue, 16 Sep 2008 10:01:15 -0700, £Jim wrote:
>I have a database where the recovery model was changed to SIMPLE a
>while back. There is still a 300GB log file attached to it although it
>is not being updated. How can I detach and delete the file? (SQL2005)
Just because the database is in SIMPLE mode does not mean the log file
is not being used. Even then everything is written to the log. That
is required the way SQL Server manages the log and data pages, and
handles COMMIT and ROLLBACK.
So you still need a log file, just not one quite so large. Look up
DBCC SHRINKFILE for instructions on making it smaller.
Roy Harvey
Beacon Falls, CT
| 
