Import data into SQLserver7 database.greenspun.com : LUSENET : SQL Server Database Administration : One Thread |
When I try to import data into sqlsever 7 database, I get the error 'The backed-up database has no-disk structure versin 539, the server supports version 515 and cannot restore or upgrade database. Backup or restore operation terminating abnormally'Could anybody post the solution very soon...
-- Anonymous, May 30, 2002
Venkata,It appears that you are trying to import SQL Server 2000 data into SQL Server 7. The only way to move a SQL Server 2000 database to a SQL Server 7.0 server is by transferring the data using a method such as Data Transformation Services (DTS), bcp , or use of a query between linked servers.
Hope this helps,
Eric
-- Anonymous, May 30, 2002