Click here to Skip to main content
Rate this: bad
Please Sign up or sign in to vote.
See more: VB.NET
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 9: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
0 OriginalGriff 277
1 Maciej Los 230
2 BillWoodruff 205
3 Sergey Alexandrovich Kryukov 195
4 DamithSL 165
0 OriginalGriff 5,130
1 DamithSL 4,157
2 Maciej Los 3,650
3 Kornfeld Eliyahu Peter 3,460
4 Sergey Alexandrovich Kryukov 2,811

Advertise | Privacy | Mobile
Web03 | 2.8.141216.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