November 21, 2003 at 10:37 am
I have added a second log file to a database in order to resolve an error. After the problem is resolved I would like to drop this log file. Is there a way to do this?
TIA
November 21, 2003 at 11:02 am
I believe you can remove it if there are no virtual files. You'd need to shrink that file to 0 before you could remove it.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
November 21, 2003 at 11:03 am
Backup the log and then use
ALTER DATABASE <dbname> REMOVE FILE <logical file name>
--Jonathan
--Jonathan
November 21, 2003 at 11:36 am
Thanks for the input.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply