Using Network Shares (UNC) with domains
osc
Posts: 6
Background Details:
I just downloaded SQL Backup and attempted to backup a local database to a network share: \\BKPSHARE\Folder. The share is also mapped to the Z: drive.
The share currently has full access share rights to the following groups:
DEV\Administrators
PROD\Developers
My domain username is PROD\osc and I am in the group PROD\Developers and I also have explicit full access to \\BKPSHARE\Folder
Description of Problem:
When I try to backup using SQL Backup to the location "\\BKPSHARE\Folder\test.sqb", I experience an error "Failed to create backup folder : \\BKPSHARE\Folder". Using Windows Explorer through a mapped drive or via \\BKPSHARE\Folder, I am able to create/delete/read files.
Is there anything I am missing or doing wrong? Any help is appreciated.
Thanks.
I just downloaded SQL Backup and attempted to backup a local database to a network share: \\BKPSHARE\Folder. The share is also mapped to the Z: drive.
The share currently has full access share rights to the following groups:
DEV\Administrators
PROD\Developers
My domain username is PROD\osc and I am in the group PROD\Developers and I also have explicit full access to \\BKPSHARE\Folder
Description of Problem:
When I try to backup using SQL Backup to the location "\\BKPSHARE\Folder\test.sqb", I experience an error "Failed to create backup folder : \\BKPSHARE\Folder". Using Windows Explorer through a mapped drive or via \\BKPSHARE\Folder, I am able to create/delete/read files.
Is there anything I am missing or doing wrong? Any help is appreciated.
Thanks.
Comments
SQL Backup Consultant Developer
Associate, Yohz Software
Beyond compression - SQL Backup goodies under the hood, updated for version 8
It could be LocalSystem, which would explain why you have no access to the network share.
SQL Backup Consultant Developer
Associate, Yohz Software
Beyond compression - SQL Backup goodies under the hood, updated for version 8
I was prompted twice for this username (once upon initial installation and the second upon the first backup task creation).
Thanks again.