Restore issue

SQL 2012 , I think I have an express install (doesn't say in @@version) and i'm trying to restore a db from a full version, I don't know if that's germane to the issue....but when I run :
USE [master]
RESTORE DATABASE [WebCMMS_DEV_EDFWB] 
From Disk=N'C:\DownloadedToKeep\EncaData\WebCMMS_DEV_EDFWB.bak'
WITH  FILE = 1,  
MOVE N'EDF_WBTQ4_7_9_8' TO N'C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\WebCMMS_DEV_EDFWB.mdf',  
MOVE N'EDF_WBTQ4_7_9_8_log' TO N'C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\WebCMMS_DEV_EDFWB_log.ldf',  
NOUNLOAD,  REPLACE,  STATS = 1
GO

Open in new window

I've got the list of files from running "restore filelistonly " , but the error i'm getting is :
The operating system returned the error '5(Access is denied.)' while attempting 'RestoreContainer::ValidateTargetForCreation' on 'C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\WebCMMS_DEV_EDFWB.mdf'.
(The db doesn't exist on the target server....should it?)
Silas2Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Scott PletcherSenior DBACommented:
That's usually a permissions error.  The account running SQL Server doesn't have permission to write to that directory.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Silas2Author Commented:
Thanks, that does seem to be running now.
I'm restoring to a non-program files folder, does SQL server mind that?
0
Brian CroweDatabase AdministratorCommented:
You just need to give the user that your SQL Server service is running under access to whatever folder you want to use.
0
Anthony PerkinsCommented:
SQL 2012 , I think I have an express install (doesn't say in @@version)
Do it this way:
SELECT SERVERPROPERTY('Edition')
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.