Posted by laststubborn on 07/19/06 08:36

Could you please give me an example how to do it properly?

Thanks,

Erland Sommarskog wrote:
> 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

• Next in forum: Re: SQL Server 2005 Script Generation
• Prev in forum: Re: 2005 EE: using full-text indexing
• Thread view: Re: Second Transaction Log File

[Reply to this message]