Hello,
I have a SQL 2000 DB. Current tables in sql 2000 DB are in single file. I am planningto migrate the DB to sql 2005. I am going to partition the tables in sql 2005 and have multiple files. What is the best way to do this? Would backup/restore work? If I restore onto sql 2005 from sql 2000 backup, will the tables spread over different files automatically or not? Any ideas will be appreciated...
Thanks........
Using Backup/Restore may be the 'safest' method to migrate a database. Be sure to rebuild the indexes and update the statistics after restoring.
Once restored, you can add new files for the database.
Refer to this link for the steps to move tables to the new files.
http://sqljunkies.com/HowTo/B9F7F302-964A-4825-9246-6143A8681900.scuk
(And most likely, you really don't want tables to 'stripe' across multiple files.)
No comments:
Post a Comment