|
|
Hello !
i'm working on a vb.net 2010 project that use sql server 2008r2 database.
i want to backup database .i'm using this code :
path="c:\\users\user\desktop\backup.bak"
cmd = New SqlCommand("backup database MYDB to disk='" & path & "'", con)
con.Open()
cmd.ExecuteNonQuery()
con.Close()
... but i'm getting an error
Cannot open backup device 'c:\\users\user\desktop\backup.bak. Operating system error 5(Access is denied.).
BACKUP DATABASE is terminating abnormally.
if i change the path to "c:\\bck\backup.bak" , everything works fine.
But i want to backup my database on every destination that i can select.
what can i do ?
|
|
|
|
|
Can you access the user\desktop folder by navigating to it?
This may be a permission issue where you do not have access rights to any files or folders for a particular user - in this case, "user".
|
|
|
|
|
yes , i can access user\desktop folder by navigation
the user that i'm using to test the program is with administrator rights.
|
|
|
|
|
alejx wrote: path="c:\\users\user\desktop\backup.bak"
Why do you have a double backslash after c:, but not after the other parts of the path?
The difficult we do right away...
...the impossible takes slightly longer.
|
|
|
|
|
i try all
c:\\users\user\desktop\backup.bak
c:\users\user\desktop\backup.bak
c:\\users\\user\\desktop\\backup.bak
....
not working
|
|
|
|
|
it does not really matter, you can have as many as you like, up to the point of exceeding the maximum path length.
Remember this is VB, anything goes, and there's no escape in this world.
|
|
|
|
|
Your code is giving you Access Denied because either the path is wrong or the user running your app doesn't have permissions to the specified path. Also, if the SQL Server is not running as the user, it will NOT have permissions to the users folders.
|
|
|
|
|
- the path is ok , and the code works on other folders for example c:\backup\database.bak , doesn't work on folders like c:\users\user\xxxxx... , or directly on c:\ .. etc
- the user that run application has administrator rights
- i don't understand - "if the sql server is not running as the user ?....". Can you explain please?
thank you.
|
|
|
|
|
alejx wrote: - the user that run application has administrator rights
Yes, but is he using them? On Vista and 7, by default, all users, including admins, DON'T use their admin rights unless they are called for.
alejx wrote: - i don't understand - "if the sql server is not running as the user ?....".
Can you explain please?
What account does the SQL Server service run under?? If you don't know, open Task Manager and under the Processes tab, find sqlservr.exe. Next to that, you'll see a column labeled User Name. Which account is the service running under?? I'd be willing to bet it's NETWORK SERVICE, which doesn't have permissions to any user folders...
It's not the user making the backup, it's the SQL Server. The user is just sending a command to the server to do the backup.
|
|
|
|
|
Thank you !
I'm using windows 7 and my user have administrator rights and use them.
on task manager sqlservr.exe process , has Network service on "User name" column.
what can i do , because is very important for my application , to make backups on every local directory or removable media that user select.
Thank you !
|
|
|
|
|
Are you saying that you have SQL Server stored procedures or other SQL Server code making a backup of user files??
|
|
|
|
|
i have a backup form in my application(vB.net) , i choose a folder ( with a folder dialog) and i want to backup sql database in that folder.
The code that i have in my first post , works for some folder but doesn't work on folders like c:\ , c:\users\... etc.
What can i do to backup sql database on every folder i choose.
Thank you.
|
|
|
|
|
I personally would use SMO objects to make your backup rather than sending a query to the database to perfom the backup.
For further reading Creating a SQL Server backup[^]. I know the example is C# but it is very easy to convert.
But as Dave has stated the key to the backup is making sure the user permissions are set up correctly.
Lobster Thermidor aux crevettes with a Mornay sauce, served in a Provençale manner with shallots and aubergines, garnished with truffle pate, brandy and a fried egg on top and Spam - Monty Python Spam Sketch
|
|
|
|
|
ok , but what should i do with user permissions ?
|
|
|
|
|
i'm using NET 4 , and can't use SMO.
|
|
|
|
|
I have a Question for you guys:
Can you guarantee that database can be completed one till date 
|
|
|
|
|
Hi
I have Mdi screen in my project and many mdi child screens,one of these is set to allow maximize as true,after i open this screen and maximize it and then open another mdi child screen , the last screen is maximized automatically but i set the maximize property for it to false.
Any one can help me
|
|
|
|
|
If you maximize one MDI child, ALL the MDI children become maximized. There is no way to change that behavior. The Multiple Document Interface was designed so that your child forms are all the same form editing the same type of documents.
Chances are you're using MDI for a purpose for which it was not designed.
The only way to pull off the behavior you want is to alter your child forms so that instead of maximizing when the button is clicked, they instead resize themselves to the same size as the MDIClient control of the MDIParent form.
|
|
|
|
|
gimana yah cara buat print faktur...tolong ya...pemula nih 
|
|
|
|
|
adizi, This site's main language is English. So please post your question in English. At the very least, use google translate[^]
Translation: adizi, Site ini menggunakan bahasa inggris sebagai bahasa utama. Tolong tulis pertanyaan anda dalam bahasa inggris. Paling tidak, gunakan google translate[^]
OT:Check How to Print Invoice using VB.NET?[^] (google[^]'s first hit)
Oxfords English < Official CCC Players Dictionary
Excuse me for my improper grammar and typos.
It's because English is my primary language, not my first language.
My first languages are C# and Java.
VB, ASP, JS, PHP and SQL are my second language.
Indonesian came as my third language.
My fourth language? I'm still creating it, I'll let you know when it's done! 
modified 27-Oct-11 2:13am.
|
|
|
|
|
HI, James my name is, india i am from. I want to make an 'operating system' (like windows 7) with visual basic. i know do not visual basic, i is willing to learn. Time i do not have, and i cannot spend more than day on tis project.
/james - the master of kolkata
|
|
|
|
|
You'll have quite the busy day then...
I think you need to research what an operating system is, and how it works.
Plus, while I have no issues with VB, it's def the wrong tool in this case.
|
|
|
|
|
Why do I get the feeling that this is a troll? Doesn't make any sense at all. First you want an operating system, like Windows 7 no less!, and then you can't spend more than a day? An operating system takes months/years of development work, let alone testing, creating device drivers, low level controllers, etc...
Definitely a troll. "KILL HIM!"  I'm kidding! REALLY! Sheesh! 
|
|
|
|
|
Can't be a serious question...
I vote for a troll, too
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
