I am trying to RESTORE a SQL2003 database and receiving the following error:
Server: Msg 3234, Level 16, State 2, Line 2
Logical file 'maxprod' is not part of database 'maxdev'. Use RESTORE FILELISTONLY to list the logical file names.
Server: Msg 3013, Level 16, State 1, Line 2
RESTORE DATABASE is terminating abnormally.
I referenced this solution http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/knowledgeBaseEntry.jsp?qid=21493697
But I'm not able to get past the first step to achieve the next which is to rename the files.
Here is my statement:
RESTORE DATABASE maxdev
FROM DISK='C:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\maxpro
WITH MOVE 'maxprod' TO 'D:\maxdevdatabase\maxprod
MOVE 'maxprod_log' TO 'D:\maxdevlogs\maxprod_log
I can NOT use the same named database because it already exists in the enterprise. Generally speaking what I'm trying to accomplish is to have a development version of my production database "maxprod".