|
|
|
Old Hand
 
Group: General Forum Members
Last Login: Tuesday, June 09, 2009 1:25 AM
Points: 304,
Visits: 390
|
|
I have one network device ..
in thos i have created folder backup and it open with username and password only..
i have take backup to this '\etdev\bakup\master.bak
It raised error liike:
Msg 3201, Level 16, State 5, Line 1
Cannot open backup device '\\etdev\bakup\master.bak. Operating system error 86(The specified network password is not correct.).
Msg 3013, Level 16, State 1, Line 1
BACKUP DATABASE is terminating abnormally.
and i have tried it with mapping those drive in my local..and then backup to it..but getting error like 'network name not found'
Thanks & Regards,
Paresh Prajapati
 +919924626601
prajapati.paresh@yahoo.com
|
|
|
|
|
Old Hand
Group: General Forum Members
Last Login: 2 days ago @ 2:24 AM
Points: 330,
Visits: 506
|
|
Dear
Is your firewall off?
Thanx
Thanks,
Ajay Gupta
"Feel Fear And Do It AnyWay"
|
|
|
|
|
Old Hand
Group: General Forum Members
Last Login: Wednesday, May 27, 2009 7:17 AM
Points: 302,
Visits: 59
|
|
First test your domain authentication by clicking on start then goto run and then type in the path :\\ folder\folder
It will then ask for username and password, when typing in username put domain first : "domain"\"username" and then enter password . It should then authenticate.
Same should be done for the backup job.
|
|
|
|
|
Old Hand
Group: General Forum Members
Last Login: Tuesday, June 09, 2009 1:25 AM
Points: 304,
Visits: 390
|
|
not it is on,
and when i have mapped that drive, i can see and open..
and aslo open from directly \etdev\backup\ from my local machine..
buit backup can not done
Thanks & Regards,
Paresh Prajapati
+919924626601
prajapati.paresh@yahoo.com
|
|
|
|
|
Old Hand
Group: General Forum Members
Last Login: Wednesday, May 27, 2009 7:17 AM
Points: 302,
Visits: 59
|
|
| Then the problem is with the User account executing the backup job in SQL . Is it a SQL login or a windows Authenticated login ?
|
|
|
|
|
Old Hand
Group: General Forum Members
Last Login: Tuesday, June 09, 2009 1:25 AM
Points: 304,
Visits: 390
|
|
SQL logins..
But i think concern with network storege device?
Thanks & Regards,
Paresh Prajapati
+919924626601
prajapati.paresh@yahoo.com
|
|
|
|
|
Old Hand
Group: General Forum Members
Last Login: 2 days ago @ 2:24 AM
Points: 330,
Visits: 506
|
|
Dear
1. Please off your firewall from both side(from system and from NAS(Network Attached Storage device))
2. Then check the RW(read / write)permission on the folder.
3. Then see that the sql user's (UserId and Password) and Folder's (UserId and Password) are how related?
Thanx
Thanks,
Ajay Gupta
"Feel Fear And Do It AnyWay"
|
|
|
|
|
SSC Journeyman
Group: General Forum Members
Last Login: 2 days ago @ 9:42 AM
Points: 89,
Visits: 495
|
|
To confirm this is a permissions problem, set the share and NTFS permissions on the remote backup folder to "Everyone" - Change Control / Modify
Then try and re-run the backup.
|
|
|
|
|
SSChasing Mays
Group: General Forum Members
Last Login: Thursday, July 02, 2009 6:49 AM
Points: 607,
Visits: 1,036
|
|
I wouldn't switch my firewall off on either side ... If you want to do that, definitely make sure someone senior gives you the go ahead - preferably in writing. Though more likely they'll tell you that there's no need to switch the firewall off to grant folder access.
I wouldn't grant 'Everyone' access on a directory either. Things like that may seem no big deal at the time, but then someone forgets to change the permissions back, data gets into the wrong hands and everyone's looking at you.
Start at the beginning and check out the directory permissions as has been suggested.
|
|
|
|
|
Old Hand
Group: General Forum Members
Last Login: Thursday, July 02, 2009 7:23 AM
Points: 382,
Visits: 789
|
|
| Why not backup to a local drive and copy the backup to the network drive?
|
|
|
|
