June 2, 2003 at 1:46 pm
I am moving my existing SQL7 database to a SQL 2000 server. I have a backup of the database and I hope to restore this database to one that has been created on the SQL 2000 server.
The restore will work properly with a single filegroup for the database but I was hoping to create the database with 2 filegroups. I have the server setup with 2 RAID channels and would like to have a file group on each channel.
My question is, is it possible to restore a single filegroup database to a new location with multiple filegroups and how would I do this.
June 2, 2003 at 2:04 pm
You don't really have to create second file group and move database files into it. Simple restore database that has single filegroup into new server, detach the database, move half of database files into second RAID set of disks and re-attach the database back.
June 3, 2003 at 7:54 am
If you want to move specific tables and indexes into second RAID disks then you need create filegroup and database files into the filegroup and recreate cluster indexes on those tables to the second filegroup.
June 5, 2003 at 12:11 pm
Allen I don't really understand your response.
When the tables are created they are assigned to a file group, so the restore would have to follow that.
After the restore, create a second filegroup, then reindex using the/a cluster index for those table you want to move, placing the clustered index, therefore the data, onto the second filegroup.
If you don't want these tables having a clustered index, drop it after the reindex completes.
KlK, MCSE
KlK
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply