October 2, 2003 at 10:48 am
I am trying to upgrade a 7.0 database to 2000. I tried backup and restore. But during the restore process, it is creating additional file groups. Is that the right behavior? Can I keep the same file groups as the original?
What is the safest way of upgrading a 7.0 database to 2000? Thank you for your help!
October 2, 2003 at 11:47 am
Is your 7.0 database created in multiple file groups? What additional file groups were created during the restoration?
Both backup/restore and sp_detach_db/sp_attach_db work for you to upgrade 7.0 database to 2000.
October 2, 2003 at 11:49 am
The 7.0 database was created in two file gorups. During the restore to 2000, under options, three file groups showed up by default.
October 2, 2003 at 12:05 pm
Are you tring to restore using EM? Under options, I can't see file groups showing up. Can you state how do you perform the restoration?
October 2, 2003 at 12:20 pm
EM - Restore from device - Read from Media - Options. Maybe it is not filegroups, just data files.
October 2, 2003 at 12:23 pm
Yes, there are MDF and LDF files. sp_helpfile will tell you all those files your database has.
October 2, 2003 at 2:26 pm
These are data files in the original database. Thanks, Allen.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply