 | |
Maintenance and Impersonation?
microsoft.public.sqlserver.tools microsoft.public.sqlserver.tools
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
Maintenance and Impersonation? -
06-18-2008
, 11:40 PM
#2
| |||
| |||
|
|
My SQL Server Agent service runs under a domain account on a member server to do most of its work. Currently there is a maintenance plan step to save a full backup to a local disk. There is a new need for the server to copy the full backup .bak file to a UNC location in a different domain. This remote server requires a specific name/password, different from the account that the Agent Service uses. How can I create an impersonation step in my plan to connect to the remote server as a different Windows user and copy the file? Thanks. |
#3
| |||
| |||
|
|
My SQL Server Agent service runs under a domain account on a member server to do most of its work. Currently there is a maintenance plan step to save a full backup to a local disk. There is a new need for the server to copy the full backup .bak file to a UNC location in a different domain. This remote server requires a specific name/password, different from the account that the Agent Service uses. How can I create an impersonation step in my plan to connect to the remote server as a different Windows user and copy the file? Thanks. |
#4
| |||
| |||
|
|
My SQL Server Agent service runs under a domain account on a member server to do most of its work. Currently there is a maintenance plan step to save a full backup to a local disk. There is a new need for the server to copy the full backup .bak file to a UNC location in a different domain. This remote server requires a specific name/password, different from the account that the Agent Service uses. How can I create an impersonation step in my plan to connect to the remote server as a different Windows user and copy the file? Thanks. |
#5
| |||
| |||
|
|
My SQL Server Agent service runs under a domain account on a member server to do most of its work. Currently there is a maintenance plan step to save a full backup to a local disk. There is a new need for the server to copy the full backup .bak file to a UNC location in a different domain. This remote server requires a specific name/password, different from the account that the Agent Service uses. How can I create an impersonation step in my plan to connect to the remote server as a different Windows user and copy the file? Thanks. |
#6
| |||
| |||
|
|
My SQL Server Agent service runs under a domain account on a member server to do most of its work. Currently there is a maintenance plan step to save a full backup to a local disk. There is a new need for the server to copy the full backup .bak file to a UNC location in a different domain. This remote server requires a specific name/password, different from the account that the Agent Service uses. How can I create an impersonation step in my plan to connect to the remote server as a different Windows user and copy the file? Thanks. |
#7
| |||
| |||
|
|
My SQL Server Agent service runs under a domain account on a member server to do most of its work. Currently there is a maintenance plan step to save a full backup to a local disk. There is a new need for the server to copy the full backup .bak file to a UNC location in a different domain. This remote server requires a specific name/password, different from the account that the Agent Service uses. How can I create an impersonation step in my plan to connect to the remote server as a different Windows user and copy the file? Thanks. |
#8
| |||
| |||
|
|
My SQL Server Agent service runs under a domain account on a member server to do most of its work. Currently there is a maintenance plan step to save a full backup to a local disk. There is a new need for the server to copy the full backup .bak file to a UNC location in a different domain. This remote server requires a specific name/password, different from the account that the Agent Service uses. How can I create an impersonation step in my plan to connect to the remote server as a different Windows user and copy the file? Thanks. |
#9
| |||
| |||
|
|
My SQL Server Agent service runs under a domain account on a member server to do most of its work. Currently there is a maintenance plan step to save a full backup to a local disk. There is a new need for the server to copy the full backup .bak file to a UNC location in a different domain. This remote server requires a specific name/password, different from the account that the Agent Service uses. How can I create an impersonation step in my plan to connect to the remote server as a different Windows user and copy the file? Thanks. |
#10
| |||
| |||
|
|
My SQL Server Agent service runs under a domain account on a member server to do most of its work. Currently there is a maintenance plan step to save a full backup to a local disk. There is a new need for the server to copy the full backup .bak file to a UNC location in a different domain. This remote server requires a specific name/password, different from the account that the Agent Service uses. How can I create an impersonation step in my plan to connect to the remote server as a different Windows user and copy the file? Thanks. |
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.