March 8, 2013 at 3:19 am
Hi
In my company we are using network nas storage.which i am able to share the folder in nas storage using user name and password using run command.But through automatic sql scheduled Query backup is throwing error as Access denied.I am using following sql command
exec ('BACKUP DATABASE [' + @DBName + '] TO DISK = N''\\192.168.0.242\Backups\ScheduleDBBkup\202server\vtu\' +
@DBFileName + '.bak'' WITH NOFORMAT, INIT, NAME = N''' +
@DBName + '-Full Database Backup'', SKIP, NOREWIND, NOUNLOAD, STATS = 100')
In this above Query :\\192.168.0.242\Backups\ScheduleDBBkup\202server\vtu\ is Nas link address.
Please give me solution....
March 8, 2013 at 3:23 am
Ensure SQL server service is running as a domain account
Give that domain account permissions on the share
Or
Backup to local disk, and run something like robocopy
Or
Map a network drive at backup time in a cmd step giving username and password to create the path, then backup.
March 8, 2013 at 3:30 am
vs.satheesh (3/8/2013)
HiIn my company we are using network nas storage.which i am able to share the folder in nas storage using user name and password using run command.But through automatic sql scheduled Query backup is throwing error as Access denied.I am using following sql command
exec ('BACKUP DATABASE [' + @DBName + '] TO DISK = N''\\192.168.0.242\Backups\ScheduleDBBkup\202server\vtu\' +
@DBFileName + '.bak'' WITH NOFORMAT, INIT, NAME = N''' +
@DBName + '-Full Database Backup'', SKIP, NOREWIND, NOUNLOAD, STATS = 100')
In this above Query :\\192.168.0.242\Backups\ScheduleDBBkup\202server\vtu\ is Nas link address.
Please give me solution....
I may have had this problem in the past and what I did was I Remote Desktoped to the SQL Server Box (using the domain account setup for the SQL Server Service to run) then though Windows Explorer I tried to access the backup folder on the NAS. It then promted me to enter the username and password which I did (this was the same as the one the SQL Server Service Account). I then ticked the save password checkbox and clicked okay. I was then able to see contents of folder on NAS.
After that, you should be able to run the job.
---------------------------------------------------------
It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
David Edwards - Media lens[/url]
Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
Howard Zinn
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply