Restore by Tree in Microsoft SQL Server 2000, 2005 or 2008 Cluster Environments
Chapter 5: Backing Up and Restoring in Cluster Environments 79
11.
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.
12.
Click OK.
Note:
We recommend that you use the user name and password of
a domain administrator for machine authentication. Domain administrators
are not dependent on the computer on which the Microsoft SQL Server
instance is still running. Specify a domain user with the format
DomainName\UserName.
13.
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
.
14.
Click OK.Click OK on the Session User Name and Password dialog.
The Submit Job dialog opens.
15.
(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.
16.
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
.