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?
Mahesh ChandPosted Mar 31, 2011, 12:23 PM
1. Mare sure the syntax is correct including the full path of the database
2. Make sure database is not in use
3. Make sure log file is in the same folder as the database file