I did a backup of one SQL database hosted on my web service, and after I copy the file on my C:\Wutemp disk.
I'd like to import this database on my MSSQL installed on my local pc in order to have the same web site in local.
I try to restore it with enterprise manager (..using Restore) but I receive a lot of error message:
(I translate from Italian so..be patient..)
The filename 'C:\Program Files\Microsoft SQL Server\MSSQL\Data\mioDB_DATA.mdf' could be not correct.
Impossible to restore the file 'miodb_Data' in 'C:\Program Files\Micorosft SQL Server\MSSQL\Data\mioDB_DATA.mdf'. Use WITH MOVE in oreder to identify a valid location for the file
The filename 'C:\Program Files\Microsoft SQL Server\MSSQL\Data\mioDB_Log.LDF'could be not correct
Impossible to restore the file 'miodb_Log' in 'C:\Program Files\Micorosft SQL Server\MSSQL\Data\mioDB_Log.ldf'.
Any suggestions?you need to set the path it will restore to in the options section of the restore dialog. make sure it points to a valid local directory. if in doubt, look this up in Books Online - it's very clearly explained.
No comments:
Post a Comment