I need a little help with a restore process, I can't find specific help in other similar questions, sorry if my question does not correspond.
I have this script in my system:
RESTORE DATABASE [Basesistema] FROM DISK = N’C:\Sistema\backup.bak’ WITH FILE = 1, NOUNLOAD, REPLACE, STATS = 10
It work perfect in Windows XP, but not in Windows 7…
The message is:
Error al buscar el archivo ‘C:\Archivos de programa\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\DATA\Basesistema.mdf’ en los directorios, error del sistema operativo: 3(failed to retrieve text for this error. Reason: 15105)
English translation:
Failed to find file 'C: \ Program Files \ Microsoft SQL Server \ MSSQL10.SQLEXPRESS \ MSSQL \ DATA \ Basesistema.mdf' directories, operating system error: 3 (failed to retrieve text For This error. Reason: 15105)
What can I do? Thanks for your help!!
Followup:
Well, actually I need restore from a script embedded in my system, not from SSMS; but SSMS (even as Admin) did not have access to the backup file. If I move the file to C: or D: is the same...
I have SQL running under Windows Autentication account (integrated security), my only windows account have admin rights... I don't understand what happens.
The curious is the path "MSSQL10.SQLEXPRESS" doesn't exists, SQL is in "..\MSSQL10_50.SQLEXPRESS\MSSQL..". Does this have something to do?