En el query analizer hice lo que me dijiste:
RESTORE DATABASE MiDatabase
FROM DISK = 'E:\Base\MiDatabase.BAK'
y me tiro los siguientes errores:
Código:
Server: Msg 5105, Level 16, State 2, Line 1
Device activation error. The physical file name 'e:\database\MiDataBase_Data.MDF' may be incorrect.
Server: Msg 3156, Level 16, State 1, Line 1
File 'MiDataBase_Data' cannot be restored to 'e:\database\MiDataBase_Data.MDF'. Use WITH MOVE to identify a valid location for the file.
Server: Msg 5105, Level 16, State 1, Line 1
Device activation error. The physical file name 'e:\database\MiDataBase_Log.LDF' may be incorrect.
Server: Msg 3156, Level 16, State 1, Line 1
File 'MiDataBase_Log' cannot be restored to 'e:\database\MiDataBase_Log.LDF'. Use WITH MOVE to identify a valid location for the file.
Server: Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
Me falta agregar algo mas??