SQL 2000 database Restore error from TAPE
Posted on 2007-11-20
I am trying to restore SQL 2000 database called 'CBAS' from tape using backupexec 9.1 but i am getting following error message. I can restore others SQL databases on the same tape on the same server but it is just with this perticular database 'CBAS'. I think according to the following error it seems that this database backup contains more than one log files and while restoring, backupexe try to combine into one log file 'cbas_log.LDF' and fails.
I donot know how and where to use WITH MOVE clause under veritas backupexec.
Please help me to solve this issue and advise a working solution. thanks.
An error occurred on a query to database CBAS.
File 'T:\CBASLOG\cbas_log.LDF' is claimed by 'CBAS_1_Log'(4) and 'CBAS_Log'(2). The WITH MOVE clause can be used to relocate one or more files.
thanks & regards