Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Reg: Nas Box Backup Expand / Collapse
Author
Message
Posted Friday, March 8, 2013 3:19 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: 2 days ago @ 8:25 PM
Points: 63, Visits: 419
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....


Post #1428487
Posted Friday, March 8, 2013 3:23 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Monday, December 8, 2014 1:45 AM
Points: 5,221, Visits: 5,120
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.




Want an answer fast? Try here
How to post data/code for the best help - Jeff Moden
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
CrossTabs-Part1 & Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger

Post #1428489
Posted Friday, March 8, 2013 3:30 AM


Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Friday, October 31, 2014 10:27 AM
Points: 708, Visits: 3,293
vs.satheesh (3/8/2013)
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....




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

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
Post #1428491
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse