Posted by Erland Sommarskog on 07/18/06 19:09

laststubborn (arafatsalih@gmail.com) writes:
> I have a dillema that I created 2 transaction file before I started to
> take log back. Now I changed my recovery model from simple to full. Do
> I still need to keep my second transaction file? If I remove it would
> it be a problem for my system and log back up?

You can remove it if you like, but you should do it properly with
DBCC SHRINKFILE (EMPTYFILE) and ALTER DATABASE.

--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]