I am trying to restore a sql7 bakup file to sql 2000 server.
I used the following command:
RESTORE DATABASE u_educationalive
FROM DISK = 'd:\edualive_4_28'
Server: Msg 3135, Level 16, State 2, Line 1
The backup set in file 'c:\edualive_4_28' was created by BACKUP DATABASE...FILE=<name> and cannot be used for this restore operation.
Server: Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
-I managed to restore another file from the same server the same way with no issues(I used "with move to get the correct directory").
-I ran "Verifyonly" and it checked out ok.
-I ran "filelistonly" and found that there was no log file backup(not sure if its an issue)
Can anybody help?