Restore Databases Using Restore by Session Method
62 Agent for Microsoft SQL Server Guide
10.
Verify or change the user name or password for the Windows computer on
which Microsoft SQL Server is loaded. To verify or change the user name or
password, follow these steps:
a.
Select a session on the Machine tab and click Edit. The Enter User Name
and Password dialog opens.
b.
Enter or modify the user name and password.
c.
If a session password was assigned to this session, enter the session
password.
d.
To apply the user name and password you entered to all the sessions you
are restoring, select the Apply [User Name and Password] to all rows
option.
Click OK.
11.
Verify or change the user name or password for the database servers to
which you are restoring. To verify or change the user name or password for
the database servers, follow these steps:
a.
Select the DBAgent tab.
b.
Select a session and click Edit. The Enter User Name and Password
dialog opens.
c.
Enter or modify the user name and password.
d.
If you want the user name and password you entered applied to all the
sessions you are restoring, select the Apply [User Name and Password]
to all rows
option
.
Click OK.
12.
Click OK on the Session User Name and Password dialog. The Submit Job
dialog opens.
13.
(Optional) Use the Submit Job dialog to select the job execution time, submit
the job on hold, add an optional job name for the backup job, or select
source priority.
14.
Click OK to submit this job. If you selected Run Now, the Job Status window
opens. Use this window to monitor your job. For more information about the
Job Status window, see the
Administration Guide
.
