Posted by Erland Sommarskog on 07/19/06 08:52

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]