Posted by laststubborn on 07/19/06 09:13

What do you think is it good or bad to remove the second log file ?
what would you do keep the log file or delete it? Is it gonna have any
negative effect on my log back and its size?

by the way this is the code that you recommended

-- Empty the data file
DBCC SHRINKFILE ('Test1data', EMPTYFILE);
GO
-- Remove the data file from the database
ALTER DATABASE AdventureWorks
REMOVE FILE Test1data;
GO


Erland Sommarskog wrote:
> laststubborn (arafatsalih@gmail.com) writes:
> > Could you please give me an example how to do it properly?
>
> Let's see, then I would have to look up the exact syntax in Books Online,
> since I don't know it by heart. As I said, use DBCC SHIRNKFILE with the
> EMPTYFILE option, and then ALTER DATABASE with REMOVE FILE. Please check
> Books Online for the exact syntax. There is also some good text that
> explains what EMPTYFILE is all about.
>
>
> --
> 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]