June 28, 2002 at 3:34 am
SQL Server 2000
The database files are distributed in 2 physical disks (which are assigned to 2 user defined filegroups). My task is to move (merge) data from these files to 1 physical disk (the second disk will be removed). I have tried to alter the file's size and filegrowth to zero, but sql server does not accept it since the size was smaller than the current size.
Is there a way to move/relocate/merge the database files ? Thanks for any response.
June 28, 2002 at 3:51 am
In EM right click on the DB - All tasks - Detach Database. Then move the files and attach the files back to the SQL Server using All Tasks - Attach database.
Regards,
Andy Jones
.
June 28, 2002 at 4:24 am
Take a look at BOL - DBCC Shrinkfile using the Emptyfile parameter, I think it will be a better solution than detach/attach.
Andy
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply