HostWeb Forums » Microsoft Databases » microsoft.public.sqlserver.server » Backup/Restore to UNC in seperate domain
Topic: Backup/Restore to UNC in seperate domain
Hello All,
I've got a series of SQL Servers (single servers and clusters) that have
their SQL service running under local Windows or AD IDs. We are in the
process of utilizing NAS storage that is not part of our AD infrastructure
but has Windows-like security as the target location for backups to be stored
on.
How can a database backup be performed to a target NAS UNC if the SQL
Server’s AD ID does not have permissions to that target NAS device? Can
something similar to the OS level ‘Run As’ security feature be utilized to
permit this to occur without having the SQL Service ID having direct
permissions on the target NAS device?
Thanks
Replies below ↓
Replies
Backup/Restore to UNC in seperate domain
Hello All,
I've got a series of SQL Servers (single servers and clusters) that have
their SQL service running under local Windows or AD IDs. We are in the
process of utilizing NAS storage that is not part of our AD infrastructure
but has Windows-like security as the target location for backups to be stored
on.
How can a database backup be performed to a target NAS UNC if the SQL
Server’s AD ID does not have permissions to that target NAS device? Can
something similar to the OS level ‘Run As’ security feature be utilized to
permit this to occur without having the SQL Service ID having direct
permissions on the target NAS device?
Thanks