BACKUP DATABASE [MPRM] TO DISK = N'\\rauf\shared\MPRM_15_5_10.BAK'
WITH NOFORMAT, NOINIT, NAME = N'MPRM-Full Database Backup',
SKIP, NOREWIND, NOUNLOAD, STATS = 10
The backup process worked, and I got a file with a name MPRM_15_5_10.BAKin my folder shared( D:\shared\). This is a backup created from another computer.
When I try to restore the backup, use the following script
RESTORE DATABASE [MPRM]
FROM DISK = N'\\rauf\shared\MPRM_15_5_10.BAK'
WITH FILE = 1, NOUNLOAD, STATS = 10
I get the following errors:
Msg 5133, Level 16, State 1, Line 1
The directory search for the file "E: \ DATABASES \ MPRM.mdf" failed with an operating system error 2 (the system cannot find the specified file.).
Msg 3156, Level 16, State 3, Line 1 The
file "MPRM" cannot be restored to "E: \ DATABASES \ MPRM.mdf". Use WITH MOVE to determine the valid location of the file.
Msg 5133, Level 16, State 1, Line 1
The directory search for the file "E: \ DATABASES \ MPRM_log.ldf" failed with an operating system error 2 (the system cannot find the specified file.).
Msg 3156, Level 16, State 3, Line 1 The
file "MPRM_log" cannot be restored to "E: \ DATABASES \ MPRM_log.ldf".Use WITH MOVE to determine the valid location of the file.
Msg 3119, Level 16, State 1, Line 1
Problems were identified when planning the RESTORE statement. Previous posts provide detailed information.
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE ends abnormally.
Why *.mdf, *.ldfdoes the system request files ? Is this related to the backup option, not the recovery script?
I logged in using Windows Authentication