Upgrade wizard...

greenspun.com : LUSENET : SQL Server Database Administration : One Thread


I am using Upgrade Wizard to upgrade from SQL Server 6.5 to 7.0? I know that we can add or delete files from the file layout, we can also change the size of the file, change the file path etc etc. I would like to know this.

1. Can I specify .mdf file to use PRIMARY filegroup? 2. Can I specify .ndf file to use SECONDARY filegroup? 3. While specifying the size of the file should it be in KB?

Thanks in advance,


-- Anonymous, June 09, 2000



I concur with your other correspondents. I would just let the Upgrade Wizard handle the transfer and then make modification once the database was converted to SQL Server 7.0 format.

Good Luck,


-- Anonymous, June 21, 2000

Moderation questions? read the FAQ