I backed up the following 2 databases:
aspnetstockPro and stockselectsql to
Then I reinstalled SQL Server 2005. After doing this I had no databases on the server except
System Databases and Database Snapshots.
I need to restore aspnetstockPro and stockselectsql to the server.
They should appear on the Databases list.
I tried to execute the following SQL statement to restore aspnetstockpro :
restore database aspnetstockpro
from disk = 'F:\SQLServerBackups\aspne
new.bak' with replace,
move 'aspnetstockpro' to 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backu
move 'aspnetstockpro_Log' to 'C:\Microsoft SQL Server\Data\aspnetstockpro
Msg 3234, Level 16, State 2, Line 1
Logical file 'aspnetstockpro' is not part of database 'aspnetstockpro'. Use RESTORE FILELISTONLY to list the logical file names.
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
What do I need to do?