Posted by Erland Sommarskog on 09/25/07 07:59

Piero 'Giops' Giorgi (giorgi.piero@gmail.com) writes:
> I'm using SQL Server 2005.
>
> The DB has one table partitioned on 50 Filegroups (One per state)
>
> The DB is right now on my drive G: as are the filegroups (But in
> separate directories), and for a number of reasons, I have to move the
> DB to drive F: but I need to keep the filegroups (With the bulk of the
> data) on drive G:
>
> Question is: How can I move the DB to another drive, leaving the
> filegroups where they are?

This link in Books Online should be useful:
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/ad9a4e92-13fb-457d-996a-66ffc2d55b79.htm


--
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: SQL Query from Access to SQL Server
• Prev in forum: Re: Retrieve ONLY first/max
• Thread view: Re: Moving DB from one drive to another

[Reply to this message]