Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: VB.NET
hi All
 
Error:
 
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 9:21am
Rate this: bad
good
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.
  Permalink  
Rate this: bad
good
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.
  Permalink  

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

  Print Answers RSS
0 Maciej Los 310
1 OriginalGriff 285
2 Afzaal Ahmad Zeeshan 200
3 Sergey Alexandrovich Kryukov 195
4 BillWoodruff 180
0 OriginalGriff 6,499
1 Sergey Alexandrovich Kryukov 6,048
2 DamithSL 5,193
3 Manas Bhardwaj 4,657
4 Maciej Los 4,120


Advertise | Privacy | Mobile
Web04 | 2.8.1411022.1 | Last Updated 19 Apr 2013
Copyright © CodeProject, 1999-2014
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