1
Answer

Error appearing during Restoring

Ask a question
Abdu Rafeeq

Abdu Rafeeq

13y
1.4k
1

 
iam tried to restore database back up to another database,,,
 i got error meesage
error message"

Msg 5133, Level 16, State 1, Line 1

Directory lookup for the file "C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\\\JewelSoft29.mdf , move 'JewelSoft_log to 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\\\JewelSoft29_log.ldf " failed with the operating system error 123(The filename, directory name, or volume label syntax is incorrect.).

Msg 3156, Level 16, State 3, Line 1

File 'JewelSoft' cannot be restored to 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\\\JewelSoft29.mdf , move 'JewelSoft_log to 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\\\JewelSoft29_log.ldf '. Use WITH MOVE to identify a valid location for the file.

Msg 3119, Level 16, State 1, Line 1

Problems were identified while planning for the RESTORE statement. Previous messages provide details.

Msg 3013, Level 16, State 1, Line 1

RESTORE DATABASE is terminating abnormally.

(1 row(s) affected)

"




how to solve?



Answers (1)