Want to work with us? We're on the lookout for a Magento Developer.
We're hiringRestore Database - SQL Server
11 March 2011
by Web Bureau
Ran into this problem today when trying to restore a database using the following code:
RESTORE DATABASE
WITH REPLACE db_Name
FROM DISK = ' C:\db_name_FullBackup_20090624_1737.bak'
Basically i did not have the correct permission to run this command.
The solution i found was to open Management studio using 'Run As Administrator' - after that all worked fine!!