Click here to Skip to main content
13,052,033 members (37,365 online)
Rate this:
Please Sign up or sign in to vote.
See more:
hi All


Access to the path 'C:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\DATA\SMD.mdf' is denied.

I Used Code:

system.IO.File.Copy(("C:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\DATA\SMD.mdf"), newname)

Please tell me.. how to make path
Posted 19-Apr-13 8:21am
Rate this: bad
Please Sign up or sign in to vote.

Solution 2

You can't read the file because it's still attached by the SQL Server engine. You have to unattach the database in SQL Server before you can touch it.

Really, making a backup is not an operation for your application code. This is normally done as a scheduled task in SQL Server. A DBA usually sets this up.
Rate this: bad
Please Sign up or sign in to vote.

Solution 1

You do not have access to the folder with your current user - you either need to impersonate a user who does have access permissions, or change the permissions on the folder. The other thing to consider is that since this is in an SQL DATA folder, there is a good chance that the file is going to be in use by SQL when you try to copy it, and the copy will fail because the file is in use.

If this is an SQL database, why not back it up using SQL itself instead? This might help: Backing up an SQL Database in C#[^] (it's in C#, but teh code shoudl translate very easily.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy | Mobile
Web02 | 2.8.170713.1 | Last Updated 19 Apr 2013
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100