How to grant access on backup shared in PDW
To backup the database we have to assign access permissions to a windows account that has write access to a file share on a target server.
sp_pdw_add_network_credentials '10.10.10.10','corp\adAcctLogin', 'PassWord'
To remove access to shared path
sp_pdw_add_network_credentials '10.10.10.10','corp\adAcctLogin', 'PassWord'
To check who are all having permissions
select * from sys.dm_pdw_network_credentials
No comments:
Post a Comment