cambercorp
asked on
restore sql 2000 database to sql 2005 error
I am trying to restore a sql 2000 bak file to a sql 2005 server database using t-sql. my restore statement is:
restore database DATABASENAME from mybackup with replace
The restore completes but with the following error in the messages:
Msg 156, Level 15, State 1, Procedure SYSKEYS, Line 1
Incorrect syntax near the keyword 'FUNCTION'.
The error message comes after the upgrade step from version 539 to 551. The rest of the upgrade steps go off without a problem. Any suggestions?
restore database DATABASENAME from mybackup with replace
The restore completes but with the following error in the messages:
Msg 156, Level 15, State 1, Procedure SYSKEYS, Line 1
Incorrect syntax near the keyword 'FUNCTION'.
The error message comes after the upgrade step from version 539 to 551. The rest of the upgrade steps go off without a problem. Any suggestions?
ASKER
yes, but i want to restore from t-sql.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
that did it doobdave, thanks!
create a new db and right click and restore db and point it to the backup file.