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

Answers

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


Moderation questions? read the FAQ