Posted by Dan Guzman on 09/25/07 01:49

> Question is: How can I move the DB to another drive, leaving the
> filegroups where they are?

Exactly what do you mean by "move the DB"? You can detach the database,
move some or all of the files and then reattach using CREATE DATABASE...FOR
ATTACH.


--
Hope this helps.

Dan Guzman
SQL Server MVP

"Piero 'Giops' Giorgi" <giorgi.piero@gmail.com> wrote in message
news:1190675053.287080.189090@d55g2000hsg.googlegroups.com...
> Hi!
>
> 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?
>
> Thank you!!!
>
> P
>

• Next in forum: Re: Retrieve ONLY first/max
• Prev in forum: Re: PHP code to Stored Procedure
• Thread view: Re: Moving DB from one drive to another

[Reply to this message]