Posted by Piero 'Giops' Giorgi on 09/24/07 23:04

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: PHP code to Stored Procedure
• Prev in forum: Re: SET NO_BROWSETABLE ON ?
• Thread view: Moving DB from one drive to another

[Reply to this message]