Click here to Skip to main content
15,905,419 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I use the following command to backup sql database, it shows error "operation system error 5(access is denied)" when i backup to desktop or root directory otherwise it works well, How to backup my database to desktop? I am using VB.Net 2010, SQL Server 2008.

pDB.subDBExecQuery("BACKUP DATABASE " & pstrDbName & " to DISK = '" & strPath & "' WITH NOFORMAT, NOINIT, NAME = '" & pstrDbName & "', SKIP, STATS = 10", 500)

1 solution

see this thread[^]
Share this answer
kgmmurugesh 18-Jul-14 7:28am    
Good, Is there any way to change the log on as to Local System through code? Is there any side effects while changing the log on as to local system?

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

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900