<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
SQL Server 2005
»
Backups
»
Reg: Nas Box Backup
Reg: Nas Box Backup
Rate Topic
Display Mode
Topic Options
Author
Message
vs.satheesh
vs.satheesh
Posted Friday, March 08, 2013 3:19 AM
Valued Member
Group: General Forum Members
Last Login: Friday, May 17, 2013 12:47 AM
Points: 53,
Visits: 296
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
anthony.green
anthony.green
Posted Friday, March 08, 2013 3:23 AM
SSCertifiable
Group: General Forum Members
Last Login: Friday, April 12, 2013 3:51 AM
Points: 5,075,
Visits: 4,831
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
Abu Dina
Abu Dina
Posted Friday, March 08, 2013 3:30 AM
SSC-Addicted
Group: General Forum Members
Last Login: Today @ 3:53 AM
Points: 489,
Visits: 2,139
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.
-----------------------------------
http://www.SQL4n00bs.com
Post #1428491
« Prev Topic
|
Next Topic »
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
