1554feb3   
   XPost: microsoft.public.sqlserver.server   
   From: esquel@sommarskog.se   
      
   harifajri@gmail.com (harifajri@gmail.com) writes:   
   > i need help.   
   > I have a server HP G6, with MS SQL 2008 installed on it.   
   > My "Drive C" is almost full.   
   > My "database.mdf" dan "database.ldf" is on drive C.   
   >   
   > I plan to buy a new hard disk and then next time i will have a Drive   
   > 'D'.   
   >   
   > Is it posible in SQL 2008 if my drive C is full, then my   
   > "database.mdf" on drive C,   
   > will continue (automatically) to drive D?   
      
   No, you can't do that.   
      
   But you can add a second file to the filegroup, and put that new file on   
   the new disk. You should also turn off autogrow on the original file.   
      
   But it may be better in the long run to move the database file to the new   
   disk entirely.   
      
   See the command ALTER DATABASE in Books Online about these operations.   
   There is a specific topic "Moving Database Files" that can be of interest.   
      
   --   
   Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se   
      
   Links for SQL Server Books Online:   
   SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx   
   SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx   
   SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)